public bool Insert(MODELMESSAGERECEIVE MODELMESSAGERECEIVE) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO MESSAGERECEIVE(MESSAGERECEIVEID,MESSAGESENDID,MESSAGERECEIVERID,MESSAGERECEIVERNAME) "); str.Append("VALUES(@MESSAGERECEIVEID,@MESSAGESENDID,@MESSAGERECEIVERID,@MESSAGERECEIVERNAME)"); SqlParameter[] para = { new SqlParameter("@MESSAGERECEIVEID", SqlDbType.VarChar, 50), new SqlParameter("@MESSAGESENDID", SqlDbType.VarChar, 50), new SqlParameter("@MESSAGERECEIVERID", SqlDbType.VarChar, 30), new SqlParameter("@MESSAGERECEIVERNAME", SqlDbType.VarChar, 50) }; para[0].Value = MODELMESSAGERECEIVE.MESSAGERECEIVEID; para[1].Value = MODELMESSAGERECEIVE.MESSAGESENDID; para[2].Value = MODELMESSAGERECEIVE.MESSAGERECEIVERID; para[3].Value = MODELMESSAGERECEIVE.MESSAGERECEIVERNAME; 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; }