/// <summary>
/// 更新货品信息
/// </summary>
/// <param name="info"> 货品信息实体 </param>
/// <returns> 更新成功返回true </returns>
public bool UpdateInfo(MMS_MaterialInfo info)
{
var query = from item in dc.MMS_MaterialInfo
where item.Material_ID == info.Material_ID
select item;
BatchEvaluate.Eval(info, query.First());
dc.SubmitChanges();
return(true);
}
private void ModelToDetailTextBox(TPurchaseIndentDetail tinfo)
{
//调用业务层方法取货品信息实体
MMS_MaterialInfo Material = MaterialInfoService.Instance.GetProductInfoByCode(tinfo.DetDetail.ProductCode);
MMS_PurchaseIndentDetail detail = tinfo.DetDetail;
txtProductCode.Text = detail.ProductCode; //货品代码
txtShortName.Text = Material.Material_Name; //货品简称
txtSpecs.Text = Material.Material_Specification; //规格
ddlUnit.Text = Material.Material_Unit; //计量单位
txtVendor.Text = Material.Material_Supplier; //供应商
txtQuantity.Text = detail.Quantity.ToString(); //数量
}
/// <summary>
/// 插入货品信息
/// </summary>
/// <param name="info"> 货品信息实体 </param>
/// <returns> </returns>
public int InsertInfo(MMS_MaterialInfo info)
{
string msg = dao.ValidateRepeat(info);
if (msg == "")
{
return(dao.InsertInfo(info));
}
else
{
throw new Exception(msg);
}
}
/// <summary>
/// 选择货品
/// </summary>
/// <param name="sender"> </param>
/// <param name="e"> </param>
protected void btnSelectProduct_Click(object sender, EventArgs e)
{
txtProductCode.Text = hidProductCode.Value;
txtShortName.Text = hidProductName.Value;
//调用业务层的方法取货品信息实体
MMS_MaterialInfo Material = MaterialInfoService.Instance.GetProductInfoByCode(txtProductCode.Text);
if (Material != null)
{
txtSpecs.Text = Material.Material_Specification; //规格
ddlUnit.SelectedItem.Text = Material.Material_Unit; //计量单位
txtVendor.Text = Material.Material_Supplier; //厂商
}
}
/// <summary>
/// 验证记录中是否有重复值
/// </summary>
/// <param name="info"> 实体 </param>
/// <returns> 如果不重复返回"" </returns>
public string ValidateRepeat(MMS_MaterialInfo info)
{
//查询货品信息表中货品代码与新添加或修改的货品代码相同且主键不同(新添加的货品ID为空)的记录数
int cnt1 = dc.MMS_MaterialInfo.Where(itm => itm.Material_Name == info.Material_Name && itm.Material_ID != info.Material_ID).Count();
if (cnt1 > 0) //如果记录数大于0表示货品代码重复
{
return("代码重复");
}
//查询货品信息表中货品简称与新添加或修改的货品简称相同且主键不同的记录数
int cnt2 = dc.MMS_MaterialInfo.Where(itm => itm.Material_CommonlyName == info.Material_CommonlyName && itm.Material_ID != info.Material_ID).Count();
if (cnt2 > 0) //如果记录数大于0表示货品简称重复
{
return("简称重复");
}
return("");
}
/// <summary>
/// 选择货品
/// </summary>
/// <param name="sender"> </param>
/// <param name="e"> </param>
protected void btnSelectProduct_Click(object sender, EventArgs e)
{
BindDict("Unit", ddlUnit); //将计量单位下拉框绑定字典
txtProductCode.Text = hidProductCode.Value;
txtShortName.Text = hidProductName.Value;
MMS_MaterialInfo prod = MaterialInfoService.Instance.GetProductInfoByCode(txtProductCode.Text);
//调用业务层的方法取货品信息实体
// MMS_ProductInfo prod = ProductInfoService.Instance.GetProductInfoByCode(txtProductCode.Text);
if (prod != null)
{
txtSpecs.Text = prod.Material_Specification; //规格
ddlUnit.SelectedItem.Text = prod.Material_Unit; //计量单位
txtProvider.Text = prod.Material_Supplier; //生产厂商
//单价
//txtPrice.Text =
// PurchaseService.Instance.GetLastPurchasePrice(hidProvider.Value, txtProductCode.Text).ToString();
}
}
private void ModelToDetailTextBox(TPurchaseDetail tinfo)
{
BindDict("Unit", ddlUnit); //将计量单位下拉框绑定字典
//调用业务层方法取货品信息实体
MMS_MaterialInfo product = MaterialInfoService.Instance.GetProductInfoByCode(tinfo.DetDetail.ProductCode);
MMS_PurchaseDetail detail = tinfo.DetDetail;
txtProductCode.Text = detail.ProductCode; //货品代码
txtShortName.Text = product.Material_Name; //货品简称
txtSpecs.Text = product.Material_Specification; //规格
txtLot.Text = detail.Lot.ToString(); //批号
txtValidDate.Text = detail.ValidDate.ToString(); //有效期
txtProvider.Text = product.Material_Supplier.ToString(); //生产厂同
ddlUnit.Text = product.Material_Unit; //计量单位
txtQuantity.Text = detail.Quantity.ToString(); //数量
txtPrice.Text = detail.Price.ToString(); //单价
txtSeldPrice.Text = detail.SeldPrice.ToString();
txtAmount.Text = (detail.Quantity * detail.Price).ToString(); //金额=数量*单价
}
/// <summary>
/// 选择货品
/// </summary>
/// <param name="sender"> </param>
/// <param name="e"> </param>
protected void btnSelectProduct_Click(object sender, EventArgs e)
{
txtProductCode.Text = hidProductCode.Value;
txtShortName.Text = hidProductName.Value;
txtPrice.Text = hidPrice.Value;
txtUseQuantity.Text = hidUseQuantity.Value;
//调用业务层的方法取货品信息实体
MMS_MaterialInfo Material = MaterialInfoService.Instance.GetProductInfoByCode(txtProductCode.Text);
// MMS_ProductInfo prod = ProductInfoService.Instance.GetProductInfoByCode(txtProductCode.Text);
if (Material != null)
{
txtSpecs.Text = Material.Material_Specification; //规格
ddlUnit.SelectedItem.Text = Material.Material_Unit; //计量单位
txtVendor.Text = Material.Material_Supplier; //厂商
//单价
//txtPrice.Text =
// PurchasePlanService.Instance.GetLasTPurchasePlanPrice(hidProvider.Value, txtProductCode.Text).ToString();
}
}
/// <summary>
/// 插入货品信息
/// </summary>
/// <param name="info"> 货品信息实体 </param>
/// <returns> 返回插入记录的自增主键值 </returns>
public int InsertInfo(MMS_MaterialInfo info)
{
dc.MMS_MaterialInfo.InsertOnSubmit(info);
dc.SubmitChanges();
return(info.Material_ID);
}
/// <summary>
/// 更新货品信息
/// </summary>
/// <param name="info"> 货品信息实体 </param>
/// <returns> </returns>
public bool UpdateInfo(MMS_MaterialInfo info)
{
return(dao.UpdateInfo(info));
}
