1)你有一个兼容的寄存器。
compliants(CompliantID,Comp.Date,IpAdress,ProblemDesc,RESP)
兼容的ID自动生成吗??如果RESP。管理开始与M001这样的......
如果网络的人是负责与N001开始,如果别人是与负责O001这样开始。
任务2:
_____
创建一个表,为解决。并采取你自己的领域。一旦该标准得到解决,记录被移动从投诉解决。
任务3:
作为仪表板的形式,并显示在数据网格中的所有投诉。
如果没有任何符合中,7天后的时间解决,该记录将显示红色。
编码标准
1)所有脚本文件
2)用于存储程序。
3)前端代码必须是在业务对象,而不是在事件。 4)命名标准必须严格执行。
{C}/*this is class file */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
namespace compliants
{
#region class compliants
class compliants
{
#region variables
SqlConnection connection;
SqlCommand command;
SqlDataReader dr;
#endregion variables
#region properties
public int ID
{ get;
set;
}
public string compliantID
{
get;
set;
}
public DateTime compliantDate
{
get;
set;
}
public string IpAddress
{
get;
set;
}
public string ProblemDescription
{
get;
set;
}
public string Responsibility
{
get;
set;
}
#endregion properties
#region methods
public void Savecompliants(compliants objcompliants)
{
compliantID = objcompliants.compliantID;
compliantDate = objcompliants.compliantDate;
IpAddress = objcompliants.IpAddress;
ProblemDescription = objcompliants.ProblemDescription;
Responsibility = objcompliants.Responsibility;
}
/* public string GenerateID(String compliantID)
{
connection = connectionHelper.GetConnection();
SqlCommand cmd = new SqlCommand("select top 1 CompliantID from Compliants where CompliantID like '" + compliantID + "%' order by ID DESC",connection);
connection.Open();
string c = compliantID;
object b = command.ExecuteScalar();
string num = "";
if (b == null)
{
num = c + "001";
}
else
{
num = b.ToString();
int n=Convert.ToInt32(num.Substring(1,num.Length-1));
n++;
if (n >= 1 && n <= 9)
num = c+"00"+n;
if (n >= 10 && n <= 99)
num = c+"0"+n;
if (n >= 100 && n <= 999)
num = c+n;
}
connection.Close();
return compliantID;
}*/
public string Insertcompliants()
{
connection = connectionHelper.GetConnection();
command = new SqlCommand("proccomplaint", connection);
connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@compliantID",compliantID);
command.Parameters.AddWithValue("@CompliantDate",compliantDate);
command.Parameters.AddWithValue("@IpAddress",IpAddress);
command.Parameters.AddWithValue("@ProblemDescription",ProblemDescription);
command.Parameters.AddWithValue("@Responsibility",Responsibility);
command.ExecuteNonQuery();
string compliantid =Convert.ToString(command.Parameters["@CompliantID"].Value);
return compliantid;
}
#endregion methods
}
#endregion class compliants
}