/// <summary>
/// 新增产品包装结构
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddMeasureRel(MeasureRelEntity entity)
{
int line = 0;
MeasureRelEntity check = new MeasureRelEntity();
check.IncludeAll();
check.Where(item => item.CompanyID == this.CompanyID)
.And(item => item.ProductNum == entity.ProductNum)
.And(item => item.MeasureSource == entity.MeasureSource)
.And(item => item.MeasureTarget == entity.MeasureTarget)
;
check = this.MeasureRel.GetSingle(check);
if (check != null)
{
check.Rate = entity.Rate;
check.IncludeRate(true);
check.Where(item => item.SN == check.SN)
.And(item => item.CompanyID == this.CompanyID)
;
line = this.MeasureRel.Update(check);
}
else
{
entity.SN = entity.SN.IsEmpty() ? ConvertHelper.NewGuid() : entity.SN;
entity.CompanyID = this.CompanyID;
entity.IncludeAll();
line = this.MeasureRel.Add(entity);
}
return(line);
}
/// <summary>
/// 新增产品包装结构
/// </summary>
/// <returns></returns>
public ActionResult AddPackage()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string MeasureSource = WebUtil.GetFormValue <string>("MeasureSource");
string MeasureTarget = WebUtil.GetFormValue <string>("MeasureTarget");
double Rate = WebUtil.GetFormValue <double>("Rate", 1);
string ProductNum = WebUtil.GetFormValue <string>("ProductNum");
MeasureRelEntity entity = new MeasureRelEntity();
entity.CompanyID = CompanyID;
entity.MeasureSource = MeasureSource;
entity.MeasureTarget = MeasureTarget;
entity.Rate = Rate;
entity.ProductNum = ProductNum;
entity.SN = ConvertHelper.NewGuid();
MeasureProvider provider = new MeasureProvider(CompanyID);
int line = provider.AddMeasureRel(entity);
DataResult dataResult = new DataResult();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "新增成功";
return(Json(dataResult, JsonRequestBehavior.AllowGet));
}
public static MeasureRel_CE ToCE(MeasureRelEntity item)
{
MeasureRel_CE target = new MeasureRel_CE();
target.ID = item.ID;
target.SN = item.SN;
target.MeasureSource = item.MeasureSource;
target.MeasureTarget = item.MeasureTarget;
target.Rate = item.Rate;
return(target);
}
/// <summary>
/// 删除包装结构
/// </summary>
/// <param name="SnNum"></param>
/// <returns></returns>
public int DeleteMeasureRel(string SnNum)
{
MeasureRelEntity entity = new MeasureRelEntity();
entity.Where(async => async.SN == SnNum)
.And(item => item.CompanyID == this.CompanyID)
;
int line = this.MeasureRel.Delete(entity);
return(line);
}
/// <summary>
/// 查询某个产品的包装情况
/// </summary>
/// <param name="ProductNum"></param>
/// <returns></returns>
public List <MeasureRelEntity> GetMeasureRel(string ProductNum)
{
MeasureRelEntity entity = new MeasureRelEntity();
entity.IncludeAll();
entity.Where(item => item.CompanyID == this.CompanyID)
.And(item => item.ProductNum == ProductNum);
List <MeasureRelEntity> listResult = this.MeasureRel.GetList(entity);
if (!listResult.IsNullOrEmpty())
{
foreach (MeasureRelEntity item in listResult)
{
MeasureEntity measure = GetMeasure(item.MeasureSource);
item.SourceName = measure.IsNull() ? string.Empty : measure.MeasureName;
measure = GetMeasure(item.MeasureTarget);
item.TargetName = measure.IsNull() ? string.Empty : measure.MeasureName;
}
}
return(listResult);
}
