/// <summary> /// 更新一条数据 /// </summary> public bool Update(BrnMall.Core.Model.SendBag model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SendBag set "); strSql.Append("Pice=@Pice,"); strSql.Append("SenderID=@SenderID,"); strSql.Append("ReceiverID=@ReceiverID,"); strSql.Append("SendType=@SendType,"); strSql.Append("Status=@Status,"); strSql.Append("Addtime=@Addtime,"); strSql.Append("SendTime=@SendTime"); strSql.Append("IsNotSend=@IsNotSend,"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Pice", SqlDbType.Int, 4), new SqlParameter("@SenderID", SqlDbType.Int, 4), new SqlParameter("@ReceiverID", SqlDbType.Int, 4), new SqlParameter("@SendType", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@IsNotSend", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Pice; parameters[1].Value = model.SenderID; parameters[2].Value = model.ReceiverID; parameters[3].Value = model.SendType; parameters[4].Value = model.Status; parameters[5].Value = model.Addtime; parameters[6].Value = model.SendTime; parameters[7].Value = model.IsNotSend; parameters[8].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BrnMall.Core.Model.SendBag model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SendBag("); strSql.Append("Pice,SenderID,ReceiverID,SendType,Status,Addtime,SendTime)"); strSql.Append(" values ("); strSql.Append("@Pice,@SenderID,@ReceiverID,@SendType,@Status,@Addtime,@SendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Pice", SqlDbType.Int, 4), new SqlParameter("@SenderID", SqlDbType.Int, 4), new SqlParameter("@ReceiverID", SqlDbType.Int, 4), new SqlParameter("@SendType", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@SendTime", SqlDbType.DateTime) }; parameters[0].Value = model.Pice; parameters[1].Value = model.SenderID; parameters[2].Value = model.ReceiverID; parameters[3].Value = model.SendType; parameters[4].Value = model.Status; parameters[5].Value = model.Addtime; parameters[6].Value = model.SendTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BrnMall.Core.Model.SendBag GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Mchbillno,Pice,SenderID,ReceiverID,SendType,Status,Addtime,SendTime from SendBag "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; BrnMall.Core.Model.SendBag model = new BrnMall.Core.Model.SendBag(); 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 BrnMall.Core.Model.SendBag DataRowToModel1(DataRow row) { BrnMall.Core.Model.SendBag model = new BrnMall.Core.Model.SendBag(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Mchbillno"] != null) { model.Mchbillno = row["Mchbillno"].ToString(); } if (row["Pice"] != null && row["Pice"].ToString() != "") { model.Pice = int.Parse(row["Pice"].ToString()); } if (row["SenderID"] != null && row["SenderID"].ToString() != "") { model.SenderID = int.Parse(row["SenderID"].ToString()); } if (row["ReceiverID"] != null && row["ReceiverID"].ToString() != "") { model.ReceiverID = int.Parse(row["ReceiverID"].ToString()); } if (row["SendType"] != null && row["SendType"].ToString() != "") { model.SendType = int.Parse(row["SendType"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["Addtime"] != null && row["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(row["Addtime"].ToString()); } if (row["SendTime"] != null && row["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(row["SendTime"].ToString()); } if (row["OID"] != null && row["OID"].ToString() != "") { model.OID = int.Parse(row["OID"].ToString()); } if (row["Noncestr"] != null) { model.Noncestr = row["Noncestr"].ToString(); } if (row["PaySign"] != null) { model.PaySign = row["PaySign"].ToString(); } if (row["IsNotSend"] != null && row["IsNotSend"].ToString() != "") { model.IsNotSend = int.Parse(row["IsNotSend"].ToString()); } if (row["username"] != null && row["username"].ToString() != "") { model.ModelUser = new BrnMall.Core.Model.bma_users { username = row["username"].ToString(), avatar = row["avatar"].ToString(), Userno = int.Parse(row["Userno"].ToString()), UserLevel = int.Parse(row["UserLevel"].ToString()) }; } //if (row["avatar"] != null && row["avatar"].ToString() != "") //{ // model.ModelUser.avatar = row["avatar"].ToString(); //} //if (row["Userno"] != null && row["Userno"].ToString() != "") //{ // model.ModelUser.Userno =int.Parse( row["Userno"].ToString()); //} //if (row["UserLevel"] != null && row["UserLevel"].ToString() != "") //{ // model.ModelUser.Userno = int.Parse(row["UserLevel"].ToString()); //} } return(model); }