public DataSet Search(EmergFileEntity ety, SqlTransaction tran) { string strsql = "select * from EmergFile where 1=1 "; Tools _tool = new Tools(); strsql += _tool.GetEntityToWheresql("", "like", ety); return(Search(strsql)); }
private void Time_LoadData_Tick(object sender, EventArgs e) { progressBar.Value += 1; txtWaitSend.Text = dgvSendSms.Rows.Count.ToString(); if (progressBar.Value != 30) { return; } ReduceMemory(); progressBar.Value = 0; if (WeekTest()) { return; } EmergFileClass dao = new EmergFileClass(); EmergFileEntity ety = new EmergFileEntity(); ety.State = "1"; DataTable dt_emerg = dao.Search(ety, null).Tables[0]; if (dt_emerg.Rows.Count > 0) { for (int i = 0; i < dt_emerg.Rows.Count; i++) { //查询该件是否还在交换箱中 DataTable dt_filebox = dao.SearchForReadySms(dt_emerg.Rows[i]["FileBoxId"].ToString()).Tables[0]; if (dt_filebox.Rows.Count > 0) { bool tag = false; if (int.Parse(dt_emerg.Rows[i]["Recount"].ToString()) < 3) { CreateNewRow(dt_filebox.Rows[0]["GetDept"].ToString(), int.Parse(dt_emerg.Rows[i]["Recount"].ToString()), dt_filebox.Rows[0]["FileId"].ToString(), dt_filebox.Rows[0]["FileBoxId"].ToString()); tag = true; } //修改重发次数 if (tag) { ety = new EmergFileEntity(); ety.Emergfileid = dt_emerg.Rows[0][0].ToString(); ety.Recount = Convert.ToString(int.Parse(dt_emerg.Rows[i]["Recount"].ToString()) + 1); dao.Update(ety, null); } } else { //修改发送状态 ety = new EmergFileEntity(); ety.Emergfileid = dt_emerg.Rows[0][0].ToString(); ety.State = "0"; dao.Update(ety, null); } } } }
public bool Update(EmergFileEntity ety, SqlTransaction tran) { DataBase db = new DataBase(); return(db.Update(ety, null, "")); }
public bool Insert(EmergFileEntity ety, SqlTransaction tran) { DataBase db = new DataBase(); return(db.Create(ety, tran) > 0); }
public void CreateNewRow(string boxname, int recount, string fileid, string fileboxid) { if (dgvSendSms.InvokeRequired) { SetDgvCallback setdgvCallbak = new SetDgvCallback(CreateNewRow); dgvSendSms.Invoke(setdgvCallbak, boxname, recount, fileid, fileboxid); } else { txtMessage.Text = boxname; MessageUserClass dao = new MessageUserClass(); MessageUserEntity ety = new MessageUserEntity(); ety.Deptname = boxname; DataTable dt = dao.Search(ety, null).Tables[0]; if (dt.Rows.Count > 0) { string[] username = dt.Rows[0]["UserName"].ToString().Split(','); string[] phonenum = dt.Rows[0]["PhoneNum"].ToString().Split(','); if (recount > 0) { //重复发送 for (int i = 0; i < username.Length; i++) { int index = dgvSendSms.Rows.Add(); dgvSendSms.Rows[index].Cells[0].Value = dt.Rows[0]["DeptName"].ToString(); dgvSendSms.Rows[index].Cells[1].Value = username[i]; dgvSendSms.Rows[index].Cells[2].Value = phonenum[i]; dgvSendSms.Rows[index].Cells[3].Value = GlobalFunction.ConfigueGet("ProgrameSet.xml", "appSettings", "defMessage"); dgvSendSms.Rows[index].Cells[5].Value = "未发送"; dgvSendSms.Rows[index].Cells[6].Value = "已重复发送" + recount + "次"; } } else { //首次发送 if (username.Length > 1) { int index = dgvSendSms.Rows.Add(); dgvSendSms.Rows[index].Cells[0].Value = dt.Rows[0]["DeptName"].ToString(); dgvSendSms.Rows[index].Cells[1].Value = username[1]; dgvSendSms.Rows[index].Cells[2].Value = phonenum[1]; dgvSendSms.Rows[index].Cells[3].Value = GlobalFunction.ConfigueGet("ProgrameSet.xml", "appSettings", "defMessage"); dgvSendSms.Rows[index].Cells[5].Value = "未发送"; } else { int index = dgvSendSms.Rows.Add(); dgvSendSms.Rows[index].Cells[0].Value = dt.Rows[0]["DeptName"].ToString(); dgvSendSms.Rows[index].Cells[1].Value = username[0]; dgvSendSms.Rows[index].Cells[2].Value = phonenum[0]; dgvSendSms.Rows[index].Cells[3].Value = GlobalFunction.ConfigueGet("ProgrameSet.xml", "appSettings", "defMessage"); dgvSendSms.Rows[index].Cells[5].Value = "未发送"; } EmergFileEntity ety_emerg = new EmergFileEntity(); EmergFileClass dao_emerg = new EmergFileClass(); ety_emerg.FileBoxId = fileboxid; ety_emerg.Fileid = fileid; ety_emerg.State = "1"; DataTable dt_emerg = dao_emerg.Search(ety_emerg, null).Tables[0]; if (dt_emerg.Rows.Count < 1) { ety_emerg.Recount = "1"; dao_emerg.Insert(ety_emerg, null); } } } } }