/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_Picture model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[xbwn_Picture]("); strSql.Append("NetLoanApplyId,Base64Code,ImgId,IsDeleted,CreateId,CreateDate,EditId,EditDate"); strSql.Append(") values ("); strSql.Append("@NetLoanApplyId,@Base64Code,@ImgId,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@Base64Code", model.Base64Code), new SqlParameter("@ImgId", model.ImgId), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(R_UsersMachine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into R_UsersMachine("); strSql.Append("UserID,MachineID,RecordIsDelete,RecordCreateTime,RecordUpdateTime)"); strSql.Append(" values ("); strSql.Append("@UserID,@MachineID,@RecordIsDelete,@RecordCreateTime,@RecordUpdateTime)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@MachineID", SqlDbType.Int, 4), new SqlParameter("@RecordIsDelete", SqlDbType.Bit, 1), new SqlParameter("@RecordCreateTime", SqlDbType.DateTime), new SqlParameter("@RecordUpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.MachineID; parameters[2].Value = model.RecordIsDelete; parameters[3].Value = model.RecordCreateTime; parameters[4].Value = model.RecordUpdateTime; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebateSettlementDetails model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[OrderRebateSettlementDetails]("); strSql.Append("OrderRebateSettlementApplyId,OrderRebateId,CreateDate,CreateId"); strSql.Append(") values ("); strSql.Append("@OrderRebateSettlementApplyId,@OrderRebateId,@CreateDate,@CreateId"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@OrderRebateSettlementApplyId", model.OrderRebateSettlementApplyId), new SqlParameter("@OrderRebateId", model.OrderRebateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@CreateId", model.CreateId) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.SysConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[SysConfig]("); strSql.Append("RecordCreateTime,KeyType,KeyName,KeyVal,Description,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime"); strSql.Append(") values ("); strSql.Append("@RecordCreateTime,@KeyType,@KeyName,@KeyVal,@Description,@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,@RecordUpdateTime"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@RecordCreateTime", model.RecordCreateTime), new SqlParameter("@KeyType", model.KeyType), new SqlParameter("@KeyName", model.KeyName), new SqlParameter("@KeyVal", model.KeyVal), new SqlParameter("@Description", model.Description), new SqlParameter("@CreatUserID", model.CreatUserID), new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Resource model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Resource("); strSql.Append("ResourceName,FileName,VirtualPath,FilePath,FileSuffix,MD5,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime,RecordCreateTime"); strSql.Append(") values ("); strSql.Append("@ResourceName,@FileName,@VirtualPath,@FilePath,@FileSuffix,Upper(RIGHT(sys.fn_varbintohexstr(HASHBYTES('MD5',@FilePath)),32)),@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,GetDate(),GetDate()"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ResourceName", model.ResourceName), new SqlParameter("@FileName", model.FileName), new SqlParameter("@VirtualPath", model.VirtualPath), new SqlParameter("@FilePath", model.FilePath), new SqlParameter("@FileSuffix", model.FileSuffix), new SqlParameter("@CreatUserID", model.CreatUserID), new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID), new SqlParameter("@RecordIsDelete", model.RecordIsDelete) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public int UpdateRole(BWJS.Model.UserRole model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE UserRole SET IsDeleted=1 WHERE UserId=" + model.UserId + " AND IsDeleted=0;"); strSql.Append(@" INSERT INTO UserRole ([UserId],[RoleId],[CreateId],[CreateDate] ,[EditId] ,[EditDate] ,[IsDeleted])VALUES(@UserId ,@RoleId ,@CreateId,GETDATE() ,@EditId,GETDATE() ,@IsDeleted);select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@UserId", model.UserId), new SqlParameter("@RoleId", model.RoleId), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@EditId", model.EditId), new SqlParameter("@IsDeleted", model.IsDeleted) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.NL_ConsultStatusChangeLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[NL_ConsultStatusChangeLog]("); strSql.Append("ConsultId,BusinessType,Status,PrevStatus,CreateDate"); strSql.Append(") values ("); strSql.Append("@ConsultId,@BusinessType,@Status,@PrevStatus,@CreateDate"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ConsultId", model.ConsultId), new SqlParameter("@BusinessType", model.BusinessType), new SqlParameter("@Status", model.Status), new SqlParameter("@PrevStatus", model.PrevStatus), new SqlParameter("@CreateDate", model.CreateDate) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.RoleFunction model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RoleFunction("); strSql.Append("RoleFunctionId,RoleId,FunctionId,CreateId,CreateDate,EditId,EditDate,IsDeleted"); strSql.Append(") values ("); strSql.Append("@RoleFunctionId,@RoleId,@FunctionId,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@RoleFunctionId", model.RoleFunctionId), new SqlParameter("@RoleId", model.RoleId), new SqlParameter("@FunctionId", model.FunctionId), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@IsDeleted", model.IsDeleted) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.ProductRelation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ProductRelation("); strSql.Append("ClassId,ProductId"); strSql.Append(") values ("); strSql.Append("@ClassId,@ProductId"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ClassId", model.ClassId), new SqlParameter("@ProductId", model.ProductId) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.NL_Loan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[NL_Loan]("); strSql.Append("ReturnAmount,LoanDate,LoanDays,DueDate,InterestName,InterestValue,BankCardId,MemberId,CustomerId,RealName,ConsultId,IdNo,BankCode,BankName,TelNo,IsCorrect,TradePasswordExist,TradePassword,TradePasswordSecond,Flag,Mark,BorrowNo,IsDeleted,CreateId,CreateDate,EditId,EditDate,BankId,LoanInfo,LoanAmount,AmountReceived,LoanServiceCharge,LoanRate"); strSql.Append(") values ("); strSql.Append("@ReturnAmount,@LoanDate,@LoanDays,@DueDate,@InterestName,@InterestValue,@BankCardId,@MemberId,@CustomerId,@RealName,@ConsultId,@IdNo,@BankCode,@BankName,@TelNo,@IsCorrect,@TradePasswordExist,@TradePassword,@TradePasswordSecond,@Flag,@Mark,@BorrowNo,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@BankId,@LoanInfo,@LoanAmount,@AmountReceived,@LoanServiceCharge,@LoanRate"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ReturnAmount", model.ReturnAmount), new SqlParameter("@LoanDate", model.LoanDate), new SqlParameter("@LoanDays", model.LoanDays), new SqlParameter("@DueDate", model.DueDate), new SqlParameter("@InterestName", model.InterestName), new SqlParameter("@InterestValue", model.InterestValue), new SqlParameter("@BankCardId", model.BankCardId), new SqlParameter("@MemberId", model.MemberId), new SqlParameter("@CustomerId", model.CustomerId), new SqlParameter("@RealName", model.RealName), new SqlParameter("@ConsultId", model.ConsultId), new SqlParameter("@IdNo", model.IdNo), new SqlParameter("@BankCode", model.BankCode), new SqlParameter("@BankName", model.BankName), new SqlParameter("@TelNo", model.TelNo), new SqlParameter("@IsCorrect", model.IsCorrect), new SqlParameter("@TradePasswordExist", model.TradePasswordExist), new SqlParameter("@TradePassword", model.TradePassword), new SqlParameter("@TradePasswordSecond", model.TradePasswordSecond), new SqlParameter("@Flag", model.Flag), new SqlParameter("@Mark", model.Mark), new SqlParameter("@BorrowNo", model.BorrowNo), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@BankId", model.BankId), new SqlParameter("@LoanInfo", model.LoanInfo), new SqlParameter("@LoanAmount", model.LoanAmount), new SqlParameter("@AmountReceived", model.AmountReceived), new SqlParameter("@LoanServiceCharge", model.LoanServiceCharge), new SqlParameter("@LoanRate", model.LoanRate) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.NetLoanApply model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[NetLoanApply]("); strSql.Append("Sex,Mobile,RecommendationCode,Remark,Status,IsDeleted,ApplicationAmount,LoanAmount,ContractAmount,LoanTerm,CompanyId,CreateDate,LoanDate,ProductId,ProductName,IsSettled,MerchantRebate,MerchantMoney,AgentRebate,AgentMoney,HQRebate,UserId,HQMoney,NetProfit,SettlementDate,DepartmentId,SN,IdCardLibraryId,FullName,IdCardType,IdCard,SourceCompany"); strSql.Append(") values ("); strSql.Append("@Sex,@Mobile,@RecommendationCode,@Remark,@Status,@IsDeleted,@ApplicationAmount,@LoanAmount,@ContractAmount,@LoanTerm,@CompanyId,@CreateDate,@LoanDate,@ProductId,@ProductName,@IsSettled,@MerchantRebate,@MerchantMoney,@AgentRebate,@AgentMoney,@HQRebate,@UserId,@HQMoney,@NetProfit,@SettlementDate,@DepartmentId,@SN,@IdCardLibraryId,@FullName,@IdCardType,@IdCard,@SourceCompany"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Sex", model.Sex), new SqlParameter("@Mobile", model.Mobile), new SqlParameter("@RecommendationCode", model.RecommendationCode), new SqlParameter("@Remark", model.Remark), new SqlParameter("@Status", model.Status), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@ApplicationAmount", model.ApplicationAmount), new SqlParameter("@LoanAmount", model.LoanAmount), new SqlParameter("@ContractAmount", model.ContractAmount), new SqlParameter("@LoanTerm", model.LoanTerm), new SqlParameter("@CompanyId", model.CompanyId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@LoanDate", model.LoanDate), new SqlParameter("@ProductId", model.ProductId), new SqlParameter("@ProductName", model.ProductName), new SqlParameter("@IsSettled", model.IsSettled), new SqlParameter("@MerchantRebate", model.MerchantRebate), new SqlParameter("@MerchantMoney", model.MerchantMoney), new SqlParameter("@AgentRebate", model.AgentRebate), new SqlParameter("@AgentMoney", model.AgentMoney), new SqlParameter("@HQRebate", model.HQRebate), new SqlParameter("@UserId", model.UserId), new SqlParameter("@HQMoney", model.HQMoney), new SqlParameter("@NetProfit", model.NetProfit), new SqlParameter("@SettlementDate", model.SettlementDate), new SqlParameter("@DepartmentId", model.DepartmentId), new SqlParameter("@SN", model.SN), new SqlParameter("@IdCardLibraryId", model.IdCardLibraryId), new SqlParameter("@FullName", model.FullName), new SqlParameter("@IdCardType", model.IdCardType), new SqlParameter("@IdCard", model.IdCard), new SqlParameter("@SourceCompany", model.SourceCompany) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.Company model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[Company]("); strSql.Append("Logo,API,QRCode,MainBrand,MainBusiness,IsDisplay,IsRelyOnPrimaryKey,RecommendationPrefix,RecommendationLength,RecommendationCode,CompanyCategoryId,Wechat,PublicWechat,Remark,Status,OrderId,IsDeleted,CreateId,CreateDate,EditId,EditDate,CompanyName,AndroidURL,IosURL,IsAPK,DockingMode,CompanyManager,Phone,Mobile,Address,QQ,SiteUrl,DescriptionHtml,AuditConditions"); strSql.Append(") values ("); strSql.Append("@Logo,@API,@QRCode,@MainBrand,@MainBusiness,@IsDisplay,@IsRelyOnPrimaryKey,@RecommendationPrefix,@RecommendationLength,@RecommendationCode,@CompanyCategoryId,@Wechat,@PublicWechat,@Remark,@Status,@OrderId,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@CompanyName,@AndroidURL,@IosURL,@IsAPK,@DockingMode,@CompanyManager,@Phone,@Mobile,@Address,@QQ,@SiteUrl,@DescriptionHtml,@AuditConditions"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Logo", model.Logo), new SqlParameter("@API", model.API), new SqlParameter("@QRCode", model.QRCode), new SqlParameter("@MainBrand", model.MainBrand), new SqlParameter("@MainBusiness", model.MainBusiness), new SqlParameter("@IsDisplay", model.IsDisplay), new SqlParameter("@IsRelyOnPrimaryKey", model.IsRelyOnPrimaryKey), new SqlParameter("@RecommendationPrefix", model.RecommendationPrefix), new SqlParameter("@RecommendationLength", model.RecommendationLength), new SqlParameter("@RecommendationCode", model.RecommendationCode), new SqlParameter("@CompanyCategoryId", model.CompanyCategoryId), new SqlParameter("@Wechat", model.Wechat), new SqlParameter("@PublicWechat", model.PublicWechat), new SqlParameter("@Remark", model.Remark), new SqlParameter("@Status", model.Status), new SqlParameter("@OrderId", model.OrderId), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@CompanyName", model.CompanyName), new SqlParameter("@AndroidURL", model.AndroidURL), new SqlParameter("@IosURL", model.IosURL), new SqlParameter("@IsAPK", model.IsAPK), new SqlParameter("@DockingMode", model.DockingMode), new SqlParameter("@CompanyManager", model.CompanyManager), new SqlParameter("@Phone", model.Phone), new SqlParameter("@Mobile", model.Mobile), new SqlParameter("@Address", model.Address), new SqlParameter("@QQ", model.QQ), new SqlParameter("@SiteUrl", model.SiteUrl), new SqlParameter("@DescriptionHtml", model.DescriptionHtml), new SqlParameter("@AuditConditions", model.AuditConditions) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("UserType,GravatarResourceID,LastAccessIP,CompanyName,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime,RecordCreateTime,CardID,LoginName,ReginId,IsLocked,IsLogined,LoginTimes,ProvinceID,CityID,CountyID,Address,Password,UserName,Sex,Phone,QQ,Wechat,Email,DepartmentID,SId"); strSql.Append(") values ("); strSql.Append("@UserType,@GravatarResourceID,@LastAccessIP,@CompanyName,@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,@RecordUpdateTime,@RecordCreateTime,@CardID,@LoginName,@ReginId,@IsLocked,@IsLogined,@LoginTimes,@ProvinceID,@CityID,@CountyID,@Address,@Password,@UserName,@Sex,@Phone,@QQ,@Wechat,@Email,@DepartmentID,@SId"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@UserType", model.UserType), new SqlParameter("@GravatarResourceID", model.GravatarResourceID), new SqlParameter("@LastAccessIP", model.LastAccessIP), new SqlParameter("@CompanyName", model.CompanyName), new SqlParameter("@CreatUserID", model.CreatUserID), new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime), new SqlParameter("@RecordCreateTime", model.RecordCreateTime), new SqlParameter("@CardID", model.CardID), new SqlParameter("@LoginName", model.LoginName), new SqlParameter("@ReginId", model.ReginId), new SqlParameter("@IsLocked", model.IsLocked), new SqlParameter("@IsLogined", model.IsLogined), new SqlParameter("@LoginTimes", model.LoginTimes), new SqlParameter("@ProvinceID", model.ProvinceID), new SqlParameter("@CityID", model.CityID), new SqlParameter("@CountyID", model.CountyID), new SqlParameter("@Address", model.Address), new SqlParameter("@Password", model.Password), new SqlParameter("@UserName", model.UserName), new SqlParameter("@Sex", model.Sex), new SqlParameter("@Phone", model.Phone), new SqlParameter("@QQ", model.QQ), new SqlParameter("@Wechat", model.Wechat), new SqlParameter("@Email", model.Email), new SqlParameter("@DepartmentID", model.DepartmentID), new SqlParameter("@SId", model.SId) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.NL_IdentityInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[NL_IdentityInfo]("); strSql.Append("ConsultId,FullName,IDNo,MonthlyIncome,CreditHistory,HousingStatus,DrivingLicense,Face,IdentityCardScanner,DebitCard,CreditCard,ParticleLoan,BusinessPolicy,CreditCardAgeLimit,OtherLoan,SesameSeed,TaobaoAccount,Company,UnitNature,WorkingHour,Payroll,JobPosition,SocialSecurit,Fund,Degree,GraduationYear"); strSql.Append(") values ("); strSql.Append("@ConsultId,@FullName,@IDNo,@MonthlyIncome,@CreditHistory,@HousingStatus,@DrivingLicense,@Face,@IdentityCardScanner,@DebitCard,@CreditCard,@ParticleLoan,@BusinessPolicy,@CreditCardAgeLimit,@OtherLoan,@SesameSeed,@TaobaoAccount,@Company,@UnitNature,@WorkingHour,@Payroll,@JobPosition,@SocialSecurit,@Fund,@Degree,@GraduationYear"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@ConsultId", model.ConsultId), new SqlParameter("@FullName", model.FullName), new SqlParameter("@IDNo", model.IDNo), new SqlParameter("@MonthlyIncome", model.MonthlyIncome), new SqlParameter("@CreditHistory", model.CreditHistory), new SqlParameter("@HousingStatus", model.HousingStatus), new SqlParameter("@DrivingLicense", model.DrivingLicense), new SqlParameter("@Face", model.Face), new SqlParameter("@IdentityCardScanner", model.IdentityCardScanner), new SqlParameter("@DebitCard", model.DebitCard), new SqlParameter("@CreditCard", model.CreditCard), new SqlParameter("@ParticleLoan", model.ParticleLoan), new SqlParameter("@BusinessPolicy", model.BusinessPolicy), new SqlParameter("@CreditCardAgeLimit", model.CreditCardAgeLimit), new SqlParameter("@OtherLoan", model.OtherLoan), new SqlParameter("@SesameSeed", model.SesameSeed), new SqlParameter("@TaobaoAccount", model.TaobaoAccount), new SqlParameter("@Company", model.Company), new SqlParameter("@UnitNature", model.UnitNature), new SqlParameter("@WorkingHour", model.WorkingHour), new SqlParameter("@Payroll", model.Payroll), new SqlParameter("@JobPosition", model.JobPosition), new SqlParameter("@SocialSecurit", model.SocialSecurit), new SqlParameter("@Fund", model.Fund), new SqlParameter("@Degree", model.Degree), new SqlParameter("@GraduationYear", model.GraduationYear) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.DepartmentInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DepartmentInfo("); strSql.Append(@"DepartmentName , ParentID , DepartmentCode , Remark , IsReceiveBusiness , CreatedUser , RecordIsDelete , RecordCreateTime , RecordUpdateTime"); strSql.Append(") values ("); strSql.Append(@"@DepartmentName , @ParentID , @DepartmentCode , @Remark , @IsReceiveBusiness , @CreatedUser , @RecordIsDelete , @RecordCreateTime , @RecordUpdateTime"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@ParentID", model.ParentID), new SqlParameter("@DepartmentCode", model.DepartmentCode), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsReceiveBusiness", model.IsReceiveBusiness), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordCreateTime", model.RecordCreateTime), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.Machine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Machine("); strSql.Append("Remark,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime,RecordCreateTime,Latitude,Longitude,LocationAddress,AgentId,UserID,AgentName,SupervisorId,SupervisorName,SalesmanId,SalesmanName,SN,MAC,Address,Status,TeamViewerNumber,TeamViewerPwd,ActivationCode,MachineSupplierId,Platform,FlatDeviceNumber,SId"); strSql.Append(") values ("); strSql.Append("@Remark,@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,@RecordUpdateTime,@RecordCreateTime,@Latitude,@Longitude,@LocationAddress,@AgentId,@UserID,@AgentName,@SupervisorId,@SupervisorName,@SalesmanId,@SalesmanName,@SN,@MAC,@Address,@Status,@TeamViewerNumber,@TeamViewerPwd,@ActivationCode,@MachineSupplierId,@Platform,@FlatDeviceNumber,@SId"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Remark", model.Remark), new SqlParameter("@CreatUserID", model.CreatUserID), new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime), new SqlParameter("@RecordCreateTime", model.RecordCreateTime), new SqlParameter("@Latitude", model.Latitude), new SqlParameter("@Longitude", model.Longitude), new SqlParameter("@LocationAddress", model.LocationAddress), new SqlParameter("@AgentId", model.AgentId), new SqlParameter("@UserID", model.UserID), new SqlParameter("@AgentName", model.AgentName), new SqlParameter("@SupervisorId", model.SupervisorId), new SqlParameter("@SupervisorName", model.SupervisorName), new SqlParameter("@SalesmanId", model.SalesmanId), new SqlParameter("@SalesmanName", model.SalesmanName), new SqlParameter("@SN", model.SN), new SqlParameter("@MAC", model.MAC), new SqlParameter("@Address", model.Address), new SqlParameter("@Status", model.Status), new SqlParameter("@TeamViewerNumber", model.TeamViewerNumber), new SqlParameter("@TeamViewerPwd", model.TeamViewerPwd), new SqlParameter("@ActivationCode", model.ActivationCode), new SqlParameter("@MachineSupplierId", model.MachineSupplierId), new SqlParameter("@Platform", model.Platform), new SqlParameter("@FlatDeviceNumber", model.FlatDeviceNumber), new SqlParameter("@SId", model.SId) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[xbwn_Users]("); strSql.Append("UserPassword,InviteCode,RegisterIP,SmsCode,FontId,BankId,FaceNo,Success,Mark,IsDeleted,NetLoanApplyId,CreateId,CreateDate,EditId,EditDate,IMEI,MemberId,CustomerId,Token,RealName,IdNo,TelNo"); strSql.Append(") values ("); strSql.Append("@UserPassword,@InviteCode,@RegisterIP,@SmsCode,@FontId,@BankId,@FaceNo,@Success,@Mark,@IsDeleted,@NetLoanApplyId,@CreateId,@CreateDate,@EditId,@EditDate,@IMEI,@MemberId,@CustomerId,@Token,@RealName,@IdNo,@TelNo"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@UserPassword", model.UserPassword), new SqlParameter("@InviteCode", model.InviteCode), new SqlParameter("@RegisterIP", model.RegisterIP), new SqlParameter("@SmsCode", model.SmsCode), new SqlParameter("@FontId", model.FontId), new SqlParameter("@BankId", model.BankId), new SqlParameter("@FaceNo", model.FaceNo), new SqlParameter("@Success", model.Success), new SqlParameter("@Mark", model.Mark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@IMEI", model.IMEI), new SqlParameter("@MemberId", model.MemberId), new SqlParameter("@CustomerId", model.CustomerId), new SqlParameter("@Token", model.Token), new SqlParameter("@RealName", model.RealName), new SqlParameter("@IdNo", model.IdNo), new SqlParameter("@TelNo", model.TelNo) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public int GetMaxSort() { string strSql = "SELECT TOP 1 Sort FROM dbo.AdPosition WHERE RecordIsDelete=0 ORDER BY Sort desc"; SqlParameter[] parameters = null; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj) + 1); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.IdentityCardLibrary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[IdentityCardLibrary]("); strSql.Append("IssuedAt,EffectedDate,ExpiredDate,IdentityCardPhoto,IdentityCardPhotoPath,IdentityCardPhotoData,IdentityCardData,ExtendedField1,ExtendedField2,ExtendedField3,CompanyId,Remark,CreateId,CreateDate,EditId,EditDate,IsDeleted,IdentityCardNumber,FullName,Sex,Nation,BirthDay,Address"); strSql.Append(") values ("); strSql.Append("@IssuedAt,@EffectedDate,@ExpiredDate,@IdentityCardPhoto,@IdentityCardPhotoPath,@IdentityCardPhotoData,@IdentityCardData,@ExtendedField1,@ExtendedField2,@ExtendedField3,@CompanyId,@Remark,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted,@IdentityCardNumber,@FullName,@Sex,@Nation,@BirthDay,@Address"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@IssuedAt", model.IssuedAt), new SqlParameter("@EffectedDate", model.EffectedDate), new SqlParameter("@ExpiredDate", model.ExpiredDate), new SqlParameter("@IdentityCardPhoto", model.IdentityCardPhoto), new SqlParameter("@IdentityCardPhotoPath", model.IdentityCardPhotoPath), new SqlParameter("@IdentityCardPhotoData", model.IdentityCardPhotoData), new SqlParameter("@IdentityCardData", model.IdentityCardData), new SqlParameter("@ExtendedField1", model.ExtendedField1), new SqlParameter("@ExtendedField2", model.ExtendedField2), new SqlParameter("@ExtendedField3", model.ExtendedField3), new SqlParameter("@CompanyId", model.CompanyId), 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("@IsDeleted", model.IsDeleted), new SqlParameter("@IdentityCardNumber", model.IdentityCardNumber), new SqlParameter("@FullName", model.FullName), new SqlParameter("@Sex", model.Sex), new SqlParameter("@Nation", model.Nation), new SqlParameter("@BirthDay", model.BirthDay), new SqlParameter("@Address", model.Address) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderRebate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[OrderRebate]("); strSql.Append("AgentMoney,AgentRebate,HQRebate,HQMoney,NetProfit,PayStatus,IsSettled,IsCancel,SettlementDate,CreateDate,TransNo,Remark,IsDeleted,CompanyId,UserId,OrderApplyId,CompanyRebateId,OrderMoney,MerchantRebate,MerchantMoney"); strSql.Append(") values ("); strSql.Append("@AgentMoney,@AgentRebate,@HQRebate,@HQMoney,@NetProfit,@PayStatus,@IsSettled,@IsCancel,@SettlementDate,@CreateDate,@TransNo,@Remark,@IsDeleted,@CompanyId,@UserId,@OrderApplyId,@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("@CompanyId", model.CompanyId) , new SqlParameter("@UserId", model.UserId) , new SqlParameter("@OrderApplyId", model.OrderApplyId) , 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 int Add(BWJS.Model.MachineSupplier model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[MachineSupplier]("); strSql.Append("API,QRCode,MainBrand,MainBusiness,Wechat,PublicWechat,Remark,Status,IsDeleted,CreateId,SupplierName,CreateDate,EditId,EditDate,Manager,Phone,Mobile,Address,QQ,SiteUrl,Logo"); strSql.Append(") values ("); strSql.Append("@API,@QRCode,@MainBrand,@MainBusiness,@Wechat,@PublicWechat,@Remark,@Status,@IsDeleted,@CreateId,@SupplierName,@CreateDate,@EditId,@EditDate,@Manager,@Phone,@Mobile,@Address,@QQ,@SiteUrl,@Logo"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@API", model.API), new SqlParameter("@QRCode", model.QRCode), new SqlParameter("@MainBrand", model.MainBrand), new SqlParameter("@MainBusiness", model.MainBusiness), new SqlParameter("@Wechat", model.Wechat), new SqlParameter("@PublicWechat", model.PublicWechat), new SqlParameter("@Remark", model.Remark), new SqlParameter("@Status", model.Status), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@SupplierName", model.SupplierName), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@Manager", model.Manager), new SqlParameter("@Phone", model.Phone), new SqlParameter("@Mobile", model.Mobile), new SqlParameter("@Address", model.Address), new SqlParameter("@QQ", model.QQ), new SqlParameter("@SiteUrl", model.SiteUrl), new SqlParameter("@Logo", model.Logo) }; 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) { 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.CompanyRebate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[CompanyRebate]("); strSql.Append("SettlementMethod,SalesPercentage,ProfitDescription,Remark,IsDeleted,CreateId,CreateDate,EditId,EditDate,CompanyId,ProductId,CaseCode,RebateName,CompanyRebatePer,MerchantRebate,AgentRebate,HQRebate"); strSql.Append(") values ("); strSql.Append("@SettlementMethod,@SalesPercentage,@ProfitDescription,@Remark,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@CompanyId,@ProductId,@CaseCode,@RebateName,@CompanyRebatePer,@MerchantRebate,@AgentRebate,@HQRebate"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@SettlementMethod", model.SettlementMethod), new SqlParameter("@SalesPercentage", model.SalesPercentage), new SqlParameter("@ProfitDescription", model.ProfitDescription), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@CompanyId", model.CompanyId), new SqlParameter("@ProductId", model.ProductId), new SqlParameter("@CaseCode", model.CaseCode), new SqlParameter("@RebateName", model.RebateName), new SqlParameter("@CompanyRebatePer", model.CompanyRebatePer), new SqlParameter("@MerchantRebate", model.MerchantRebate), new SqlParameter("@AgentRebate", model.AgentRebate), new SqlParameter("@HQRebate", model.HQRebate) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.SysSettings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[SysSettings]("); strSql.Append("TimerSeconds,Remark,Status,IsDeleted,CreateId,CreateDate,EditId,EditDate,CompnayName,IP,DomainName,Logo,Icon,RecordNumber,TimerHours,TimerMinutes"); strSql.Append(") values ("); strSql.Append("@TimerSeconds,@Remark,@Status,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@CompnayName,@IP,@DomainName,@Logo,@Icon,@RecordNumber,@TimerHours,@TimerMinutes"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@TimerSeconds", model.TimerSeconds), new SqlParameter("@Remark", model.Remark), new SqlParameter("@Status", model.Status), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@CompnayName", model.CompnayName), new SqlParameter("@IP", model.IP), new SqlParameter("@DomainName", model.DomainName), new SqlParameter("@Logo", model.Logo), new SqlParameter("@Icon", model.Icon), new SqlParameter("@RecordNumber", model.RecordNumber), new SqlParameter("@TimerHours", model.TimerHours), new SqlParameter("@TimerMinutes", model.TimerMinutes) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM R_UsersMachine "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = BWJSHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.Function model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Function]("); strSql.Append("Status,OrderId,CreateId,CreateDate,EditId,EditDate,IsDeleted,Remark,FunctionName,FunctionCode,FunctionIcon,FunctionClass,ClassId,ParentId,ExternalLinkAddress,FunctionDir"); strSql.Append(") values ("); strSql.Append("@Status,@OrderId,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted,@Remark,@FunctionName,@FunctionCode,@FunctionIcon,@FunctionClass,@ClassId,@ParentId,@ExternalLinkAddress,@FunctionDir"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Status", model.Status), new SqlParameter("@OrderId", model.OrderId), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@Remark", model.Remark), new SqlParameter("@FunctionName", model.FunctionName), new SqlParameter("@FunctionCode", model.FunctionCode), new SqlParameter("@FunctionIcon", model.FunctionIcon), new SqlParameter("@FunctionClass", model.FunctionClass), new SqlParameter("@ClassId", model.ClassId), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@ExternalLinkAddress", model.ExternalLinkAddress), new SqlParameter("@FunctionDir", model.FunctionDir) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_UserBank model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[xbwn_UserBank]("); strSql.Append("Flag,IsDeleted,CreateId,CreateDate,EditId,EditDate,NetLoanApplyId,No,RealName,IdNo,BankCardNo,TelNo,Cash,SmsCode"); strSql.Append(") values ("); strSql.Append("@Flag,@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@NetLoanApplyId,@No,@RealName,@IdNo,@BankCardNo,@TelNo,@Cash,@SmsCode"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@Flag", model.Flag), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@No", model.No), new SqlParameter("@RealName", model.RealName), new SqlParameter("@IdNo", model.IdNo), new SqlParameter("@BankCardNo", model.BankCardNo), new SqlParameter("@TelNo", model.TelNo), new SqlParameter("@Cash", model.Cash), new SqlParameter("@SmsCode", model.SmsCode) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.UserBank model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[UserBank]("); strSql.Append("Remark,CreateId,CreateDate,EditId,EditDate,IsDeleted,UserId,BankCode,OpeningBank,CardHolder,CardNumber,BankAddress,AlipayAccount,IsDefault"); strSql.Append(") values ("); strSql.Append("@Remark,@CreateId,@CreateDate,@EditId,@EditDate,@IsDeleted,@UserId,@BankCode,@OpeningBank,@CardHolder,@CardNumber,@BankAddress,@AlipayAccount,@IsDefault"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { 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("@IsDeleted", model.IsDeleted), new SqlParameter("@UserId", model.UserId), new SqlParameter("@BankCode", model.BankCode), new SqlParameter("@OpeningBank", model.OpeningBank), new SqlParameter("@CardHolder", model.CardHolder), new SqlParameter("@CardNumber", model.CardNumber), new SqlParameter("@BankAddress", model.BankAddress), new SqlParameter("@AlipayAccount", model.AlipayAccount), new SqlParameter("@IsDefault", model.IsDefault) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBWN.Model.xbwn_Task model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[xbwn_Task]("); strSql.Append("IsDeleted,CreateId,CreateDate,EditId,EditDate,NetLoanApplyId,TelNo,ServicePwd,TaskId,State,TaskStatus,ImgStr,Mark"); strSql.Append(") values ("); strSql.Append("@IsDeleted,@CreateId,@CreateDate,@EditId,@EditDate,@NetLoanApplyId,@TelNo,@ServicePwd,@TaskId,@State,@TaskStatus,@ImgStr,@Mark"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@NetLoanApplyId", model.NetLoanApplyId), new SqlParameter("@TelNo", model.TelNo), new SqlParameter("@ServicePwd", model.ServicePwd), new SqlParameter("@TaskId", model.TaskId), new SqlParameter("@State", model.State), new SqlParameter("@TaskStatus", model.TaskStatus), new SqlParameter("@ImgStr", model.ImgStr), new SqlParameter("@Mark", model.Mark) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.OrderPayApply model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderPayApply("); strSql.Append("PayJson,CreateDate,PayDate,Remark,IsDeleted,OrderRebateId,OrderMoney,PayOrderNumber,PayStatus,PayPlatform,PayMethod,PayCode,PayText"); strSql.Append(") values ("); strSql.Append("@PayJson,@CreateDate,@PayDate,@Remark,@IsDeleted,@OrderRebateId,@OrderMoney,@PayOrderNumber,@PayStatus,@PayPlatform,@PayMethod,@PayCode,@PayText"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@PayJson", model.PayJson), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@PayDate", model.PayDate), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@OrderRebateId", model.OrderRebateId), new SqlParameter("@OrderMoney", model.OrderMoney), new SqlParameter("@PayOrderNumber", model.PayOrderNumber), new SqlParameter("@PayStatus", model.PayStatus), new SqlParameter("@PayPlatform", model.PayPlatform), new SqlParameter("@PayMethod", model.PayMethod), new SqlParameter("@PayCode", model.PayCode), new SqlParameter("@PayText", model.PayText) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }