/// <summary> /// 添加 /// </summary> public string Add() { string Result = ""; try { string TestRoomCode = Request["TestRoomCode"].ToString(); string CompanyType = Request["CompanyType"].ToString(); string Name = "Name".RequestStr(); string IDCard = Request["IDCard"].ToString(); string Job = Request["Job"].ToString(); string Deduct = Request["Deduct"].ToString(); string Remark = Request["Remark"].ToString(); string RType = Request["RType"].ToString(); string CreateBy = Session["UserName"].ToString(); string Sql = @" INSERT INTO [dbo].[sys_ReditRating] ([SysID] ,[SegmentCode] ,[CompanyCode] ,[TestRoomCode] ,[CompanyType] ,[RType] ,[Name] ,[IDCard] ,[Job] ,[Deduct] ,[Remark] ,[CreateOn],[CreateBy] ,[ISDeleted]) VALUES ('{0}' ,'{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}' ,'{7}' ,'{8}' ,'{9}' ,'{10}','{11}','{12}',1) "; Sql = string.Format(Sql, Guid.NewGuid().ToString(), TestRoomCode.Substring(0, 8), TestRoomCode.Substring(0, 12), TestRoomCode, CompanyType, RType, Name, IDCard, Job, Deduct, Remark, DateTime.Now.ToString(), CreateBy); BLL_Document BLL = new BLL_Document(); Result = BLL.ExcuteCommand(Sql) > 0 ? "true" : "false"; } catch { Result = "false"; } return(Result); }
public string Del() { string SysID = "SysID".RequestStr(); if (SysID.IsNullOrEmpty()) { return(""); } string Sql = @" UPDATE [dbo].[sys_ReditRating] SET IsDeleted=0 WHERE SysID = '" + SysID + "' "; BLL_Document BLL = new BLL_Document(); return(BLL.ExcuteCommand(Sql) > 0 ? "true" : "false"); }
/// <summary> /// 添加 /// </summary> public string Edit() { string Result = ""; try { string TestRoomCode = Request["TestRoomCode"].ToString(); string CompanyType = Request["CompanyType"].ToString(); string Name = "Name".RequestStr(); string IDCard = Request["IDCard"].ToString(); string Job = Request["Job"].ToString(); string Deduct = Request["Deduct"].ToString(); string Remark = Request["Remark"].ToString(); string SysID = Request["SysID"].ToString(); string RType = Request["RType"].ToString(); string CreateBy = Session["UserName"].ToString(); string Sql = @" UPDATE [dbo].[sys_ReditRating] SET [SegmentCode] = '{0}' ,[CompanyCode] = '{1}' ,[TestRoomCode] = '{2}' ,[CompanyType] = '{3}' ,[RType] = '{11}' ,[Name] = '{4}' ,[IDCard] = '{5}' ,[Job] = '{6}' ,[Deduct] = '{7}' ,[Remark] = '{8}' ,[CreateBy] = '{9}' WHERE SysID = '{10}' "; Sql = string.Format(Sql, TestRoomCode.Substring(0, 8), TestRoomCode.Substring(0, 12), TestRoomCode, CompanyType, Name, IDCard, Job, Deduct, Remark, CreateBy, SysID, RType); BLL_Document BLL = new BLL_Document(); Result = BLL.ExcuteCommand(Sql) > 0 ? "true" : "false"; } catch { Result = "false"; } return(Result); }
/// <summary> /// 添加 /// </summary> public string Edit() { string Result = ""; try { string KMID = Request["KMID"].ToString(); string Content = Request["Content"].ToString(); string Person = UserName; //rolename string Sql = @" UPDATE [dbo].[sys_KeyModify] SET [YZUserName] = '{0}' ,[YZContent] = '{1}' ,[YZOPTime] = '{2}' ,Status={4} WHERE KMID = '{3}' "; Sql = string.Format(Sql, Person, Content, DateTime.Now.ToString(), KMID, "Type".RequestStr()); BLL_Document BLL = new BLL_Document(); Result = BLL.ExcuteCommand(Sql) > 0 ? "true" : "false"; try { #region 发短信 if ("Type".RequestStr() == "2" && Result == "true") { sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; DataSet DsTemp = LineDbHelperSQL.Query("SELECT [SMSState] FROM [sys_line] where ID ='" + sysBaseLine.ID + "'"); if (DsTemp.Tables.Count > 0 && DsTemp.Tables[0].Rows.Count > 0 && DsTemp.Tables[0].Rows[0][0].ToString() == "1") { string SMSSql = @" SELECT sys_module.name,sys_KeyModify.BGBH,sys_KeyModify.ModifyItem,sys_KeyModify.YzUserName, t1.DESCRIPTION +' '+sys_tree.DESCRIPTION as DESCRIPTION,TestRoomCode FROM sys_KeyModify left outer join sys_tree on sys_KeyModify.testroomcode = sys_tree.nodecode left outer join sys_tree as t1 on Left(sys_KeyModify.testroomcode,8) = t1.nodecode left outer join sys_module on sys_module.id = sys_KeyModify.moduleid where sys_KeyModify.KMID = '" + KMID + "'"; DataSet Ds = BLL.GetDataSet(SMSSql); string SmsContent = "{0} {1} {2} {3} {4}拒绝"; if (Ds.Tables[0] != null && Ds.Tables[0].Rows.Count > 0) { DataRow Dr = Ds.Tables[0].Rows[0]; ModifyItem[] Temp = Newtonsoft.Json.JsonConvert.DeserializeObject <ModifyItem[]>(Dr["ModifyItem"].ToString()); SmsContent = string.Format(SmsContent , Dr["DESCRIPTION"].ToString() , Dr["name"].ToString() , Dr["BGBH"].ToString() , Temp[0].Description + Temp[0].CurrentValue + "修改为" + Temp[0].OriginalValue , Dr["YzUserName"].ToString() ); string CPS = @" SELECT CellPhone FROM [SYGLDB_ZhengXu].[dbo].[sys_sms_receiver] where TestRoomCode ='" + Ds.Tables[0].Rows[0]["TestRoomCode"].ToString() + "' and CellPhone <>'' ANd CellPhone is not null and IsActive=1"; string MS = ""; Ds = BLL.GetDataSet(CPS); if (Ds.Tables[0] != null && Ds.Tables[0].Rows.Count > 0) { foreach (DataRow Dr1 in Ds.Tables[0].Rows) { if (!Dr1[0].ToString().IsNullOrEmpty()) { MS += MS.IsNullOrEmpty() ? Dr1[0].ToString() : "," + Dr1[0].ToString(); } } } if (!MS.IsNullOrEmpty()) { string SMSResult = SendSMS("Mobile=" + MS + "&Content=" + SmsContent + "&Stime=" + DateTime.Now.ToString() + "&Extno=1"); } } } } #endregion } catch { } } catch { Result = "false"; } return(Result); }