/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" * "); strSql.Append(" FROM CompanyRelation "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(BWJSHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 获得前几行数据 /// </summary> public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" * "); strSql.Append(" FROM dbo.[NL_ConsultStatusChangeLog] "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return(BWJSHelperSQL.Query(strSql.ToString())); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.NL_Contacts model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[NL_Contacts] set "); strSql.Append(" EditId = @EditId , "); strSql.Append(" EditDate = @EditDate , "); strSql.Append(" ConsultId = @ConsultId , "); strSql.Append(" FullName = @FullName , "); strSql.Append(" Mobile = @Mobile , "); strSql.Append(" RelationId = @RelationId , "); strSql.Append(" Depth = @Depth , "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" CreateId = @CreateId , "); strSql.Append(" CreateDate = @CreateDate "); strSql.Append(" where ContactId=@ContactId "); SqlParameter[] parameters = { new SqlParameter("@ContactId", model.ContactId), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate), new SqlParameter("@ConsultId", model.ConsultId), new SqlParameter("@FullName", model.FullName), new SqlParameter("@Mobile", model.Mobile), new SqlParameter("@RelationId", model.RelationId), new SqlParameter("@Depth", model.Depth), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@CreateId", model.CreateId), new SqlParameter("@CreateDate", model.CreateDate) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取广告 /// </summary> /// <returns></returns> public DataTable GetReleaseExpandL(string where) { try { StringBuilder tablesql = new StringBuilder(); tablesql.Append(@"select a.*,b.[AdPositionID] PositionId,b.[Name] PositionName ,b.Sort from [BWJSDB].[dbo].[AdRelease] a left join [BWJSDB].[dbo].[AdPosition] b on b.[AdReleaseID]=a.[AdReleaseID] AND b.RecordIsDelete=0 "); if (!string.IsNullOrEmpty(where)) { tablesql.AppendFormat(" where {0} ", where); } return(BWJSHelperSQL.ReturnDataTable(tablesql.ToString())); } catch { } return(null); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.AdRelease model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AdRelease set "); strSql.Append(" AdReleaseName = @AdReleaseName , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" BeginTime = @BeginTime , "); strSql.Append(" EndTime = @EndTime , "); strSql.Append(" ResourceID = @ResourceID , "); strSql.Append(" CreatUserID = @CreatUserID , "); strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , "); strSql.Append(" RecordIsDelete = @RecordIsDelete , "); strSql.Append(" RecordUpdateTime = @RecordUpdateTime , "); strSql.Append(" RecordCreateTime = @RecordCreateTime "); strSql.Append(" where AdReleaseID=@AdReleaseID "); SqlParameter[] parameters = { new SqlParameter("@AdReleaseID", model.AdReleaseID), new SqlParameter("@AdReleaseName", model.AdReleaseName), new SqlParameter("@Remark", model.Remark), new SqlParameter("@BeginTime", model.BeginTime), new SqlParameter("@EndTime", model.EndTime), new SqlParameter("@ResourceID", model.ResourceID), 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) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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 bool Update(Resource model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Resource set "); strSql.Append(" ResourceName = @ResourceName , "); strSql.Append(" FileName = @FileName , "); strSql.Append(" VirtualPath = @VirtualPath , "); strSql.Append(" FilePath = @FilePath , "); strSql.Append(" FileSuffix = @FileSuffix , "); strSql.Append(" MD5 = @MD5 , "); strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , "); strSql.Append(" RecordUpdateTime = GetDate() "); strSql.Append(" where ResourceID=@ResourceID and RecordUpdateTime = @RecordUpdateTime"); SqlParameter[] parameters = { new SqlParameter("@ResourceID", model.ResourceID), 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("@MD5", model.MD5), new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataSet GetAssignCheck(int RoleId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from RoleFunction "); strSql.Append(" where RoleId=@RoleId and IsDeleted=0"); SqlParameter[] parameters = { new SqlParameter("@RoleId", SqlDbType.Int, 4) }; parameters[0].Value = RoleId; BWJS.Model.RoleFunction model = new BWJS.Model.RoleFunction(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); return(ds); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Role] set "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" RoleName = @RoleName , "); strSql.Append(" RoleType = @RoleType , "); strSql.Append(" RoleStatus = @RoleStatus , "); strSql.Append(" ParentId = @ParentId , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" EditId = @EditId , "); strSql.Append(" EditDate = @EditDate, "); strSql.Append(" IsManager = @IsManager "); strSql.Append(" where RoleId=@RoleId "); SqlParameter[] parameters = { new SqlParameter("@RoleId", model.RoleId), new SqlParameter("@IsDeleted", model.IsDeleted), new SqlParameter("@RoleName", model.RoleName), new SqlParameter("@RoleType", model.RoleType), new SqlParameter("@RoleStatus", model.RoleStatus), new SqlParameter("@Remark", model.Remark), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@IsManager", model.IsManager), new SqlParameter("@EditId", model.EditId), new SqlParameter("@EditDate", model.EditDate) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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 bool Update(BWJS.Model.SysConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[SysConfig] set "); strSql.Append(" RecordCreateTime = @RecordCreateTime , "); strSql.Append(" KeyType = @KeyType , "); strSql.Append(" KeyName = @KeyName , "); strSql.Append(" KeyVal = @KeyVal , "); strSql.Append(" Description = @Description , "); strSql.Append(" CreatUserID = @CreatUserID , "); strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , "); strSql.Append(" RecordIsDelete = @RecordIsDelete , "); strSql.Append(" RecordUpdateTime = @RecordUpdateTime "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", model.Id), 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) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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> /// <returns></returns> public Users AdminLogin(string AdminName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Users where RecordIsDelete=0 and LoginName=@LoginName"); SqlParameter[] parameters = { new SqlParameter("@LoginName", AdminName) }; Users model = new Users(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public bool ChangeSort(int AdPositionID, int Sort) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE AdPosition SET Sort=@Sort,RecordUpdateTime=GETDATE(),RecordUpdateUserID=1 WHERE AdPositionID=@AdPositionID AND RecordIsDelete=0 "); SqlParameter[] parameters = { new SqlParameter("@Sort", Sort), new SqlParameter("@AdPositionID", AdPositionID) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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.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(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 bool Update(XBWN.Model.xbwn_Picture model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.[xbwn_Picture] set "); strSql.Append(" NetLoanApplyId = @NetLoanApplyId , "); strSql.Append(" Base64Code = @Base64Code , "); strSql.Append(" ImgId = @ImgId , "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" CreateId = @CreateId , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" EditId = @EditId , "); strSql.Append(" EditDate = @EditDate "); strSql.Append(" where PictiureId=@PictiureId "); SqlParameter[] parameters = { new SqlParameter("@PictiureId", model.PictiureId), 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) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool UpdateDelete(int AdPositionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update AdPosition set RecordIsDelete=1 "); strSql.Append(" where AdPositionID=@AdPositionID"); SqlParameter[] parameters = { new SqlParameter("@AdPositionID", AdPositionID) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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> /// 根据Key的名称 查询Key值 /// </summary> /// <param name="Keyname"></param> /// <returns></returns> public string GetValue(string Keyname) { StringBuilder strSql = new StringBuilder(); strSql.Append("select KeyVal from SysConfig "); strSql.Append(" where KeyName=@keyname "); SqlParameter[] parameters = { new SqlParameter("@keyname", SqlDbType.NVarChar) }; parameters[0].Value = Keyname; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { return(""); } else { return(obj.ToString()); } }
/// <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)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.DepartmentInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [DepartmentInfo] set "); strSql.Append(" DepartmentName = @DepartmentName , "); strSql.Append(" ParentID = @ParentID , "); strSql.Append(" DepartmentCode = @DepartmentCode , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" UpdateUser = @UpdateUser , "); strSql.Append(" IsReceiveBusiness = @IsReceiveBusiness , "); strSql.Append(" RecordIsDelete = @RecordIsDelete , "); strSql.Append(" RecordUpdateTime = @RecordUpdateTime "); strSql.Append(" where DepartmentID=@DepartmentID "); SqlParameter[] parameters = { new SqlParameter("@DepartmentID", model.DepartmentID), new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@ParentID", model.ParentID), new SqlParameter("@DepartmentCode", model.DepartmentCode), new SqlParameter("@Remark", model.Remark), new SqlParameter("@UpdateUser", model.UpdateUser), new SqlParameter("@IsReceiveBusiness", model.IsReceiveBusiness), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool UpdateDelete(int RoleId) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update [Role] set IsDeleted=1 where RoleId=@RoleId; UPDATE UserRole SET IsDeleted=1 WHERE RoleId=@RoleId AND IsDeleted=0"); SqlParameter[] parameters = { new SqlParameter("@RoleId", RoleId) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.RoleFunction model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RoleFunction set "); strSql.Append(" RoleFunctionId = @RoleFunctionId , "); strSql.Append(" RoleId = @RoleId , "); strSql.Append(" FunctionId = @FunctionId , "); strSql.Append(" CreateId = @CreateId , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" EditId = @EditId , "); strSql.Append(" EditDate = @EditDate , "); strSql.Append(" IsDeleted = @IsDeleted "); strSql.Append(" where RoleFunctionId=@RoleFunctionId "); 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) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改默认银行卡 /// </summary> public bool SetDefault(int userBankId, int userId, int editId) { List <String> tsql = new List <String>(); StringBuilder tableSql = new StringBuilder(); tableSql.AppendFormat("update UserBank set IsDefault=0,EditId={0},EditDate='{1}' where UserId={2}", editId, DateTime.Now, userId); tsql.Add(tableSql.ToString()); tableSql = new StringBuilder(); tableSql.AppendFormat("update UserBank set IsDefault=1,EditId={0},EditDate='{1}' where UserBankId={2}", editId, DateTime.Now, userBankId); tsql.Add(tableSql.ToString()); int rows = BWJSHelperSQL.ExecuteSqlTran(tsql); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public string GetSignName(int SId) { string resultStr = string.Empty; StringBuilder strSql = new StringBuilder(); strSql.Append("select SignName "); strSql.Append(" from SupplierInfo "); strSql.Append(" where SId=@SId"); SqlParameter[] parameters = { new SqlParameter("@SId", SqlDbType.Int, 4) }; parameters[0].Value = SId; SupplierInfo model = new SupplierInfo(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { resultStr = ds.Tables[0].Rows[0]["SignName"].ToString(); } return(resultStr); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.NL_ProfessionInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.[NL_ProfessionInfo]("); strSql.Append("ConsultId,FullName,Age,MonthlyIncome,Company,UnitNature,WorkingHour,Payroll,JobPosition,SocialSecurit,Fund,Degree,GraduationYear"); strSql.Append(") values ("); strSql.Append("@ConsultId,@FullName,@Age,@MonthlyIncome,@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("@Age", model.Age), new SqlParameter("@MonthlyIncome", model.MonthlyIncome), 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 bool Update(R_UsersMachine model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update R_UsersMachine set "); strSql.Append("UserID=@UserID,"); strSql.Append("MachineID=@MachineID,"); strSql.Append("RecordIsDelete=@RecordIsDelete,"); strSql.Append("RecordCreateTime=@RecordCreateTime,"); strSql.Append("RecordUpdateTime@=RecordUpdateTime"); strSql.Append(" where RUMID=@RUMID"); 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), new SqlParameter("@RUMID", SqlDbType.Int, 4) }; 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; parameters[5].Value = model.RUMID; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BWJS.Model.OrderRebate GetModel(int OrderRebateId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderRebateId, AgentMoney, AgentRebate, HQRebate, HQMoney, NetProfit, PayStatus, IsSettled, IsCancel, SettlementDate, CreateDate, TransNo, Remark, IsDeleted, CompanyId, UserId, OrderApplyId, CompanyRebateId, OrderMoney, MerchantRebate, MerchantMoney "); strSql.Append(" from dbo.[OrderRebate] "); strSql.Append(" where OrderRebateId=@OrderRebateId"); SqlParameter[] parameters = { new SqlParameter("@OrderRebateId", SqlDbType.Int,4) }; parameters[0].Value = OrderRebateId; BWJS.Model.OrderRebate model = new BWJS.Model.OrderRebate(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }