public WCFAddUpdateResult DelInfo(SYS_CredentialCodeRuleParam param) { this.CheckSession(); WCFAddUpdateResult ret = new WCFAddUpdateResult(); int affect = 0; try { #region 判断 if (param.RuleID == -1) { throw new WarnException("请指定要删除的记录!"); } #endregion WhereClip where = SYS_CredentialCodeRuleResult._.RuleID == param.RuleID; SYS_CredentialCodeRuleResult oldInfo = this.GetInfo(param); SYS_CredentialCodeRuleResult info = new SYS_CredentialCodeRuleResult(); info.IsDeleted = true; affect = this.Update <SYS_CredentialCodeRuleResult>(info, where); #region 设置返回值 ret.Key = affect; #endregion } catch (WarnException exp) { throw exp; } catch (System.Exception exp) { LogInfoBLL.WriteLog(this.SessionInfo, exp); throw exp; } return(ret); }
public PageList <SYS_CredentialCodeRuleResult> GetPageList(SYS_CredentialCodeRuleParam param) { ExeResult rst = new ExeResult(); rst = this.Execute("ZNLCRM.BLL.Sys.Sys_CodeRulerBLL", "GetPageList", param); PageList <SYS_CredentialCodeRuleResult> pageList = new PageList <SYS_CredentialCodeRuleResult>(); pageList = (rst == null ? new PageList <SYS_CredentialCodeRuleResult>() : rst.Result as PageList <SYS_CredentialCodeRuleResult>); return(pageList); }
void BindData(int pageIndex) { SYS_CredentialCodeRuleLogic logic = new SYS_CredentialCodeRuleLogic(this); SYS_CredentialCodeRuleParam param = new SYS_CredentialCodeRuleParam(); param = this.ConvertControlToEntity <SYS_CredentialCodeRuleParam>(this.panTop.Controls, param, null); param.PageIndex = pageIndex; param.PageSize = this.pagMain.PageSize; param.IsPage = true; PageList <SYS_CredentialCodeRuleResult> pageList = this.AsyncExecute <PageList <SYS_CredentialCodeRuleResult>, SYS_CredentialCodeRuleParam>(param, logic.GetPageList, BindDataComplete); }
public string GetBillNo(SYS_CredentialCodeRuleParam param) { string ret = ""; ExeResult rst = new ExeResult(); rst = this.Execute("ZNLCRM.BLL.Sys.Sys_CodeRulerBLL", "GetBillNo", param); if (rst != null) { ret = rst.Result.ToStringHasNull(); } return(ret); }
public SYS_CredentialCodeRuleResult GetInfo(SYS_CredentialCodeRuleParam param) { SYS_CredentialCodeRuleResult ret = new SYS_CredentialCodeRuleResult(); ExeResult rst = new ExeResult(); if (param.RuleID <= 0) { this.ShowMessage("请指定要修改的记录!"); return(ret); } rst = this.Execute("ZNLCRM.BLL.Sys.Sys_CodeRulerBLL", "GetInfo", param); ret = rst == null ? new SYS_CredentialCodeRuleResult() : rst.Result as SYS_CredentialCodeRuleResult; return(ret); }
public WCFAddUpdateResult DelInfo(SYS_CredentialCodeRuleParam param) { WCFAddUpdateResult ret = new WCFAddUpdateResult(); if (param.RuleID <= 0) { this.ShowMessage("请指定要修改的记录!"); return(ret); } ExeResult rst = new ExeResult(); rst = this.Execute("ZNLCRM.BLL.Sys.Sys_CodeRulerBLL", "DelInfo", param); ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult); return(ret); }
public SYS_CredentialCodeRuleResult GetInfo(SYS_CredentialCodeRuleParam param) { this.CheckSession(); SYS_CredentialCodeRuleResult rst = new SYS_CredentialCodeRuleResult(); #region 判断 if (param.RuleID == null) { throw new WarnException("请指定关键字GUID!"); } #endregion #region 保存实体 WhereClip where = SYS_CredentialCodeRule._.RuleID == param.RuleID; rst = this.Select <SYS_CredentialCodeRuleResult>(where); #endregion return(rst); }
public PageList <SYS_CredentialCodeRuleResult> GetPageList(SYS_CredentialCodeRuleParam param) { this.CheckSession(); PageList <SYS_CredentialCodeRuleResult> rst = new PageList <SYS_CredentialCodeRuleResult>(); WhereClip where = GetWhereClip(param); List <Field> lstField = new List <Field>() { SYS_CredentialCodeRule._.RuleID, SYS_CredentialCodeRule._.GCompanyID, SYS_CredentialCodeRule._.CredentialName , SYS_CredentialCodeRule._.IsOrderNo, SYS_CredentialCodeRule._.TableName, SYS_CredentialCodeRule._.CodeFieldName , SYS_CredentialCodeRule._.Prefix, SYS_CredentialCodeRule._.Suffix, SYS_CredentialCodeRule._.InitialValue , SYS_CredentialCodeRule._.IsContinuous, SYS_CredentialCodeRule._.Length, SYS_CredentialCodeRule._.IsManualInput , SYS_CredentialCodeRule._.ModuleID, SYS_CredentialCodeRule._.ModuleName, SYS_CredentialCodeRule._.IsDeleted }; rst = this.SelectList <SYS_CredentialCodeRuleResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(20), lstField, where, SYS_CredentialCodeRule._.TableName.Desc); return(rst); }
WhereClip GetWhereClip(SYS_CredentialCodeRuleParam param) { this.CheckSession(); WhereClip where = SYS_CredentialCodeRule._.IsDeleted == 0; if (param.TableName != null) { where = where && SYS_CredentialCodeRule._.TableName.Like("%" + param.TableName + "%"); } if (param.CredentialName != null) { where = where && SYS_CredentialCodeRule._.CredentialName.Like("%" + param.CredentialName + "%"); } if (param.ModuleName != null) { where = where && SYS_CredentialCodeRule._.ModuleName.Like("%" + param.ModuleName + "%"); } return(where); }
/// <summary> /// 获取某表单据编号 /// </summary> /// <param name="param"></param> /// <returns></returns> public string GetBillNo(SYS_CredentialCodeRuleParam param) { string tableName = param.TableName; DateTime seedDate = param.BillDate.ToDateTime(DateTime.Today); if (tableName.ToStringHasNull().Trim() == "") { throw new WarnException("请指定编号规则所属表!"); } string ret = "", ret1 = "", ret2 = ""; #region 获取编码表中的配置 string prefix = "", suffix = ""; int len = 0, initValue = 1; SYS_CredentialCodeRuleResult codeRuleInfo = this.Select <SYS_CredentialCodeRuleResult>(SYS_CredentialCodeRule._.GCompanyID.IsNull() && SYS_CredentialCodeRule._.TableName == tableName && SYS_CredentialCodeRule._.IsDeleted == 0); if (codeRuleInfo == null || codeRuleInfo.RuleID <= 0) { throw new WarnException("单据编码规格未找到!"); } prefix = codeRuleInfo.Prefix.ToStringHasNull(); suffix = codeRuleInfo.Suffix.ToStringHasNull(); len = codeRuleInfo.Length.ToInt32(); initValue = codeRuleInfo.InitialValue.ToInt32(); #endregion #region 单号日期拆分 string year = "", month = "", day = ""; year = seedDate.Year.ToString(); month = seedDate.Month.ToString().PadLeft(2, '0'); day = seedDate.Day.ToString().PadLeft(2, '0'); #endregion #region 前缀组合 string[] arrSplit = prefix.Split('&'); WhereClip whereClip = Sys_Seed._.TableName == tableName; bool existYearWhere = false, existMonthWhere = false, existDayWhere = false; foreach (string s in arrSplit) { if (s == "YYYY") { ret1 += year; existYearWhere = true; } else if (s == "YY") { ret1 += year.Substring(2); existYearWhere = true; } else if (s == "Y") { ret1 += year.Substring(3); existYearWhere = true; } else if (s == "MM") { ret1 += month; existMonthWhere = true; } else if (s == "M") { ret1 += month.Substring(1); existMonthWhere = true; } else if (s == "DD") { ret1 += day; existDayWhere = true; } else if (s == "D") { ret1 += day.Substring(1); existDayWhere = true; } else { ret1 += s; } } #endregion #region 后缀组合 arrSplit = suffix.Split('&'); foreach (string s in arrSplit) { if (s == "YYYY") { ret2 += year; existYearWhere = true; } else if (s == "YY") { ret2 += year.Substring(2); existYearWhere = true; } else if (s == "Y") { ret2 += year.Substring(3); existYearWhere = true; } else if (s == "MM") { ret2 += month; existMonthWhere = true; } else if (s == "M") { ret2 += month.Substring(1); existMonthWhere = true; } else if (s == "DD") { ret2 += day; existDayWhere = true; } else if (s == "D") { ret2 += day.Substring(1); existDayWhere = true; } else { ret2 += s; } } if (existYearWhere) { whereClip = whereClip && Sys_Seed._.Year == year.ToInt32(); } if (existMonthWhere) { whereClip = whereClip && Sys_Seed._.Month == month.ToInt32(); } if (existDayWhere) { whereClip = whereClip && Sys_Seed._.Day == day.ToInt32(); } if (len - (ret2 + ret1).Length <= 0) { throw new WarnException("单据编码规则定义的长度太短!"); } #endregion #region 插入种子记录 whereClip = Sys_Seed._.TableName == tableName && Sys_Seed._.GCompanyID == this.SessionInfo.CompanyID; Guid?seedGuid = Guid.NewGuid(); this.Insert <Sys_SeedResult>(new Sys_SeedResult() { TableName = tableName, Year = year.ToInt32(), Month = month.ToInt32(), Day = day.ToInt32(), SeedGuID = seedGuid, GCompanyID = this.SessionInfo.CompanyID }); Sys_SeedResult addRst = this.Select <Sys_SeedResult>(new List <Field>() { Sys_Seed._.SeedID } , Sys_Seed._.SeedGuID == seedGuid && Sys_Seed._.GCompanyID == this.SessionInfo.CompanyID); if (addRst.SeedID <= 0) { throw new WarnException("编码规格定义表插入记录异常!"); } #endregion whereClip = whereClip && Sys_Seed._.SeedID <= addRst.SeedID; int countNum = this.Count <Sys_Seed>(whereClip); ret = ret1 + countNum.ToString().PadLeft(len - (ret1 + ret2).Length, '0') + ret2; return(ret); }