public bool Insert(MODELMESSAGESEND MODELMESSAGESEND)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO MESSAGESEND(MESSAGESENDID,MESSAGESENDERID,MESSAGESENDERNAME,MESSAGERECEIVER,MESSAGECONTENT,MESSAGECLASS,MESSAGESENDTIME,MESSAGETITLE) ");
str.Append("VALUES(@MESSAGESENDID,@MESSAGESENDERID,@MESSAGESENDERNAME,@MESSAGERECEIVER,@MESSAGECONTENT,@MESSAGECLASS,@MESSAGESENDTIME,@MESSAGETITLE)");
SqlParameter[] para =
{
new SqlParameter("@MESSAGESENDID", SqlDbType.VarChar, 50),
new SqlParameter("@MESSAGESENDERID", SqlDbType.VarChar, 50),
new SqlParameter("@MESSAGESENDERNAME", SqlDbType.VarChar, 50),
new SqlParameter("@MESSAGERECEIVER", SqlDbType.VarChar, 1000),
new SqlParameter("@MESSAGECONTENT", SqlDbType.VarChar, 1000),
new SqlParameter("@MESSAGECLASS", SqlDbType.VarChar, 10),
new SqlParameter("@MESSAGESENDTIME", SqlDbType.DateTime),
new SqlParameter("@MESSAGETITLE", SqlDbType.VarChar, 100)
};
para[0].Value = MODELMESSAGESEND.MESSAGESENDID;
para[1].Value = MODELMESSAGESEND.MESSAGESENDERID;
para[2].Value = MODELMESSAGESEND.MESSAGESENDERNAME;
para[3].Value = MODELMESSAGESEND.MESSAGERECEIVER;
para[4].Value = MODELMESSAGESEND.MESSAGECONTENT;
para[5].Value = MODELMESSAGESEND.MESSAGECLASS;
para[6].Value = MODELMESSAGESEND.MESSAGESENDTIME;
para[7].Value = MODELMESSAGESEND.MESSAGETITLE;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btSend_Click(object sender, EventArgs e)
{
if (lsbReceiver.Items.Count == 0)
{
mes.Show("请从通讯录里选择接收人!");
return;
}
if (txtTitle.Text.Trim() == "")
{
mes.Show("请填写消息标题!");
return;
}
if (txtContent.Text.Trim() == "")
{
if (mes.ShowQ("消息内容为空，确定不填写内容吗?") != DialogResult.OK)
{
return;
}
}
if (cmbClass.SelectedIndex < 0)
{
mes.Show("请选择消息'紧急状态'!");
return;
}
try
{
MODELMESSAGESEND MODELMESSAGESEND = new MODELMESSAGESEND();
MODELMESSAGESEND.MESSAGESENDID = GETTABLEID.GetTableID(strLogID, "MESSAGESEND");
string strReceiveName = "";
for (int i = 0; i < lsbReceiver.Items.Count; i++)
{
ListItem lst = (ListItem)lsbReceiver.Items[i];
if (i == 0)
{
strReceiveName = lst.strName;
}
else
{
strReceiveName += ";" + lst.strName;
}
}
MODELMESSAGESEND.MESSAGERECEIVER = strReceiveName;
MODELMESSAGESEND.MESSAGETITLE = txtTitle.Text;
MODELMESSAGESEND.MESSAGECLASS = (cmbClass.SelectedIndex + 1).ToString();
MODELMESSAGESEND.MESSAGECONTENT = txtContent.Text;
MODELMESSAGESEND.MESSAGESENDERID = strLogID;
MODELMESSAGESEND.MESSAGESENDERNAME = strUserName;
MODELMESSAGESEND.MESSAGESENDTIME = mes.GetDatetimeNow();
if (BLLMESSAGESEND.Insert(MODELMESSAGESEND))
{
try
{
for (int j = 0; j < lsbReceiver.Items.Count; j++)
{
ListItem lst = (ListItem)lsbReceiver.Items[j];
MODELMESSAGERECEIVE MODELMESSAGERECEIVE = new MODELMESSAGERECEIVE();
MODELMESSAGERECEIVE.MESSAGERECEIVEID = GETTABLEID.GetTableID(strLogID, "MESSAGERECEIVE");
MODELMESSAGERECEIVE.MESSAGESENDID = MODELMESSAGESEND.MESSAGESENDID;
MODELMESSAGERECEIVE.MESSAGERECEIVERID = lst.strID;
MODELMESSAGERECEIVE.MESSAGERECEIVERNAME = lst.strName;
if (!BLLMESSAGERECEIVE.Insert(MODELMESSAGERECEIVE))
{
mes.Show("发送给'" + lst.strName + "'时发生错误,请重新发送!");
//回滚发送的邮件
BLLMESSAGERECEIVE.Delete(" AND MESSAGESENDID='" + MODELMESSAGERECEIVE.MESSAGESENDID + "'");
//回滚发送的内容
BLLMESSAGESEND.Delete(MODELMESSAGESEND.MESSAGESENDID);
return;
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
//回滚发送的内容
BLLMESSAGESEND.Delete(MODELMESSAGESEND.MESSAGESENDID);
//回滚发送的邮件
BLLMESSAGERECEIVE.Delete(" AND MESSAGESENDID='" + MODELMESSAGESEND.MESSAGESENDID + "'");
return;
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
return;
}
mes.Show("发送完成!");
btSend.Enabled = false;
btNew.Enabled = true;
}
