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