//获取收发类别（收）的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);
}
}
