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