/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users.user_amount_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_amount_log("); strSql.Append("user_id,user_name,type,order_no,trade_no,payment_id,value,remark,status,add_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@type,@order_no,@trade_no,@payment_id,@value,@remark,@status,@add_time,@complete_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@order_no", SqlDbType.NVarChar, 100), new SqlParameter("@trade_no", SqlDbType.NVarChar, 100), new SqlParameter("@payment_id", SqlDbType.Int, 4), new SqlParameter("@value", SqlDbType.Decimal, 5), new SqlParameter("@remark", SqlDbType.NVarChar, 500), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@complete_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.type; parameters[3].Value = model.order_no; parameters[4].Value = model.trade_no; parameters[5].Value = model.payment_id; parameters[6].Value = model.value; parameters[7].Value = model.remark; parameters[8].Value = model.status; parameters[9].Value = model.add_time; parameters[10].Value = model.complete_time; parameters[11].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.status > 0) { StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.value); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[11].Value); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int user_id, string user_name, string type, decimal value, string remark) { Model.users.user_amount_log model = new Model.users.user_amount_log(); model.user_id = user_id; model.user_name = user_name; model.type = type; model.value = value; model.remark = remark; return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int user_id, string user_name, string type, decimal value, string remark) { Model.users.user_amount_log model = new Model.users.user_amount_log(); model.user_id = user_id; model.user_name = user_name; model.type = type; model.value = value; model.remark = remark; return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int user_id, string user_name, string type, decimal value, string remark, int status) { Model.users.user_amount_log model = new Model.users.user_amount_log(); model.user_id = user_id; model.user_name = user_name; model.type = type; model.value = value; model.remark = remark; model.status = status; model.complete_time = DateTime.Now; return dal.Add(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int user_id, string user_name, string type, decimal value, string remark, int status) { Model.users.user_amount_log model = new Model.users.user_amount_log(); model.user_id = user_id; model.user_name = user_name; model.type = type; model.value = value; model.remark = remark; model.status = status; model.complete_time = DateTime.Now; return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users.user_amount_log model) { return(dal.Update(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users.user_amount_log GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,type,order_no,trade_no,payment_id,value,remark,status,add_time,complete_time from " + databaseprefix + "user_amount_log "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users.user_amount_log model = new Model.users.user_amount_log(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = ds.Tables[0].Rows[0]["type"].ToString(); } if (ds.Tables[0].Rows[0]["order_no"] != null && ds.Tables[0].Rows[0]["order_no"].ToString() != "") { model.order_no = ds.Tables[0].Rows[0]["order_no"].ToString(); } if (ds.Tables[0].Rows[0]["trade_no"] != null && ds.Tables[0].Rows[0]["trade_no"].ToString() != "") { model.order_no = ds.Tables[0].Rows[0]["trade_no"].ToString(); } if (ds.Tables[0].Rows[0]["payment_id"] != null && ds.Tables[0].Rows[0]["payment_id"].ToString() != "") { model.payment_id = int.Parse(ds.Tables[0].Rows[0]["payment_id"].ToString()); } if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "") { model.value = decimal.Parse(ds.Tables[0].Rows[0]["value"].ToString()); } if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "") { model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); } if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } if (ds.Tables[0].Rows[0]["complete_time"] != null && ds.Tables[0].Rows[0]["complete_time"].ToString() != "") { model.complete_time = DateTime.Parse(ds.Tables[0].Rows[0]["complete_time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users.user_amount_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_amount_log set "); strSql.Append("user_id=@user_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("type=@type,"); strSql.Append("order_no=@order_no,"); strSql.Append("trade_no=@trade_no,"); strSql.Append("payment_id=@payment_id,"); strSql.Append("value=@value,"); strSql.Append("remark=@remark,"); strSql.Append("status=@status,"); strSql.Append("add_time=@add_time,"); strSql.Append("complete_time=@complete_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@order_no", SqlDbType.NVarChar, 100), new SqlParameter("@trade_no", SqlDbType.NVarChar, 100), new SqlParameter("@payment_id", SqlDbType.Int, 4), new SqlParameter("@value", SqlDbType.Decimal, 5), new SqlParameter("@remark", SqlDbType.NVarChar, 500), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@complete_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.type; parameters[3].Value = model.order_no; parameters[4].Value = model.trade_no; parameters[5].Value = model.payment_id; parameters[6].Value = model.value; parameters[7].Value = model.remark; parameters[8].Value = model.status; parameters[9].Value = model.add_time; parameters[10].Value = model.complete_time; parameters[11].Value = model.id; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.status > 0) { StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.value); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users.user_amount_log GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,type,order_no,trade_no,payment_id,value,remark,status,add_time,complete_time from " + databaseprefix + "user_amount_log "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; Model.users.user_amount_log model = new Model.users.user_amount_log(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = ds.Tables[0].Rows[0]["type"].ToString(); } if (ds.Tables[0].Rows[0]["order_no"] != null && ds.Tables[0].Rows[0]["order_no"].ToString() != "") { model.order_no = ds.Tables[0].Rows[0]["order_no"].ToString(); } if (ds.Tables[0].Rows[0]["trade_no"] != null && ds.Tables[0].Rows[0]["trade_no"].ToString() != "") { model.order_no = ds.Tables[0].Rows[0]["trade_no"].ToString(); } if (ds.Tables[0].Rows[0]["payment_id"] != null && ds.Tables[0].Rows[0]["payment_id"].ToString() != "") { model.payment_id = int.Parse(ds.Tables[0].Rows[0]["payment_id"].ToString()); } if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "") { model.value = decimal.Parse(ds.Tables[0].Rows[0]["value"].ToString()); } if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "") { model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); } if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } if (ds.Tables[0].Rows[0]["complete_time"] != null && ds.Tables[0].Rows[0]["complete_time"].ToString() != "") { model.complete_time = DateTime.Parse(ds.Tables[0].Rows[0]["complete_time"].ToString()); } return model; } else { return null; } }