/// <summary>
/// 获得数据列表
/// </summary>
public List <JMP.MDL.CsCustomerServiceRecord> DataTableToList(DataTable dt)
{
List <JMP.MDL.CsCustomerServiceRecord> modelList = new List <JMP.MDL.CsCustomerServiceRecord>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
JMP.MDL.CsCustomerServiceRecord model;
for (int n = 0; n < rowsCount; n++)
{
model = new JMP.MDL.CsCustomerServiceRecord();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
model.AskScreenshot = dt.Rows[n]["AskScreenshot"].ToString();
if (dt.Rows[n]["ResponseDate"].ToString() != "")
{
model.ResponseDate = DateTime.Parse(dt.Rows[n]["ResponseDate"].ToString());
}
model.ResponseScreenshot = dt.Rows[n]["ResponseScreenshot"].ToString();
model.HandleDetails = dt.Rows[n]["HandleDetails"].ToString();
model.EvidenceScreenshot = dt.Rows[n]["EvidenceScreenshot"].ToString();
if (dt.Rows[n]["CompletedDate"].ToString() != "")
{
model.CompletedDate = DateTime.Parse(dt.Rows[n]["CompletedDate"].ToString());
}
if (dt.Rows[n]["HandlerId"].ToString() != "")
{
model.HandlerId = int.Parse(dt.Rows[n]["HandlerId"].ToString());
}
model.HandlerName = dt.Rows[n]["HandlerName"].ToString();
if (dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["AuditStatus"].ToString() != "")
{
if ((dt.Rows[n]["AuditStatus"].ToString() == "1") || (dt.Rows[n]["AuditStatus"].ToString().ToLower() == "true"))
{
model.AuditStatus = true;
}
else
{
model.AuditStatus = false;
}
}
model.No = dt.Rows[n]["No"].ToString();
if (dt.Rows[n]["AuditByUserId"].ToString() != "")
{
model.AuditByUserId = int.Parse(dt.Rows[n]["AuditByUserId"].ToString());
}
model.AuditByUserName = dt.Rows[n]["AuditByUserName"].ToString();
if (dt.Rows[n]["AuditDate"].ToString() != "")
{
model.AuditDate = DateTime.Parse(dt.Rows[n]["AuditDate"].ToString());
}
if (dt.Rows[n]["Grade"].ToString() != "")
{
model.Grade = int.Parse(dt.Rows[n]["Grade"].ToString());
}
if (dt.Rows[n]["WatchId"].ToString() != "")
{
model.WatchId = int.Parse(dt.Rows[n]["WatchId"].ToString());
}
if (dt.Rows[n]["HandelGrade"].ToString() != "")
{
model.HandelGrade = int.Parse(dt.Rows[n]["HandelGrade"].ToString());
}
if (dt.Rows[n]["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(dt.Rows[n]["ParentId"].ToString());
}
if (dt.Rows[n]["NotifyWatcher"].ToString() != "")
{
if ((dt.Rows[n]["NotifyWatcher"].ToString() == "1") || (dt.Rows[n]["NotifyWatcher"].ToString().ToLower() == "true"))
{
model.NotifyWatcher = true;
}
else
{
model.NotifyWatcher = false;
}
}
if (dt.Rows[n]["NotifyDate"].ToString() != "")
{
model.NotifyDate = DateTime.Parse(dt.Rows[n]["NotifyDate"].ToString());
}
if (dt.Rows[n]["MainCategory"].ToString() != "")
{
model.MainCategory = int.Parse(dt.Rows[n]["MainCategory"].ToString());
}
if (dt.Rows[n]["SubCategory"].ToString() != "")
{
model.SubCategory = int.Parse(dt.Rows[n]["SubCategory"].ToString());
}
if (dt.Rows[n]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(dt.Rows[n]["CreatedOn"].ToString());
}
if (dt.Rows[n]["CreatedByUserId"].ToString() != "")
{
model.CreatedByUserId = int.Parse(dt.Rows[n]["CreatedByUserId"].ToString());
}
if (dt.Rows[n]["DeveloperId"].ToString() != "")
{
model.DeveloperId = int.Parse(dt.Rows[n]["DeveloperId"].ToString());
}
model.DeveloperEmail = dt.Rows[n]["DeveloperEmail"].ToString();
if (dt.Rows[n]["AskDate"].ToString() != "")
{
model.AskDate = DateTime.Parse(dt.Rows[n]["AskDate"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CsCustomerServiceRecord model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CsCustomerServiceRecord model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CsCustomerServiceRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CsCustomerServiceRecord(");
strSql.Append("AskScreenshot,ResponseDate,ResponseScreenshot,HandleDetails,EvidenceScreenshot,CompletedDate,HandlerId,HandlerName,Status,AuditStatus,No,AuditByUserId,AuditByUserName,AuditDate,Grade,WatchId,HandelGrade,ParentId,NotifyWatcher,NotifyDate,MainCategory,SubCategory,CreatedOn,CreatedByUserId,DeveloperId,DeveloperEmail,AskDate");
strSql.Append(") values (");
strSql.Append("@AskScreenshot,@ResponseDate,@ResponseScreenshot,@HandleDetails,@EvidenceScreenshot,@CompletedDate,@HandlerId,@HandlerName,@Status,@AuditStatus,@No,@AuditByUserId,@AuditByUserName,@AuditDate,@Grade,@WatchId,@HandelGrade,@ParentId,@NotifyWatcher,@NotifyDate,@MainCategory,@SubCategory,@CreatedOn,@CreatedByUserId,@DeveloperId,@DeveloperEmail,@AskDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AskScreenshot", SqlDbType.NVarChar, 255),
new SqlParameter("@ResponseDate", SqlDbType.DateTime),
new SqlParameter("@ResponseScreenshot", SqlDbType.NVarChar, 255),
new SqlParameter("@HandleDetails", SqlDbType.NVarChar, -1),
new SqlParameter("@EvidenceScreenshot", SqlDbType.NVarChar, 2000),
new SqlParameter("@CompletedDate", SqlDbType.DateTime),
new SqlParameter("@HandlerId", SqlDbType.Int, 4),
new SqlParameter("@HandlerName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@AuditStatus", SqlDbType.Bit, 1),
new SqlParameter("@No", SqlDbType.NVarChar, 12),
new SqlParameter("@AuditByUserId", SqlDbType.Int, 4),
new SqlParameter("@AuditByUserName", SqlDbType.NVarChar, 50),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@Grade", SqlDbType.Int, 4),
new SqlParameter("@WatchId", SqlDbType.Int, 4),
new SqlParameter("@HandelGrade", SqlDbType.Int, 4),
new SqlParameter("@ParentId", SqlDbType.Int, 4),
new SqlParameter("@NotifyWatcher", SqlDbType.Bit, 1),
new SqlParameter("@NotifyDate", SqlDbType.DateTime),
new SqlParameter("@MainCategory", SqlDbType.Int, 4),
new SqlParameter("@SubCategory", SqlDbType.Int, 4),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@CreatedByUserId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperEmail", SqlDbType.NVarChar, 80),
new SqlParameter("@AskDate", SqlDbType.DateTime)
};
parameters[0].Value = model.AskScreenshot;
parameters[1].Value = model.ResponseDate;
parameters[2].Value = model.ResponseScreenshot;
parameters[3].Value = model.HandleDetails;
parameters[4].Value = model.EvidenceScreenshot;
parameters[5].Value = model.CompletedDate;
parameters[6].Value = model.HandlerId;
parameters[7].Value = model.HandlerName;
parameters[8].Value = model.Status;
parameters[9].Value = model.AuditStatus;
parameters[10].Value = model.No;
parameters[11].Value = model.AuditByUserId;
parameters[12].Value = model.AuditByUserName;
parameters[13].Value = model.AuditDate;
parameters[14].Value = model.Grade;
parameters[15].Value = model.WatchId;
parameters[16].Value = model.HandelGrade;
parameters[17].Value = model.ParentId;
parameters[18].Value = model.NotifyWatcher;
parameters[19].Value = model.NotifyDate;
parameters[20].Value = model.MainCategory;
parameters[21].Value = model.SubCategory;
parameters[22].Value = model.CreatedOn;
parameters[23].Value = model.CreatedByUserId;
parameters[24].Value = model.DeveloperId;
parameters[25].Value = model.DeveloperEmail;
parameters[26].Value = model.AskDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.CsCustomerServiceRecord GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, ResponseScreenshot, HandleDetails, EvidenceScreenshot, CompletedDate, HandlerId, HandlerName, Status, AuditStatus, AuditByUserId, AuditByUserName, No, AuditDate, Grade, WatchId, HandelGrade, ParentId, NotifyWatcher, NotifyDate, MainCategory, SubCategory, CreatedOn, CreatedByUserId, AskDate, AskScreenshot, ResponseDate,u_realname, DeveloperId, DeveloperEmail ");
strSql.Append(" from CsCustomerServiceRecord a left join jmp_locuser b on a.WatchId=b.u_id");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
JMP.MDL.CsCustomerServiceRecord model = new JMP.MDL.CsCustomerServiceRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.ResponseScreenshot = ds.Tables[0].Rows[0]["ResponseScreenshot"].ToString();
model.HandleDetails = ds.Tables[0].Rows[0]["HandleDetails"].ToString();
model.EvidenceScreenshot = ds.Tables[0].Rows[0]["EvidenceScreenshot"].ToString();
if (ds.Tables[0].Rows[0]["CompletedDate"].ToString() != "")
{
model.CompletedDate = DateTime.Parse(ds.Tables[0].Rows[0]["CompletedDate"].ToString());
}
if (ds.Tables[0].Rows[0]["HandlerId"].ToString() != "")
{
model.HandlerId = int.Parse(ds.Tables[0].Rows[0]["HandlerId"].ToString());
}
model.HandlerName = ds.Tables[0].Rows[0]["HandlerName"].ToString();
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["AuditStatus"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["AuditStatus"].ToString() == "1") || (ds.Tables[0].Rows[0]["AuditStatus"].ToString().ToLower() == "true"))
{
model.AuditStatus = true;
}
else
{
model.AuditStatus = false;
}
}
if (ds.Tables[0].Rows[0]["AuditByUserId"].ToString() != "")
{
model.AuditByUserId = int.Parse(ds.Tables[0].Rows[0]["AuditByUserId"].ToString());
}
model.AuditByUserName = ds.Tables[0].Rows[0]["AuditByUserName"].ToString();
model.No = ds.Tables[0].Rows[0]["No"].ToString();
if (ds.Tables[0].Rows[0]["AuditDate"].ToString() != "")
{
model.AuditDate = DateTime.Parse(ds.Tables[0].Rows[0]["AuditDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Grade"].ToString() != "")
{
model.Grade = int.Parse(ds.Tables[0].Rows[0]["Grade"].ToString());
}
if (ds.Tables[0].Rows[0]["WatchId"].ToString() != "")
{
model.WatchId = int.Parse(ds.Tables[0].Rows[0]["WatchId"].ToString());
}
if (ds.Tables[0].Rows[0]["HandelGrade"].ToString() != "")
{
model.HandelGrade = int.Parse(ds.Tables[0].Rows[0]["HandelGrade"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString());
}
if (ds.Tables[0].Rows[0]["NotifyWatcher"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["NotifyWatcher"].ToString() == "1") || (ds.Tables[0].Rows[0]["NotifyWatcher"].ToString().ToLower() == "true"))
{
model.NotifyWatcher = true;
}
else
{
model.NotifyWatcher = false;
}
}
if (ds.Tables[0].Rows[0]["NotifyDate"].ToString() != "")
{
model.NotifyDate = DateTime.Parse(ds.Tables[0].Rows[0]["NotifyDate"].ToString());
}
if (ds.Tables[0].Rows[0]["MainCategory"].ToString() != "")
{
model.MainCategory = int.Parse(ds.Tables[0].Rows[0]["MainCategory"].ToString());
}
if (ds.Tables[0].Rows[0]["SubCategory"].ToString() != "")
{
model.SubCategory = int.Parse(ds.Tables[0].Rows[0]["SubCategory"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedByUserId"].ToString() != "")
{
model.CreatedByUserId = int.Parse(ds.Tables[0].Rows[0]["CreatedByUserId"].ToString());
}
if (ds.Tables[0].Rows[0]["AskDate"].ToString() != "")
{
model.AskDate = DateTime.Parse(ds.Tables[0].Rows[0]["AskDate"].ToString());
}
model.AskScreenshot = ds.Tables[0].Rows[0]["AskScreenshot"].ToString();
if (ds.Tables[0].Rows[0]["ResponseDate"].ToString() != "")
{
model.ResponseDate = DateTime.Parse(ds.Tables[0].Rows[0]["ResponseDate"].ToString());
}
{
model.DeveloperId = int.Parse(ds.Tables[0].Rows[0]["DeveloperId"].ToString());
}
model.DeveloperEmail = ds.Tables[0].Rows[0]["DeveloperEmail"].ToString();
model.u_realname = ds.Tables[0].Rows[0]["u_realname"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CsCustomerServiceRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CsCustomerServiceRecord set ");
strSql.Append(" AskScreenshot = @AskScreenshot , ");
strSql.Append(" ResponseDate = @ResponseDate , ");
strSql.Append(" ResponseScreenshot = @ResponseScreenshot , ");
strSql.Append(" HandleDetails = @HandleDetails , ");
strSql.Append(" EvidenceScreenshot = @EvidenceScreenshot , ");
strSql.Append(" CompletedDate = @CompletedDate , ");
strSql.Append(" HandlerId = @HandlerId , ");
strSql.Append(" HandlerName = @HandlerName , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" AuditStatus = @AuditStatus , ");
strSql.Append(" No = @No , ");
strSql.Append(" AuditByUserId = @AuditByUserId , ");
strSql.Append(" AuditByUserName = @AuditByUserName , ");
strSql.Append(" AuditDate = @AuditDate , ");
strSql.Append(" Grade = @Grade , ");
strSql.Append(" WatchId = @WatchId , ");
strSql.Append(" HandelGrade = @HandelGrade , ");
strSql.Append(" ParentId = @ParentId , ");
strSql.Append(" NotifyWatcher = @NotifyWatcher , ");
strSql.Append(" NotifyDate = @NotifyDate , ");
strSql.Append(" MainCategory = @MainCategory , ");
strSql.Append(" SubCategory = @SubCategory , ");
strSql.Append(" CreatedOn = @CreatedOn , ");
strSql.Append(" CreatedByUserId = @CreatedByUserId , ");
strSql.Append(" DeveloperId = @DeveloperId , ");
strSql.Append(" DeveloperEmail = @DeveloperEmail , ");
strSql.Append(" AskDate = @AskDate ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@AskScreenshot", SqlDbType.NVarChar, 255),
new SqlParameter("@ResponseDate", SqlDbType.DateTime),
new SqlParameter("@ResponseScreenshot", SqlDbType.NVarChar, 255),
new SqlParameter("@HandleDetails", SqlDbType.NVarChar, -1),
new SqlParameter("@EvidenceScreenshot", SqlDbType.NVarChar, 2000),
new SqlParameter("@CompletedDate", SqlDbType.DateTime),
new SqlParameter("@HandlerId", SqlDbType.Int, 4),
new SqlParameter("@HandlerName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@AuditStatus", SqlDbType.Bit, 1),
new SqlParameter("@No", SqlDbType.NVarChar, 12),
new SqlParameter("@AuditByUserId", SqlDbType.Int, 4),
new SqlParameter("@AuditByUserName", SqlDbType.NVarChar, 50),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@Grade", SqlDbType.Int, 4),
new SqlParameter("@WatchId", SqlDbType.Int, 4),
new SqlParameter("@HandelGrade", SqlDbType.Int, 4),
new SqlParameter("@ParentId", SqlDbType.Int, 4),
new SqlParameter("@NotifyWatcher", SqlDbType.Bit, 1),
new SqlParameter("@NotifyDate", SqlDbType.DateTime),
new SqlParameter("@MainCategory", SqlDbType.Int, 4),
new SqlParameter("@SubCategory", SqlDbType.Int, 4),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@CreatedByUserId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperEmail", SqlDbType.NVarChar, 80),
new SqlParameter("@AskDate", SqlDbType.DateTime)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.AskScreenshot;
parameters[2].Value = model.ResponseDate;
parameters[3].Value = model.ResponseScreenshot;
parameters[4].Value = model.HandleDetails;
parameters[5].Value = model.EvidenceScreenshot;
parameters[6].Value = model.CompletedDate;
parameters[7].Value = model.HandlerId;
parameters[8].Value = model.HandlerName;
parameters[9].Value = model.Status;
parameters[10].Value = model.AuditStatus;
parameters[11].Value = model.No;
parameters[12].Value = model.AuditByUserId;
parameters[13].Value = model.AuditByUserName;
parameters[14].Value = model.AuditDate;
parameters[15].Value = model.Grade;
parameters[16].Value = model.WatchId;
parameters[17].Value = model.HandelGrade;
parameters[18].Value = model.ParentId;
parameters[19].Value = model.NotifyWatcher;
parameters[20].Value = model.NotifyDate;
parameters[21].Value = model.MainCategory;
parameters[22].Value = model.SubCategory;
parameters[23].Value = model.CreatedOn;
parameters[24].Value = model.CreatedByUserId;
parameters[25].Value = model.DeveloperId;
parameters[26].Value = model.DeveloperEmail;
parameters[27].Value = model.AskDate;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
