/// <summary> /// 获得凭证编号 /// </summary> /// <param name="pzlx"></param> /// <returns></returns> public static string GetZWPZBH(ZWPZLX pzlx) { using (CtxRuntime ctxBase = new CtxRuntime()) { string year = LoginInfo.LoginDate.Year.ToString(); string month = LoginInfo.LoginDate.Month.ToString("00"); ZWPZBH zWPZBH = (from t in ctxBase.ZWPZBH where t.ZWPZBH_KJND == year where t.ZWPZBH_KJQJ == month where t.ZWPZBH_PZZ == pzlx.ZWPZLX_PZZ select t).SingleOrDefault(); if (zWPZBH != null) { string result = $"{pzlx.ZWPZLX_PZZ}{zWPZBH.ZWPZBH_PZBH}"; zWPZBH.ZWPZBH_PZBH = (int.Parse(zWPZBH.ZWPZBH_PZBH) + 1).ToString("0000"); zWPZBH.ZWPZBH_PZRQ = DHelper.ConverToDateString(LoginInfo.LoginDate); try { ctxBase.SaveChanges(); return(result); } catch { return(null); } } return(null); } }
/// <summary> /// 获得主键编码 /// </summary> /// <param name="nmbh"></param> /// <param name="current"></param> /// <returns></returns> public static string GetNBBM(string nmbh, bool current) { string text2; using (CtxRuntime ctxBase = new CtxRuntime()) { LSNBBM bm = ctxBase.LSNBBM.Single((LSNBBM t) => t.LSNBBM_NMBH == nmbh); if (!current) { text2 = (bm.LSNBBM_DQNM = (int.Parse(bm.LSNBBM_DQNM) + 1).ToString()); } else { text2 = bm.LSNBBM_DQNM; bm.LSNBBM_DQNM = (int.Parse(text2) + 1).ToString(); } ctxBase.SaveChanges(); } return(text2); }