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