/// <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));
}
}
