private void btnSave_Click(object sender, EventArgs e)
{
if (txtDeptName.Text != "" && txtPhoneNum.Text != "" && txtUserName.Text != "")
{
MessageUserClass dao = new MessageUserClass();
MessageUserEntity ety = (MessageUserEntity)GlobalFunction.ControlsToEntity(panel1.Controls, typeof(MessageUserEntity));
if (ety.Phonenum.Substring(0, 2) != "86")
{
ety.Phonenum = "86" + ety.Phonenum;
}
if (messageuserid == "")
{
dao.Insert(ety, null);
}
else
{
ety.Messageuserid = messageuserid;
dao.Update(ety, null);
}
LoadData();
GlobalFunction.ClearControls(panel1.Controls);
messageuserid = "";
}
else
{
MessageBox.Show("不能空保存！");
}
}
public DataSet Search(MessageUserEntity ety, SqlTransaction tran)
{
string strsql = "select * from MessageUser where 1=1 ";
Tools _tool = new Tools();
strsql += _tool.GetEntityToWheresql("", "like", ety);
return(Search(strsql));
}
private void btnDao_Click(object sender, EventArgs e)
{
MessageUserClass dao = new MessageUserClass();
DataTable dt = dao.SearchForDeptName().Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
MessageUserEntity ety = new MessageUserEntity();
ety.Deptname = dt.Rows[i][0].ToString();
ety.Username = dt.Rows[i][0].ToString();
ety.Phonenum = "86123";
dao.Insert(ety, null);
}
}
private void Time_Day_Tick(object sender, EventArgs e)
{
if (tag_Day != DateTime.Now.ToString("yyyyMMdd"))
{
tag_Day = DateTime.Now.ToString("yyyyMMdd");
}
else
{
return;
}
if (!WeekTest())
{
return;
}
EmergFileClass dao_emerg_day = new EmergFileClass();
MessageUserClass dao_user = new MessageUserClass();
MessageUserEntity ety_user = new MessageUserEntity();
DataTable dt = dao_emerg_day.SearchAllGetDept().Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ety_user.Deptname = dt.Rows[0][0].ToString();
DataTable dt_user = dao_user.Search(ety_user, null).Tables[0];
if (dt_user.Rows.Count > 0)
{
string[] username = dt_user.Rows[0]["UserName"].ToString().Split(',');
string[] phonenum = dt_user.Rows[0]["PhoneNum"].ToString().Split(',');
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 = "你有文件待取！";
dgvSendSms.Rows[index].Cells[5].Value = "未发送";
dgvSendSms.Rows[index].Cells[6].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 = "你有文件待取！";
dgvSendSms.Rows[index].Cells[5].Value = "未发送";
dgvSendSms.Rows[index].Cells[6].Value = "每日文件提醒";
}
}
}
}
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);
}
}
}
}
}
public bool Update(MessageUserEntity ety, SqlTransaction tran)
{
DataBase db = new DataBase();
return(db.Update(ety, null, ""));
}
public bool Insert(MessageUserEntity ety, SqlTransaction tran)
{
DataBase db = new DataBase();
return(db.Create(ety, tran) > 0);
}
