/// <summary> /// 更新一条数据 /// </summary> //public bool Update(BWJS.Model.OrderRebateSettlementApply model) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("update dbo.[OrderRebateSettlementApply] set "); // strSql.Append(" SalesPercentage = @SalesPercentage , "); // strSql.Append(" PaymentMethod = @PaymentMethod , "); // strSql.Append(" OpeningBank = @OpeningBank , "); // strSql.Append(" CardHolder = @CardHolder , "); // strSql.Append(" CardNumber = @CardNumber , "); // strSql.Append(" Remark = @Remark , "); // strSql.Append(" CreateId = @CreateId , "); // strSql.Append(" CreateDate = @CreateDate , "); // strSql.Append(" EditId = @EditId , "); // strSql.Append(" EditDate = @EditDate , "); // strSql.Append(" UserId = @UserId , "); // strSql.Append(" IsDeleted = @IsDeleted , "); // strSql.Append(" DepartmentId = @DepartmentId , "); // strSql.Append(" StartDate = @StartDate , "); // strSql.Append(" EndDate = @EndDate , "); // strSql.Append(" ApplyMoney = @ApplyMoney , "); // strSql.Append(" ActualMoney = @ActualMoney , "); // strSql.Append(" ApplyStatus = @ApplyStatus , "); // strSql.Append(" SettlementMethod = @SettlementMethod "); // strSql.Append(" where OrderRebateSettlementApplyId=@OrderRebateSettlementApplyId "); // SqlParameter[] parameters = { // new SqlParameter("@OrderRebateSettlementApplyId",model.OrderRebateSettlementApplyId) , // new SqlParameter("@SalesPercentage",model.SalesPercentage) , // new SqlParameter("@PaymentMethod",model.PaymentMethod) , // new SqlParameter("@OpeningBank",model.OpeningBank) , // new SqlParameter("@CardHolder",model.CardHolder) , // new SqlParameter("@CardNumber",model.CardNumber) , // new SqlParameter("@Remark",model.Remark) , // new SqlParameter("@CreateId",model.CreateId) , // new SqlParameter("@CreateDate",model.CreateDate) , // new SqlParameter("@EditId",model.EditId) , // new SqlParameter("@EditDate",model.EditDate) , // new SqlParameter("@UserId",model.UserId) , // new SqlParameter("@IsDeleted",model.IsDeleted) , // new SqlParameter("@DepartmentId",model.DepartmentId) , // new SqlParameter("@StartDate",model.StartDate) , // new SqlParameter("@EndDate",model.EndDate) , // new SqlParameter("@ApplyMoney",model.ApplyMoney) , // new SqlParameter("@ActualMoney",model.ActualMoney) , // new SqlParameter("@ApplyStatus",model.ApplyStatus) , // new SqlParameter("@SettlementMethod",model.SettlementMethod) // }; // int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); // if (rows > 0) // { // return true; // } // else // { // return false; // } //} /// <summary> /// 删除一条数据 /// </summary> //public bool Delete(int OrderRebateSettlementApplyId) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("update dbo.[OrderRebateSettlementApply] set IsDeleted=1"); // strSql.Append(" where OrderRebateSettlementApplyId=@OrderRebateSettlementApplyId"); // SqlParameter[] parameters = { // new SqlParameter("@OrderRebateSettlementApplyId", SqlDbType.Int,4) // }; // parameters[0].Value = OrderRebateSettlementApplyId; // int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); // if (rows > 0) // { // return true; // } // else // { // return false; // } //} /// <summary> /// 批量删除一批数据 /// </summary> //public bool DeleteList(string OrderRebateSettlementApplyIdlist) //{ // StringBuilder strSql = new StringBuilder(); // strSql.Append("update dbo.[OrderRebateSettlementApply] set IsDeleted=1"); // strSql.Append(" where ID in (" + OrderRebateSettlementApplyIdlist + ") "); // int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString()); // if (rows > 0) // { // return true; // } // else // { // return false; // } //} /// <summary> /// 得到一个对象实体 /// </summary> public BWJS.Model.OrderRebateSettlementApply GetModel(int OrderRebateSettlementApplyId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderRebateSettlementApplyId, SalesPercentage, PaymentMethod, OpeningBank, CardHolder, CardNumber, Remark, CreateId, CreateDate, EditId, EditDate, UserId, IsDeleted, DepartmentId, StartDate, EndDate, ApplyMoney, ActualMoney, ApplyStatus, SettlementMethod "); strSql.Append(" from dbo.[OrderRebateSettlementApply] "); strSql.Append(" where OrderRebateSettlementApplyId=@OrderRebateSettlementApplyId"); SqlParameter[] parameters = { new SqlParameter("@OrderRebateSettlementApplyId", SqlDbType.Int, 4) }; parameters[0].Value = OrderRebateSettlementApplyId; BWJS.Model.OrderRebateSettlementApply model = new BWJS.Model.OrderRebateSettlementApply(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebateSettlementApply model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[OrderRebateSettlementApply]("); strSql.Append("SalesPercentage,PaymentMethod,OpeningBank,CardHolder,CardNumber,Remark,CreateId,CreateDate,EditId,EditDate,UserId,IsDeleted,DepartmentId,StartDate,EndDate,ApplyMoney,ActualMoney,ApplyStatus,SettlementMethod"); strSql.Append(") values ("); strSql.Append("@SalesPercentage,@PaymentMethod,@OpeningBank,@CardHolder,@CardNumber,@Remark,@CreateId,@CreateDate,@EditId,@EditDate,@UserId,@IsDeleted,@DepartmentId,@StartDate,@EndDate,@ApplyMoney,@ActualMoney,@ApplyStatus,@SettlementMethod"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@SalesPercentage", model.SalesPercentage), new SqlParameter("@PaymentMethod", model.PaymentMethod), new SqlParameter("@OpeningBank", model.OpeningBank), new SqlParameter("@CardHolder", model.CardHolder), new SqlParameter("@CardNumber", model.CardNumber), new SqlParameter("@Remark", model.Remark), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@UserId", model.UserId), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@DepartmentId", model.DepartmentId), new SqlParameter("@StartDate", model.StartDate), new SqlParameter("@EndDate", model.EndDate), new SqlParameter("@ApplyMoney", model.ApplyMoney), new SqlParameter("@ActualMoney", model.ActualMoney), new SqlParameter("@ApplyStatus", model.ApplyStatus), new SqlParameter("@SettlementMethod", model.SettlementMethod) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebateSettlementApply model) { return(dal.Add(model)); }
/// <summary> /// datarow转成对象实体 /// </summary> public BWJS.Model.OrderRebateSettlementApply DataRowToModel(DataRow row) { BWJS.Model.OrderRebateSettlementApply model = new BWJS.Model.OrderRebateSettlementApply(); if (row != null) { if (row["OrderRebateSettlementApplyId"].ToString() != "") { model.OrderRebateSettlementApplyId = int.Parse(row["OrderRebateSettlementApplyId"].ToString()); } if (row["SalesPercentage"].ToString() != "") { model.SalesPercentage = decimal.Parse(row["SalesPercentage"].ToString()); } if (row["PaymentMethod"].ToString() != "") { model.PaymentMethod = int.Parse(row["PaymentMethod"].ToString()); } model.OpeningBank = row["OpeningBank"].ToString(); model.CardHolder = row["CardHolder"].ToString(); model.CardNumber = row["CardNumber"].ToString(); model.Remark = row["Remark"].ToString(); if (row["CreateId"].ToString() != "") { model.CreateId = int.Parse(row["CreateId"].ToString()); } if (row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["EditId"].ToString() != "") { model.EditId = int.Parse(row["EditId"].ToString()); } if (row["EditDate"].ToString() != "") { model.EditDate = DateTime.Parse(row["EditDate"].ToString()); } if (row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["IsDeleted"].ToString() != "") { model.IsDeleted = int.Parse(row["IsDeleted"].ToString()); } if (row["DepartmentId"].ToString() != "") { model.DepartmentId = int.Parse(row["DepartmentId"].ToString()); } if (row["StartDate"].ToString() != "") { model.StartDate = DateTime.Parse(row["StartDate"].ToString()); } if (row["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(row["EndDate"].ToString()); } if (row["ApplyMoney"].ToString() != "") { model.ApplyMoney = decimal.Parse(row["ApplyMoney"].ToString()); } if (row["ActualMoney"].ToString() != "") { model.ActualMoney = decimal.Parse(row["ActualMoney"].ToString()); } if (row["ApplyStatus"].ToString() != "") { model.ApplyStatus = int.Parse(row["ApplyStatus"].ToString()); } if (row["SettlementMethod"].ToString() != "") { model.SettlementMethod = int.Parse(row["SettlementMethod"].ToString()); } return(model); } else { return(null); } }