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