/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Bitshare.DataDecision.Model.tblMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tblMessage set ");
strSql.Append("Sender=@Sender,");
strSql.Append("Accepter=@Accepter,");
strSql.Append("MsgType=@MsgType,");
strSql.Append("MsgTitle=@MsgTitle,");
strSql.Append("MsgContent=@MsgContent,");
strSql.Append("SendDate=@SendDate,");
strSql.Append("AcceptDate=@AcceptDate,");
strSql.Append("State=@State,");
strSql.Append("ProcessId=@ProcessId,");
strSql.Append("AdOrderId=@AdOrderId,");
strSql.Append("ProcessSeriaNum=@ProcessSeriaNum,");
strSql.Append("DeleteState=@DeleteState");
strSql.Append(" where Rid=@Rid");
SqlParameter[] parameters =
{
new SqlParameter("@Sender", SqlDbType.VarChar, 50),
new SqlParameter("@Accepter", SqlDbType.VarChar, 50),
new SqlParameter("@MsgType", SqlDbType.VarChar, 50),
new SqlParameter("@MsgTitle", SqlDbType.VarChar, 100),
new SqlParameter("@MsgContent", SqlDbType.VarChar, 8000),
new SqlParameter("@SendDate", SqlDbType.DateTime),
new SqlParameter("@AcceptDate", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@ProcessId", SqlDbType.VarChar, 50),
new SqlParameter("@AdOrderId", SqlDbType.VarChar, 50),
new SqlParameter("@ProcessSeriaNum", SqlDbType.Int, 4),
new SqlParameter("@DeleteState", SqlDbType.Int, 4),
new SqlParameter("@Rid", SqlDbType.Int, 4)
};
parameters[0].Value = model.Sender;
parameters[1].Value = model.Accepter;
parameters[2].Value = model.MsgType;
parameters[3].Value = model.MsgTitle;
parameters[4].Value = model.MsgContent;
parameters[5].Value = model.SendDate;
parameters[6].Value = model.AcceptDate;
parameters[7].Value = model.State;
parameters[8].Value = model.ProcessId;
parameters[9].Value = model.AdOrderId;
parameters[10].Value = model.ProcessSeriaNum;
parameters[11].Value = model.DeleteState;
parameters[12].Value = model.Rid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Bitshare.DataDecision.Model.tblMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tblMessage(");
strSql.Append("Sender,Accepter,MsgType,MsgTitle,MsgContent,SendDate,AcceptDate,State,ProcessId,AdOrderId,ProcessSeriaNum,DeleteState)");
strSql.Append(" values (");
strSql.Append("@Sender,@Accepter,@MsgType,@MsgTitle,@MsgContent,@SendDate,@AcceptDate,@State,@ProcessId,@AdOrderId,@ProcessSeriaNum,@DeleteState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Sender", SqlDbType.VarChar, 50),
new SqlParameter("@Accepter", SqlDbType.VarChar, 50),
new SqlParameter("@MsgType", SqlDbType.VarChar, 50),
new SqlParameter("@MsgTitle", SqlDbType.VarChar, 100),
new SqlParameter("@MsgContent", SqlDbType.VarChar, 8000),
new SqlParameter("@SendDate", SqlDbType.DateTime),
new SqlParameter("@AcceptDate", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@ProcessId", SqlDbType.VarChar, 50),
new SqlParameter("@AdOrderId", SqlDbType.VarChar, 50),
new SqlParameter("@ProcessSeriaNum", SqlDbType.Int, 4),
new SqlParameter("@DeleteState", SqlDbType.Int, 4)
};
parameters[0].Value = model.Sender;
parameters[1].Value = model.Accepter;
parameters[2].Value = model.MsgType;
parameters[3].Value = model.MsgTitle;
parameters[4].Value = model.MsgContent;
parameters[5].Value = model.SendDate;
parameters[6].Value = model.AcceptDate;
parameters[7].Value = model.State;
parameters[8].Value = model.ProcessId;
parameters[9].Value = model.AdOrderId;
parameters[10].Value = model.ProcessSeriaNum;
parameters[11].Value = model.DeleteState;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bitshare.DataDecision.Model.tblMessage GetModel(int Rid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Rid,Sender,Accepter,MsgType,MsgTitle,MsgContent,SendDate,AcceptDate,State,ProcessId,AdOrderId,ProcessSeriaNum,DeleteState from tblMessage ");
strSql.Append(" where Rid=@Rid");
SqlParameter[] parameters =
{
new SqlParameter("@Rid", SqlDbType.Int, 4)
};
parameters[0].Value = Rid;
Bitshare.DataDecision.Model.tblMessage model = new Bitshare.DataDecision.Model.tblMessage();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bitshare.DataDecision.Model.tblMessage DataRowToModel(DataRow row)
{
Bitshare.DataDecision.Model.tblMessage model = new Bitshare.DataDecision.Model.tblMessage();
if (row != null)
{
if (row["Rid"] != null && row["Rid"].ToString() != "")
{
model.Rid = int.Parse(row["Rid"].ToString());
}
if (row["Sender"] != null)
{
model.Sender = row["Sender"].ToString();
}
if (row["Accepter"] != null)
{
model.Accepter = row["Accepter"].ToString();
}
if (row["MsgType"] != null)
{
model.MsgType = row["MsgType"].ToString();
}
if (row["MsgTitle"] != null)
{
model.MsgTitle = row["MsgTitle"].ToString();
}
if (row["MsgContent"] != null)
{
model.MsgContent = row["MsgContent"].ToString();
}
if (row["SendDate"] != null && row["SendDate"].ToString() != "")
{
model.SendDate = DateTime.Parse(row["SendDate"].ToString());
}
if (row["AcceptDate"] != null && row["AcceptDate"].ToString() != "")
{
model.AcceptDate = DateTime.Parse(row["AcceptDate"].ToString());
}
if (row["State"] != null && row["State"].ToString() != "")
{
if ((row["State"].ToString() == "1") || (row["State"].ToString().ToLower() == "true"))
{
model.State = true;
}
else
{
model.State = false;
}
}
if (row["ProcessId"] != null)
{
model.ProcessId = row["ProcessId"].ToString();
}
if (row["AdOrderId"] != null)
{
model.AdOrderId = row["AdOrderId"].ToString();
}
if (row["ProcessSeriaNum"] != null && row["ProcessSeriaNum"].ToString() != "")
{
model.ProcessSeriaNum = int.Parse(row["ProcessSeriaNum"].ToString());
}
if (row["DeleteState"] != null && row["DeleteState"].ToString() != "")
{
model.DeleteState = int.Parse(row["DeleteState"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Bitshare.DataDecision.Model.tblMessage model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Bitshare.DataDecision.Model.tblMessage model)
{
return(dal.Add(model));
}
