protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { JumbotOA.Entity.UserEntity userEntity = new JumbotOA.Entity.UserEntity(); //可以添加 JumbotOA.Entity.MessageEntity message = new JumbotOA.Entity.MessageEntity(); message.Content = this.FCKeditor1.Value; message.FromUid = UserId; message.Addtime = System.DateTime.Now; message.Mtitle = this.txtTitle.Text; if (mes != 0) { message.ToUid = _uid; } else { if (DropDownList1.SelectedValue =="-1") { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请选择收信人!');</script>"); return; }else message.ToUid = Convert.ToInt32(DropDownList2.SelectedValue.ToString()); } int i = new JumbotOA.BLL.MessageBLL().Add(message); if (i > 0) { JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(0, "," + message.ToUid + ",", "新短信", JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(txtTitle.Text.Trim()), 53), "Message_Show.aspx?id=" + i.ToString()); FinalMessage("短信发送成功", "Message_MySend.aspx", 0); } else { FinalMessage("短信发送失败", "Message_MySend.aspx", 0); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(JumbotOA.Entity.MessageEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [OA_Message] set "); strSql.Append("ToUid=" + model.ToUid + ","); strSql.Append("FromUid=" + model.FromUid + ","); strSql.Append("Mtitle='" + model.Mtitle + "',"); strSql.Append("Content='" + model.Content + "',"); strSql.Append("Addtime='" + model.Addtime + "'"); strSql.Append("touser='******'"); strSql.Append(" where Mid=" + model.Mid + " "); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JumbotOA.Entity.MessageEntity model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); strSql1.Append("ToUid,"); strSql2.Append("" + model.ToUid + ","); strSql1.Append("FromUid,"); strSql2.Append("" + model.FromUid + ","); if (model.Mtitle != null) { strSql1.Append("Mtitle,"); strSql2.Append("'" + model.Mtitle + "',"); } if (model.Content != null) { strSql1.Append("Content,"); strSql2.Append("'" + model.Content + "',"); } if (model.Addtime != null) { strSql1.Append("Addtime,"); strSql2.Append("'" + model.Addtime + "',"); } strSql1.Append("touser,"); strSql2.Append("'" + model.Touser + "',"); strSql.Append("insert into [OA_Message]("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JumbotOA.Entity.MessageEntity GetEntity(int Mid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" Mid,ToUid,FromUid,Mtitle,Content,Addtime,IsRead,(select uname from [OA_User] where Uid=[OA_Message].ToUid) as ToUname,(select uname from [OA_User] where Uid=[OA_Message].FromUid) as FromUname "); strSql.Append(",Touser from [OA_Message] "); strSql.Append(" where Mid=" + Mid + " "); JumbotOA.Entity.MessageEntity model = new JumbotOA.Entity.MessageEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Mid"].ToString() != "") { model.Mid = int.Parse(ds.Tables[0].Rows[0]["Mid"].ToString()); } if (ds.Tables[0].Rows[0]["ToUid"].ToString() != "") { model.ToUid = int.Parse(ds.Tables[0].Rows[0]["ToUid"].ToString()); } if (ds.Tables[0].Rows[0]["FromUid"].ToString() != "") { model.FromUid = int.Parse(ds.Tables[0].Rows[0]["FromUid"].ToString()); } model.Mtitle = ds.Tables[0].Rows[0]["Mtitle"].ToString(); model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); if (ds.Tables[0].Rows[0]["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(ds.Tables[0].Rows[0]["Addtime"].ToString()); } model.ToUname = ds.Tables[0].Rows[0]["ToUname"].ToString(); model.FromUname = ds.Tables[0].Rows[0]["FromUname"].ToString(); model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[0]["IsRead"].ToString()); model.Touser = ds.Tables[0].Rows[0]["touser"].ToString(); return(model); } else { return(null); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { JumbotOA.Entity.UserEntity userEntity = new JumbotOA.Entity.UserEntity(); //可以添加 JumbotOA.Entity.MessageEntity message = new JumbotOA.Entity.MessageEntity(); message.Content = this.FCKeditor1.Value; message.FromUid = UserId; message.Addtime = System.DateTime.Now; message.Mtitle = this.txtTitle.Text; if (mes != 0) { message.ToUid = _uid; } else { if (DropDownList1.SelectedValue == "-1") { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请选择收信人!');</script>"); return; } else { message.ToUid = Convert.ToInt32(DropDownList2.SelectedValue.ToString()); } } int i = new JumbotOA.BLL.MessageBLL().Add(message); if (i > 0) { JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(0, "," + message.ToUid + ",", "新短信", JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(txtTitle.Text.Trim()), 53), "Message_Show.aspx?id=" + i.ToString()); FinalMessage("短信发送成功", "Message_MySend.aspx", 0); } else { FinalMessage("短信发送失败", "Message_MySend.aspx", 0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JumbotOA.Entity.MessageEntity GetEntity(int Mid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" Mid,ToUid,FromUid,Mtitle,Content,Addtime,IsRead,(select uname from [OA_User] where Uid=[OA_Message].ToUid) as ToUname,(select uname from [OA_User] where Uid=[OA_Message].FromUid) as FromUname "); strSql.Append(",Touser from [OA_Message] "); strSql.Append(" where Mid=" + Mid + " "); JumbotOA.Entity.MessageEntity model = new JumbotOA.Entity.MessageEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Mid"].ToString() != "") { model.Mid = int.Parse(ds.Tables[0].Rows[0]["Mid"].ToString()); } if (ds.Tables[0].Rows[0]["ToUid"].ToString() != "") { model.ToUid = int.Parse(ds.Tables[0].Rows[0]["ToUid"].ToString()); } if (ds.Tables[0].Rows[0]["FromUid"].ToString() != "") { model.FromUid = int.Parse(ds.Tables[0].Rows[0]["FromUid"].ToString()); } model.Mtitle = ds.Tables[0].Rows[0]["Mtitle"].ToString(); model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); if (ds.Tables[0].Rows[0]["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(ds.Tables[0].Rows[0]["Addtime"].ToString()); } model.ToUname = ds.Tables[0].Rows[0]["ToUname"].ToString(); model.FromUname = ds.Tables[0].Rows[0]["FromUname"].ToString(); model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[0]["IsRead"].ToString()); model.Touser = ds.Tables[0].Rows[0]["touser"].ToString(); return model; } else { return null; } }