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