/// <summary> /// 修改银行分类 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateBankInfo(BankInfoModel model) { if (model == null) return false; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.CustNo); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = BankInfoDBHelper.UpdateBankInfo(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception) { return false; throw; } }
/// <summary> /// 插入银行分类 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertBankInfo(BankInfoModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (model == null) return false; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.CustNo); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = BankInfoDBHelper.InsertBankInfo(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception ex) { WriteSystemLog(userInfo, ex); return false; } }
/// <summary> /// 获取银行信息 /// </summary> /// <returns></returns> public static DataTable GetBankInfo(BankInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { if (model == null) return null; try { return BankInfoDBHelper.GetBankInfo(model, pageIndex, pageCount, OrderBy, ref totalCount); } catch (Exception) { return null; throw; } }
/// <summary> /// 修改银行信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateBankInfo(BankInfoModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE [officedba].[BankInfo] "); sql.AppendLine(" SET "); sql.AppendLine(" CustName = @CustName "); sql.AppendLine(" ,CustNam = @CustNam "); sql.AppendLine(" ,PYShort = @PYShort "); sql.AppendLine(" ,ContactName = @ContactName "); sql.AppendLine(" ,Tel = @Tel "); sql.AppendLine(" ,Fax = @Fax "); sql.AppendLine(" ,Mobile = @Mobile "); sql.AppendLine(" ,Addr = @Addr "); sql.AppendLine(" ,Remark = @Remark "); sql.AppendLine(" ,UsedStatus = @UsedStatus "); sql.AppendLine(" ,Creator = @Creator "); sql.AppendLine(" ,CreateDate = @CreateDate "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID =@ModifiedUserID "); sql.AppendLine(" WHERE ID=@ID and CompanyCD=@CompanyCD "); //设置参数 SqlParameter[] param = new SqlParameter[16]; int i = 0; param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[i++] = SqlHelper.GetParameter("@ID", model.ID); param[i++] = SqlHelper.GetParameter("@CustNam", model.CustNam); param[i++] = SqlHelper.GetParameter("@CustName", model.CustName); param[i++] = SqlHelper.GetParameter("@PYShort", model.PYShort); param[i++] = SqlHelper.GetParameter("@ContactName", model.ContactName); param[i++] = SqlHelper.GetParameter("@Tel", model.Tel); param[i++] = SqlHelper.GetParameter("@Fax", model.Fax); param[i++] = SqlHelper.GetParameter("@Mobile", model.Mobile); param[i++] = SqlHelper.GetParameter("@Addr", model.Addr); param[i++] = SqlHelper.GetParameter("@Remark", model.Remark); param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus); param[i++] = SqlHelper.GetParameter("@Creator", model.Creator); param[i++] = SqlHelper.GetParameter("@CreateDate", model.CreateDate); param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }
/// <summary> /// 插入银行分类 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertBankInfo(BankInfoModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO [officedba].[BankInfo]"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,BigType "); sql.AppendLine(" ,CustNo "); sql.AppendLine(" ,CustName "); sql.AppendLine(" ,CustNam "); sql.AppendLine(" ,PYShort "); sql.AppendLine(" ,ContactName "); sql.AppendLine(" ,Tel "); sql.AppendLine(" ,Fax "); sql.AppendLine(" ,Mobile "); sql.AppendLine(" ,Addr "); sql.AppendLine(" ,Remark "); sql.AppendLine(" ,UsedStatus "); sql.AppendLine(" ,Creator "); sql.AppendLine(" ,CreateDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@BigType "); sql.AppendLine(" ,@CustNo "); sql.AppendLine(" ,@CustName "); sql.AppendLine(" ,@CustNam "); sql.AppendLine(" ,@PYShort "); sql.AppendLine(" ,@ContactName "); sql.AppendLine(" ,@Tel "); sql.AppendLine(" ,@Fax "); sql.AppendLine(" ,@Mobile "); sql.AppendLine(" ,@Addr "); sql.AppendLine(" ,@Remark "); sql.AppendLine(" ,@UsedStatus "); sql.AppendLine(" ,@Creator "); sql.AppendLine(" ,@CreateDate "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID)"); //设置参数 SqlParameter[] param = new SqlParameter[17]; int i = 0; param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[i++] = SqlHelper.GetParameter("@BigType", ConstUtil.BankTypeFlag); param[i++] = SqlHelper.GetParameter("@CustNo", model.CustNo); param[i++] = SqlHelper.GetParameter("@CustName", model.CustName); param[i++] = SqlHelper.GetParameter("@CustNam", model.CustNam); param[i++] = SqlHelper.GetParameter("@PYShort", model.PYShort); param[i++] = SqlHelper.GetParameter("@ContactName",model.ContactName ); param[i++] = SqlHelper.GetParameter("@Tel", model.Tel); param[i++] = SqlHelper.GetParameter("@Fax", model.Fax); param[i++] = SqlHelper.GetParameter("@Mobile", model.Mobile); param[i++] = SqlHelper.GetParameter("@Addr", model.Addr); param[i++] = SqlHelper.GetParameter("@Remark", model.Remark); param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus); param[i++] = SqlHelper.GetParameter("@Creator", model.Creator == null ? SqlInt32.Null : SqlInt32.Parse(model.Creator.ToString())); param[i++] = SqlHelper.GetParameter("@CreateDate", model.CreateDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.CreateDate.ToString())); param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }
/// <summary> /// 获取银行信息 /// </summary> /// <returns></returns> public static DataTable GetBankInfo(BankInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT a.ID "); sql.AppendLine(" ,a.CustNo "); sql.AppendLine(" ,isnull(a.CustName,'')as CustName "); sql.AppendLine(" ,isnull(a.CustNam,'') as CustNam "); sql.AppendLine(" ,a.PYShort "); sql.AppendLine(" ,a.ContactName "); sql.AppendLine(" ,a.Tel "); sql.AppendLine(" ,a.Fax "); sql.AppendLine(" ,a.Mobile "); sql.AppendLine(" ,a.Addr "); sql.AppendLine(" ,a.Remark "); sql.AppendLine(" ,a.UsedStatus "); sql.AppendLine(" ,isnull(a.Creator,'') as Creator "); sql.AppendLine(" ,isnull(b.EmployeeName,'') as CreaterName "); sql.AppendLine(" ,isnull( CONVERT(CHAR(10), a.CreateDate, 23),'') as CreateDate "); sql.AppendLine(" ,a.ModifiedDate "); sql.AppendLine(" ,a.ModifiedUserID "); sql.AppendLine(" FROM officedba.BankInfo as a left join officedba.EmployeeInfo as b on a.Creator =b.ID where a.CompanyCD=@CompanyCD "); if (!string.IsNullOrEmpty(model.CustNo)) { sql.AppendLine(" and a.CustNo LIKE @CustNo "); } if (!string.IsNullOrEmpty(model.CustName)) { sql.AppendLine(" and a.CustName LIKE @CustName "); } if (!string.IsNullOrEmpty(model.UsedStatus)) { sql.AppendLine(" and a.UsedStatus =@UsedStatus "); } if (!string.IsNullOrEmpty(model.ContactName)) { sql.AppendLine(" and a.ContactName LIKE @ContactName "); } if (!string.IsNullOrEmpty(model.PYShort)) { sql.AppendLine(" and a.PYShort like @PYShort "); } SqlParameter[] param = new SqlParameter[6]; param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[1] = SqlHelper.GetParameter("@CustNo", "%" + model.CustNo + "%"); param[2] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus); param[3] = SqlHelper.GetParameter("@CustName", "%" + model.CustName + "%"); param[4] = SqlHelper.GetParameter("@ContactName", "%" + model.ContactName + "%"); param[5] = SqlHelper.GetParameter("@PYShort", "%" + model.PYShort + "%"); DataTable dt = SqlHelper.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, OrderBy, param, ref totalCount); return dt; }