public int update(Model.tab_message message)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("update tab_message set ");
strsql.AppendFormat(" Sender =N'{0}',", message.Sender);
strsql.AppendFormat(" Receiver =N'{0}',", message.Receiver);
strsql.AppendFormat(" Title =N'{0}',", message.Title);
strsql.AppendFormat(" Msg =N'{0}',", message.Msg);
strsql.AppendFormat(" Status =N'{0}',", message.Status);
strsql.AppendFormat(" MessageDate ={0},", message.MessageDate == baddate ? "null" : "'" + message.MessageDate.ToString() + "'");
strsql.AppendFormat(" MCommonid ='{0}'", message.MCommonid);
strsql.AppendFormat(" where Messageid={0}", message.Messageid);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public int Add(Model.tab_message message)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into tab_message values (");
strsql.AppendFormat("N'{0}',", message.Sender);
strsql.AppendFormat("N'{0}',", message.Receiver);
strsql.AppendFormat("N'{0}',", message.Title);
strsql.AppendFormat("N'{0}',", message.Msg);
strsql.AppendFormat("N'{0}',", message.Status);
strsql.AppendFormat("{0},", message.MessageDate == baddate ? "null" : "'" + message.MessageDate.ToString() + "'");
strsql.AppendFormat("{0}", message.MCommonid);
strsql.Append(")");
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public Model.tab_message getmessage(Model.tab_message message1)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from tab_message where ");
strsql.AppendFormat("Messageid='{0}'", message1.Messageid);
DataTable dt = sql.ExecuteDataSet(strsql.ToString()).Tables[0];
if (dt.Rows.Count < 1)
{
return(null);
}
Model.tab_message message = new Model.tab_message();
message.Sender = dt.Rows[0]["Sender"].ToString();
message.Receiver = dt.Rows[0]["Receiver"].ToString();
message.Title = dt.Rows[0]["Title"].ToString();
message.Msg = dt.Rows[0]["Msg"].ToString();
message.Status = dt.Rows[0]["Status"].ToString();
message.MessageDate = dt.Rows[0]["MessageDate"].ToString() == "" ? baddate : DateTime.Parse(dt.Rows[0]["MessageDate"].ToString());
message.MCommonid = int.Parse(dt.Rows[0]["MCommonid"].ToString());
return(message);
}
public int update(Model.tab_message message)
{
return(itu.update(message));
}
public Model.tab_message getmessage(Model.tab_message message1)
{
return(itu.getmessage(message1));
}
public int Add(Model.tab_message message)
{
return(itu.Add(message));
}
