/// <summary> /// 得到一个对象实体 /// </summary> public BWJS.Model.OrderRebateCheck GetModel(int OrderRebateId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderRebateId, AgentMoney, AgentRebate, HQRebate, HQMoney, NetProfit, PayStatus, IsSettled, IsCancel, SettlementDate, CreateDate, TransNo, Remark, IsDeleted, Exp_CreateId, Exp_CreateDate, Exp_EditId, Exp_EditDate, Exp_BatchNo, Exp_NewId, Exp_CompanyCategoryId, Exp_CompanyId, CompanyId, Exp_SettlementMethod, Exp_SalesPercentage, Exp_UserId, Exp_FullName, Exp_IdCardType, Exp_IdCard, Exp_Sex, Exp_Mobile, Exp_RecommendationCode, Exp_ApplicationAmount, UserId, Exp_LoanAmount, Exp_ContractAmount, Exp_LoanTerm, Exp_LoanDate, Exp_ProductId, Exp_ProductName, Exp_MerchantRebate, Exp_MerchantMoney, Exp_AgentRebate, Exp_AgentMoney, OrderApplyId, Exp_HQRebate, Exp_HQMoney, Exp_NetProfit, CompanyRebateId, OrderMoney, MerchantRebate, MerchantMoney "); strSql.Append(" from dbo.[OrderRebateCheck] "); strSql.Append(" where OrderRebateId=@OrderRebateId"); SqlParameter[] parameters = { new SqlParameter("@OrderRebateId", SqlDbType.Int, 4) }; parameters[0].Value = OrderRebateId; BWJS.Model.OrderRebateCheck model = new BWJS.Model.OrderRebateCheck(); 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 bool Update(BWJS.Model.OrderRebateCheck model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebateCheck model) { return(dal.Add(model)); }
/// <summary> /// datarow转成对象实体 /// </summary> public BWJS.Model.OrderRebateCheck DataRowToModel(DataRow row) { BWJS.Model.OrderRebateCheck model = new BWJS.Model.OrderRebateCheck(); if (row != null) { if (row["OrderRebateId"].ToString() != "") { model.OrderRebateId = int.Parse(row["OrderRebateId"].ToString()); } if (row["AgentMoney"].ToString() != "") { model.AgentMoney = decimal.Parse(row["AgentMoney"].ToString()); } if (row["AgentRebate"].ToString() != "") { model.AgentRebate = decimal.Parse(row["AgentRebate"].ToString()); } if (row["HQRebate"].ToString() != "") { model.HQRebate = decimal.Parse(row["HQRebate"].ToString()); } if (row["HQMoney"].ToString() != "") { model.HQMoney = decimal.Parse(row["HQMoney"].ToString()); } if (row["NetProfit"].ToString() != "") { model.NetProfit = decimal.Parse(row["NetProfit"].ToString()); } if (row["PayStatus"].ToString() != "") { model.PayStatus = int.Parse(row["PayStatus"].ToString()); } if (row["IsSettled"].ToString() != "") { model.IsSettled = int.Parse(row["IsSettled"].ToString()); } if (row["IsCancel"].ToString() != "") { model.IsCancel = int.Parse(row["IsCancel"].ToString()); } if (row["SettlementDate"].ToString() != "") { model.SettlementDate = DateTime.Parse(row["SettlementDate"].ToString()); } if (row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } model.TransNo = row["TransNo"].ToString(); model.Remark = row["Remark"].ToString(); if (row["IsDeleted"].ToString() != "") { model.IsDeleted = int.Parse(row["IsDeleted"].ToString()); } if (row["Exp_CreateId"].ToString() != "") { model.Exp_CreateId = int.Parse(row["Exp_CreateId"].ToString()); } if (row["Exp_CreateDate"].ToString() != "") { model.Exp_CreateDate = DateTime.Parse(row["Exp_CreateDate"].ToString()); } if (row["Exp_EditId"].ToString() != "") { model.Exp_EditId = int.Parse(row["Exp_EditId"].ToString()); } if (row["Exp_EditDate"].ToString() != "") { model.Exp_EditDate = DateTime.Parse(row["Exp_EditDate"].ToString()); } model.Exp_BatchNo = row["Exp_BatchNo"].ToString(); if (row["Exp_NewId"].ToString() != "") { model.Exp_NewId = int.Parse(row["Exp_NewId"].ToString()); } if (row["Exp_CompanyCategoryId"].ToString() != "") { model.Exp_CompanyCategoryId = int.Parse(row["Exp_CompanyCategoryId"].ToString()); } if (row["Exp_CompanyId"].ToString() != "") { model.Exp_CompanyId = int.Parse(row["Exp_CompanyId"].ToString()); } if (row["CompanyId"].ToString() != "") { model.CompanyId = int.Parse(row["CompanyId"].ToString()); } if (row["Exp_SettlementMethod"].ToString() != "") { model.Exp_SettlementMethod = int.Parse(row["Exp_SettlementMethod"].ToString()); } if (row["Exp_SalesPercentage"].ToString() != "") { model.Exp_SalesPercentage = decimal.Parse(row["Exp_SalesPercentage"].ToString()); } if (row["Exp_UserId"].ToString() != "") { model.Exp_UserId = int.Parse(row["Exp_UserId"].ToString()); } model.Exp_FullName = row["Exp_FullName"].ToString(); if (row["Exp_IdCardType"].ToString() != "") { model.Exp_IdCardType = int.Parse(row["Exp_IdCardType"].ToString()); } model.Exp_IdCard = row["Exp_IdCard"].ToString(); if (row["Exp_Sex"].ToString() != "") { model.Exp_Sex = int.Parse(row["Exp_Sex"].ToString()); } model.Exp_Mobile = row["Exp_Mobile"].ToString(); model.Exp_RecommendationCode = row["Exp_RecommendationCode"].ToString(); if (row["Exp_ApplicationAmount"].ToString() != "") { model.Exp_ApplicationAmount = decimal.Parse(row["Exp_ApplicationAmount"].ToString()); } if (row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["Exp_LoanAmount"].ToString() != "") { model.Exp_LoanAmount = decimal.Parse(row["Exp_LoanAmount"].ToString()); } if (row["Exp_ContractAmount"].ToString() != "") { model.Exp_ContractAmount = decimal.Parse(row["Exp_ContractAmount"].ToString()); } if (row["Exp_LoanTerm"].ToString() != "") { model.Exp_LoanTerm = int.Parse(row["Exp_LoanTerm"].ToString()); } if (row["Exp_LoanDate"].ToString() != "") { model.Exp_LoanDate = DateTime.Parse(row["Exp_LoanDate"].ToString()); } if (row["Exp_ProductId"].ToString() != "") { model.Exp_ProductId = int.Parse(row["Exp_ProductId"].ToString()); } model.Exp_ProductName = row["Exp_ProductName"].ToString(); if (row["Exp_MerchantRebate"].ToString() != "") { model.Exp_MerchantRebate = decimal.Parse(row["Exp_MerchantRebate"].ToString()); } if (row["Exp_MerchantMoney"].ToString() != "") { model.Exp_MerchantMoney = decimal.Parse(row["Exp_MerchantMoney"].ToString()); } if (row["Exp_AgentRebate"].ToString() != "") { model.Exp_AgentRebate = decimal.Parse(row["Exp_AgentRebate"].ToString()); } if (row["Exp_AgentMoney"].ToString() != "") { model.Exp_AgentMoney = decimal.Parse(row["Exp_AgentMoney"].ToString()); } if (row["OrderApplyId"].ToString() != "") { model.OrderApplyId = int.Parse(row["OrderApplyId"].ToString()); } if (row["Exp_HQRebate"].ToString() != "") { model.Exp_HQRebate = decimal.Parse(row["Exp_HQRebate"].ToString()); } if (row["Exp_HQMoney"].ToString() != "") { model.Exp_HQMoney = decimal.Parse(row["Exp_HQMoney"].ToString()); } if (row["Exp_NetProfit"].ToString() != "") { model.Exp_NetProfit = decimal.Parse(row["Exp_NetProfit"].ToString()); } if (row["CompanyRebateId"].ToString() != "") { model.CompanyRebateId = int.Parse(row["CompanyRebateId"].ToString()); } if (row["OrderMoney"].ToString() != "") { model.OrderMoney = decimal.Parse(row["OrderMoney"].ToString()); } if (row["MerchantRebate"].ToString() != "") { model.MerchantRebate = decimal.Parse(row["MerchantRebate"].ToString()); } if (row["MerchantMoney"].ToString() != "") { model.MerchantMoney = decimal.Parse(row["MerchantMoney"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebateCheck model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[OrderRebateCheck]("); strSql.Append("AgentMoney,AgentRebate,HQRebate,HQMoney,NetProfit,PayStatus,IsSettled,IsCancel,SettlementDate,CreateDate,TransNo,Remark,IsDeleted,Exp_CreateId,Exp_CreateDate,Exp_EditId,Exp_EditDate,Exp_BatchNo,Exp_NewId,Exp_CompanyCategoryId,Exp_CompanyId,CompanyId,Exp_SettlementMethod,Exp_SalesPercentage,Exp_UserId,Exp_FullName,Exp_IdCardType,Exp_IdCard,Exp_Sex,Exp_Mobile,Exp_RecommendationCode,Exp_ApplicationAmount,UserId,Exp_LoanAmount,Exp_ContractAmount,Exp_LoanTerm,Exp_LoanDate,Exp_ProductId,Exp_ProductName,Exp_MerchantRebate,Exp_MerchantMoney,Exp_AgentRebate,Exp_AgentMoney,OrderApplyId,Exp_HQRebate,Exp_HQMoney,Exp_NetProfit,CompanyRebateId,OrderMoney,MerchantRebate,MerchantMoney"); strSql.Append(") values ("); strSql.Append("@AgentMoney,@AgentRebate,@HQRebate,@HQMoney,@NetProfit,@PayStatus,@IsSettled,@IsCancel,@SettlementDate,@CreateDate,@TransNo,@Remark,@IsDeleted,@Exp_CreateId,@Exp_CreateDate,@Exp_EditId,@Exp_EditDate,@Exp_BatchNo,@Exp_NewId,@Exp_CompanyCategoryId,@Exp_CompanyId,@CompanyId,@Exp_SettlementMethod,@Exp_SalesPercentage,@Exp_UserId,@Exp_FullName,@Exp_IdCardType,@Exp_IdCard,@Exp_Sex,@Exp_Mobile,@Exp_RecommendationCode,@Exp_ApplicationAmount,@UserId,@Exp_LoanAmount,@Exp_ContractAmount,@Exp_LoanTerm,@Exp_LoanDate,@Exp_ProductId,@Exp_ProductName,@Exp_MerchantRebate,@Exp_MerchantMoney,@Exp_AgentRebate,@Exp_AgentMoney,@OrderApplyId,@Exp_HQRebate,@Exp_HQMoney,@Exp_NetProfit,@CompanyRebateId,@OrderMoney,@MerchantRebate,@MerchantMoney"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@AgentMoney", model.AgentMoney), new SqlParameter("@AgentRebate", model.AgentRebate), new SqlParameter("@HQRebate", model.HQRebate), new SqlParameter("@HQMoney", model.HQMoney), new SqlParameter("@NetProfit", model.NetProfit), new SqlParameter("@PayStatus", model.PayStatus), new SqlParameter("@IsSettled", model.IsSettled), new SqlParameter("@IsCancel", model.IsCancel), new SqlParameter("@SettlementDate", model.SettlementDate), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@TransNo", model.TransNo), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@Exp_CreateId", model.Exp_CreateId), new SqlParameter("@Exp_CreateDate", model.Exp_CreateDate), new SqlParameter("@Exp_EditId", model.Exp_EditId), new SqlParameter("@Exp_EditDate", model.Exp_EditDate), new SqlParameter("@Exp_BatchNo", model.Exp_BatchNo), new SqlParameter("@Exp_NewId", model.Exp_NewId), new SqlParameter("@Exp_CompanyCategoryId", model.Exp_CompanyCategoryId), new SqlParameter("@Exp_CompanyId", model.Exp_CompanyId), new SqlParameter("@CompanyId", model.CompanyId), new SqlParameter("@Exp_SettlementMethod", model.Exp_SettlementMethod), new SqlParameter("@Exp_SalesPercentage", model.Exp_SalesPercentage), new SqlParameter("@Exp_UserId", model.Exp_UserId), new SqlParameter("@Exp_FullName", model.Exp_FullName), new SqlParameter("@Exp_IdCardType", model.Exp_IdCardType), new SqlParameter("@Exp_IdCard", model.Exp_IdCard), new SqlParameter("@Exp_Sex", model.Exp_Sex), new SqlParameter("@Exp_Mobile", model.Exp_Mobile), new SqlParameter("@Exp_RecommendationCode", model.Exp_RecommendationCode), new SqlParameter("@Exp_ApplicationAmount", model.Exp_ApplicationAmount), new SqlParameter("@UserId", model.UserId), new SqlParameter("@Exp_LoanAmount", model.Exp_LoanAmount), new SqlParameter("@Exp_ContractAmount", model.Exp_ContractAmount), new SqlParameter("@Exp_LoanTerm", model.Exp_LoanTerm), new SqlParameter("@Exp_LoanDate", model.Exp_LoanDate), new SqlParameter("@Exp_ProductId", model.Exp_ProductId), new SqlParameter("@Exp_ProductName", model.Exp_ProductName), new SqlParameter("@Exp_MerchantRebate", model.Exp_MerchantRebate), new SqlParameter("@Exp_MerchantMoney", model.Exp_MerchantMoney), new SqlParameter("@Exp_AgentRebate", model.Exp_AgentRebate), new SqlParameter("@Exp_AgentMoney", model.Exp_AgentMoney), new SqlParameter("@OrderApplyId", model.OrderApplyId), new SqlParameter("@Exp_HQRebate", model.Exp_HQRebate), new SqlParameter("@Exp_HQMoney", model.Exp_HQMoney), new SqlParameter("@Exp_NetProfit", model.Exp_NetProfit), new SqlParameter("@CompanyRebateId", model.CompanyRebateId), new SqlParameter("@OrderMoney", model.OrderMoney), new SqlParameter("@MerchantRebate", model.MerchantRebate), new SqlParameter("@MerchantMoney", model.MerchantMoney) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.OrderRebateCheck model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[OrderRebateCheck] set "); strSql.Append(" AgentMoney = @AgentMoney , "); strSql.Append(" AgentRebate = @AgentRebate , "); strSql.Append(" HQRebate = @HQRebate , "); strSql.Append(" HQMoney = @HQMoney , "); strSql.Append(" NetProfit = @NetProfit , "); strSql.Append(" PayStatus = @PayStatus , "); strSql.Append(" IsSettled = @IsSettled , "); strSql.Append(" IsCancel = @IsCancel , "); strSql.Append(" SettlementDate = @SettlementDate , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" TransNo = @TransNo , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" Exp_CreateId = @Exp_CreateId , "); strSql.Append(" Exp_CreateDate = @Exp_CreateDate , "); strSql.Append(" Exp_EditId = @Exp_EditId , "); strSql.Append(" Exp_EditDate = @Exp_EditDate , "); strSql.Append(" Exp_BatchNo = @Exp_BatchNo , "); strSql.Append(" Exp_NewId = @Exp_NewId , "); strSql.Append(" Exp_CompanyCategoryId = @Exp_CompanyCategoryId , "); strSql.Append(" Exp_CompanyId = @Exp_CompanyId , "); strSql.Append(" CompanyId = @CompanyId , "); strSql.Append(" Exp_SettlementMethod = @Exp_SettlementMethod , "); strSql.Append(" Exp_SalesPercentage = @Exp_SalesPercentage , "); strSql.Append(" Exp_UserId = @Exp_UserId , "); strSql.Append(" Exp_FullName = @Exp_FullName , "); strSql.Append(" Exp_IdCardType = @Exp_IdCardType , "); strSql.Append(" Exp_IdCard = @Exp_IdCard , "); strSql.Append(" Exp_Sex = @Exp_Sex , "); strSql.Append(" Exp_Mobile = @Exp_Mobile , "); strSql.Append(" Exp_RecommendationCode = @Exp_RecommendationCode , "); strSql.Append(" Exp_ApplicationAmount = @Exp_ApplicationAmount , "); strSql.Append(" UserId = @UserId , "); strSql.Append(" Exp_LoanAmount = @Exp_LoanAmount , "); strSql.Append(" Exp_ContractAmount = @Exp_ContractAmount , "); strSql.Append(" Exp_LoanTerm = @Exp_LoanTerm , "); strSql.Append(" Exp_LoanDate = @Exp_LoanDate , "); strSql.Append(" Exp_ProductId = @Exp_ProductId , "); strSql.Append(" Exp_ProductName = @Exp_ProductName , "); strSql.Append(" Exp_MerchantRebate = @Exp_MerchantRebate , "); strSql.Append(" Exp_MerchantMoney = @Exp_MerchantMoney , "); strSql.Append(" Exp_AgentRebate = @Exp_AgentRebate , "); strSql.Append(" Exp_AgentMoney = @Exp_AgentMoney , "); strSql.Append(" OrderApplyId = @OrderApplyId , "); strSql.Append(" Exp_HQRebate = @Exp_HQRebate , "); strSql.Append(" Exp_HQMoney = @Exp_HQMoney , "); strSql.Append(" Exp_NetProfit = @Exp_NetProfit , "); strSql.Append(" CompanyRebateId = @CompanyRebateId , "); strSql.Append(" OrderMoney = @OrderMoney , "); strSql.Append(" MerchantRebate = @MerchantRebate , "); strSql.Append(" MerchantMoney = @MerchantMoney "); strSql.Append(" where OrderRebateId=@OrderRebateId "); SqlParameter[] parameters = { new SqlParameter("@OrderRebateId", model.OrderRebateId), new SqlParameter("@AgentMoney", model.AgentMoney), new SqlParameter("@AgentRebate", model.AgentRebate), new SqlParameter("@HQRebate", model.HQRebate), new SqlParameter("@HQMoney", model.HQMoney), new SqlParameter("@NetProfit", model.NetProfit), new SqlParameter("@PayStatus", model.PayStatus), new SqlParameter("@IsSettled", model.IsSettled), new SqlParameter("@IsCancel", model.IsCancel), new SqlParameter("@SettlementDate", model.SettlementDate), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@TransNo", model.TransNo), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@Exp_CreateId", model.Exp_CreateId), new SqlParameter("@Exp_CreateDate", model.Exp_CreateDate), new SqlParameter("@Exp_EditId", model.Exp_EditId), new SqlParameter("@Exp_EditDate", model.Exp_EditDate), new SqlParameter("@Exp_BatchNo", model.Exp_BatchNo), new SqlParameter("@Exp_NewId", model.Exp_NewId), new SqlParameter("@Exp_CompanyCategoryId", model.Exp_CompanyCategoryId), new SqlParameter("@Exp_CompanyId", model.Exp_CompanyId), new SqlParameter("@CompanyId", model.CompanyId), new SqlParameter("@Exp_SettlementMethod", model.Exp_SettlementMethod), new SqlParameter("@Exp_SalesPercentage", model.Exp_SalesPercentage), new SqlParameter("@Exp_UserId", model.Exp_UserId), new SqlParameter("@Exp_FullName", model.Exp_FullName), new SqlParameter("@Exp_IdCardType", model.Exp_IdCardType), new SqlParameter("@Exp_IdCard", model.Exp_IdCard), new SqlParameter("@Exp_Sex", model.Exp_Sex), new SqlParameter("@Exp_Mobile", model.Exp_Mobile), new SqlParameter("@Exp_RecommendationCode", model.Exp_RecommendationCode), new SqlParameter("@Exp_ApplicationAmount", model.Exp_ApplicationAmount), new SqlParameter("@UserId", model.UserId), new SqlParameter("@Exp_LoanAmount", model.Exp_LoanAmount), new SqlParameter("@Exp_ContractAmount", model.Exp_ContractAmount), new SqlParameter("@Exp_LoanTerm", model.Exp_LoanTerm), new SqlParameter("@Exp_LoanDate", model.Exp_LoanDate), new SqlParameter("@Exp_ProductId", model.Exp_ProductId), new SqlParameter("@Exp_ProductName", model.Exp_ProductName), new SqlParameter("@Exp_MerchantRebate", model.Exp_MerchantRebate), new SqlParameter("@Exp_MerchantMoney", model.Exp_MerchantMoney), new SqlParameter("@Exp_AgentRebate", model.Exp_AgentRebate), new SqlParameter("@Exp_AgentMoney", model.Exp_AgentMoney), new SqlParameter("@OrderApplyId", model.OrderApplyId), new SqlParameter("@Exp_HQRebate", model.Exp_HQRebate), new SqlParameter("@Exp_HQMoney", model.Exp_HQMoney), new SqlParameter("@Exp_NetProfit", model.Exp_NetProfit), new SqlParameter("@CompanyRebateId", model.CompanyRebateId), new SqlParameter("@OrderMoney", model.OrderMoney), new SqlParameter("@MerchantRebate", model.MerchantRebate), new SqlParameter("@MerchantMoney", model.MerchantMoney) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }