/// <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); } }