public static void Send() { Bll.Sms_outbox bll = new Bll.Sms_outbox(); Bll.BIF01022 bll2 = new Bll.BIF01022(); string phone = "", revise_time = "", PatiID = "", Name = ""; string _add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string dsNow = DateTime.Now.ToString("yyyy-MM-dd"); //string dsNow = "2019-12-30"; DbHelperSQLP db = new DbHelperSQLP(PubConstant.GetConnectionString("ConnectionStringBright_CB")); string sql = "select AddTime,Name,Tel,PatiID from BloodPatient where Tel!='' and AddTime!='' and len(Tel)>12"; DataSet ds = db.Query(sql); if (ds != null && ds.Tables[0].Rows.Count != 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { PatiID = dr["PatiID"] + ""; Name = dr["Name"] + ""; phone = dr["Tel"] + ""; //phone = "15261277153"; revise_time = Convert.ToDateTime(dr["AddTime"]).AddDays(85).ToString("yyyy-MM-dd"); if (dsNow == revise_time) { Model.Sms_outbox model = new Model.Sms_outbox(); model.sismsid = Guid.NewGuid().ToString(); model.extcode = "01"; model.destaddr = phone.Split('|')[0]; model.messagecontent = "5272718510018"; model.reqdeliveryreport = 1; model.msgfmt = 15; model.sendmethod = 2; model.requesttime = _add_time; model.applicationid = "APP128"; if (bll.Add(model)) { Model.BIF01022 model2 = new Model.BIF01022(); model2.Patient_id = PatiID; model2.Patient_name = Name; model2.Item_name = Name; model2.Current_result = revise_time; model2.EmpMobileNum = phone; model2.EMPNAME = "预约回诊"; model2.State = 11; model2.Add_time = _add_time; bll2.Add(model2); } //break; } } } }
public static void Send() { Bll.Sms_outbox bll = new Bll.Sms_outbox(); Bll.BIF01022 bll2 = new Bll.BIF01022(); string phone = "", revise_time = "", long_time = ""; string _add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string dsNow = DateTime.Now.ToString("yyyy-MM-dd"); //string dsNow = "2019-12-30"; DbHelperSQLP db = new DbHelperSQLP(PubConstant.GetConnectionString("ConnectionString3")); string sql = "select tel, revise_time,long_time from FileInfo where tel is not null and filestate=0"; DataSet ds = db.Query(sql); if (ds != null && ds.Tables[0].Rows.Count != 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { phone = dr["tel"] + ""; //phone = "15261277153"; revise_time = !String.IsNullOrEmpty(dr["revise_time"] + "")?Convert.ToDateTime(dr["revise_time"]).ToString("yyyy-MM-dd"):""; long_time = !String.IsNullOrEmpty(dr["long_time"] + "")?Convert.ToDateTime(dr["long_time"]).ToString("yyyy-MM-dd"):""; if ((dsNow == revise_time || dsNow == long_time) && !String.IsNullOrEmpty(phone)) { Model.Sms_outbox model = new Model.Sms_outbox(); model.sismsid = Guid.NewGuid().ToString(); model.extcode = "01"; model.destaddr = phone; model.messagecontent = "5272718510011"; model.reqdeliveryreport = 1; model.msgfmt = 15; model.sendmethod = 2; model.requesttime = _add_time; model.applicationid = "APP128"; if (bll.Add(model)) { Model.BIF01022 model2 = new Model.BIF01022(); model2.Patient_id = "JCI"; model2.Patient_name = "JCI"; model2.Item_name = "JCI"; model2.Current_result = revise_time; model2.EmpMobileNum = phone; model2.EMPNAME = long_time; model2.State = 10; model2.Add_time = _add_time; bll2.Add(model2); } } } } }
public bool Update3(Model.BIF01022 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BIF01022 set "); //strSql.Append("Patient_id=@Patient_id,"); //strSql.Append("Patient_name=@Patient_name,"); //strSql.Append("Item_name=@Item_name,"); //strSql.Append("Current_result=@Current_result,"); //strSql.Append("EmpMobileNum=@EmpMobileNum,"); strSql.Append("Update_time=@Update_time,"); strSql.Append("State=@State "); //strSql.Append("Add_time=@Add_time"); strSql.Append(" where EmpMobileNum=@EmpMobileNum and Item_name=@Item_name and Current_result=@Current_result and Patient_id=@Patient_id and state=5 "); SqlParameter[] parameters = { new SqlParameter("@Patient_id", SqlDbType.VarChar, 50), new SqlParameter("@Patient_name", SqlDbType.VarChar, 50), new SqlParameter("@Item_name", SqlDbType.VarChar, 50), new SqlParameter("@Current_result", SqlDbType.VarChar, 50), new SqlParameter("@EmpMobileNum", SqlDbType.VarChar, 50), new SqlParameter("@EMPNAME", SqlDbType.VarChar, 50), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@Add_time", SqlDbType.VarChar, 50), new SqlParameter("@Update_time", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Patient_id; parameters[1].Value = model.Patient_name; parameters[2].Value = model.Item_name; parameters[3].Value = model.Current_result; parameters[4].Value = model.EmpMobileNum; parameters[5].Value = model.EMPNAME; parameters[6].Value = model.State; parameters[7].Value = model.Add_time; parameters[8].Value = model.Update_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void Send() { Bll.Sms_outbox bll = new Bll.Sms_outbox(); Bll.BIF01022 bll2 = new Bll.BIF01022(); string phone = "", Name = "", AddTime = ""; string _add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string dsNow = DateTime.Now.ToString("yyyy-MM-dd"); //string dsNow = "2019-12-30"; DbHelperSQLP db = new DbHelperSQLP(PubConstant.GetConnectionString("ConnectionStringOnline")); string sql = "select name, tel,addTime from Smoke where datediff(day, dateadd(dd,0,addTime),getdate())=1 and tel!=''"; DataSet ds = db.Query(sql); if (ds != null && ds.Tables[0].Rows.Count != 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { AddTime = dr["addTime"] + ""; Name = dr["name"] + ""; phone = dr["tel"] + ""; //phone = "15261277153"; Model.Sms_outbox model = new Model.Sms_outbox(); model.sismsid = Guid.NewGuid().ToString(); model.extcode = "01"; model.destaddr = phone; model.messagecontent = "5272718510019"; model.reqdeliveryreport = 1; model.msgfmt = 15; model.sendmethod = 2; model.requesttime = _add_time; model.applicationid = "APP128"; if (bll.Add(model)) { Model.BIF01022 model2 = new Model.BIF01022(); model2.Patient_id = Name; model2.Patient_name = Name; model2.Item_name = Name; model2.Current_result = AddTime; model2.EmpMobileNum = phone; model2.EMPNAME = "戒烟"; model2.State = 12; model2.Add_time = _add_time; bll2.Add(model2); } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.BIF01022 DataRowToModel(DataRow row) { Model.BIF01022 model = new Model.BIF01022(); if (row != null) { if (row["Patient_id"] != null) { model.Patient_id = row["Patient_id"].ToString(); } if (row["Patient_name"] != null) { model.Patient_name = row["Patient_name"].ToString(); } if (row["Item_name"] != null) { model.Item_name = row["Item_name"].ToString(); } if (row["Current_result"] != null) { model.Current_result = row["Current_result"].ToString(); } if (row["EmpMobileNum"] != null) { model.EmpMobileNum = row["EmpMobileNum"].ToString(); } if (row["EMPNAME"] != null) { model.EMPNAME = row["EMPNAME"].ToString(); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } if (row["Add_time"] != null) { model.Add_time = row["Add_time"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.BIF01022 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BIF01022("); strSql.Append("Patient_id,Patient_name,Item_name,Current_result,EmpMobileNum,EMPNAME,State,Add_time)"); strSql.Append(" values ("); strSql.Append("@Patient_id,@Patient_name,@Item_name,@Current_result,@EmpMobileNum,@EMPNAME,@State,@Add_time)"); SqlParameter[] parameters = { new SqlParameter("@Patient_id", SqlDbType.VarChar, 50), new SqlParameter("@Patient_name", SqlDbType.VarChar, 50), new SqlParameter("@Item_name", SqlDbType.VarChar, 50), new SqlParameter("@Current_result", SqlDbType.VarChar, 50), new SqlParameter("@EmpMobileNum", SqlDbType.VarChar, 50), new SqlParameter("@EMPNAME", SqlDbType.VarChar, 50), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@Add_time", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Patient_id; parameters[1].Value = model.Patient_name; parameters[2].Value = model.Item_name; parameters[3].Value = model.Current_result; parameters[4].Value = model.EmpMobileNum; parameters[5].Value = model.EMPNAME; parameters[6].Value = model.State; parameters[7].Value = model.Add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.BIF01022 GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Patient_id,Patient_name,Item_name,Current_result,EmpMobileNum,EMPNAME,State,Add_time from BIF01022 "); strSql.Append(" where "); SqlParameter[] parameters = { }; Model.BIF01022 model = new Model.BIF01022(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public bool Update3(Model.BIF01022 model) { return(dal.Update3(model)); }
public bool UpdateData(Model.BIF01022 model, int state) { return(dal.UpdateData(model, state)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.BIF01022 model) { return(dal.Add(model)); }