//获取收发类别(收)的code public static string GetInCategory(string categoryName) { string ret = ""; using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.DataDict.SingleOrDefault(o => (o.Category == "InCategory") && (o.Name == categoryName)); } return(ret); }
//获取收发类别(发)的code public static string GetOutCategory(string categoryName) { string ret = ""; using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.DataDict.SingleOrDefault(o => (o.Category == "OutCategory") && (o.Name == categoryName)); if (tmp != null) { ret = tmp.Code; } return(ret); } }
//跟据商品编码查询商品表是否已存在,若不存在,则返回空串 public static string ParsingCargoCode(string cargoCode) { using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.Cargos.SingleOrDefault(o => o.CargoCode == cargoCode); if (tmp == null) { return(""); } else { return(tmp.CargoCode); } } }
/// <summary> /// 由仓库名称找到仓库编码,若不存在,则返回空串 /// </summary> /// <param name="whName">仓库名称</param> /// <returns>仓库编码</returns> public static string ParsingWarehouse(string whName) { using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.WareHouse.SingleOrDefault(o => o.WHName == whName); if (tmp == null) { return(""); } else { return(tmp.WHCode); } } }
/// <summary> /// 获取标签间隔鸣音次数 /// </summary> /// <returns></returns> public static int GetTagIntervalSoundCount() { int ret = 50;// string categoryName = "层标间隔鸣音次数"; using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.DataDict.SingleOrDefault(o => (o.Category == "TagLightSound") && (o.Name == categoryName)); if (tmp != null) { if (int.TryParse(tmp.Code, out ret) == false) { ret = 50; } } return(ret); } }
/// <summary> /// 获取撤销单最大的序列号(末四位自增的序号) /// </summary> /// <returns></returns> private int GetMaxStockCancleKey(string typeInOrOut) { int ret = 0; using (var edm = new Gold.DAL.GoldEntities()) { if (typeInOrOut == "In") { var tmp = edm.StockCancel .Select("it.SCCode") .Where("it.SCCode like 'XR" + DateTime.Now.ToString("yyMM") + "%'") .OrderBy("it.SCCode desc") .FirstOrDefault(); if (tmp != null) { string tmp2 = tmp[0].ToString().Substring(6); if (false == int.TryParse(tmp2, out ret)) { ret = 1000; } } } else if (typeInOrOut == "Out") { var tmp = edm.StockCancel .Select("it.SCCode") .Where("it.SCCode like 'XC" + DateTime.Now.ToString("yyMM") + "%'") .OrderBy("it.SCCode desc") .FirstOrDefault(); if (tmp != null) { string tmp2 = tmp[0].ToString().Substring(6); if (false == int.TryParse(tmp2, out ret)) { ret = 1000; } } } return(ret); } }
public static string GetStockOutCode(string fromBillNo) { string ret = ""; using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.StockOut .Select("it.SOCode, it.FromBillNo") .Where("it.FromBillNo == '" + fromBillNo + "' ") .FirstOrDefault(); if (tmp != null) { ret = tmp[0].ToString(); } else { ret = KeyGenerator.Instance.GetStockOutKey(); } return(ret); } }
/// <summary> /// 获取盘点计划单最大的序列号(末四位自增的序号) /// </summary> /// <returns></returns> private int GetMaxStockCountPlanKey() { int ret = 0; using (var edm = new Gold.DAL.GoldEntities()) { var tmp = edm.StockCountingPlan .Select("it.SCPCode") .Where("it.SCPCode like 'PD" + DateTime.Now.ToString("yyMM") + "%'") .OrderBy("it.SCPCode desc") .FirstOrDefault(); if (tmp != null) { string tmp2 = tmp[0].ToString().Substring(6); if (false == int.TryParse(tmp2, out ret)) { ret = 1000; } } return(ret); } }