/// <summary>
/// 添加一条信息
/// </summary>
/// <param name="disposeGoods">一次性物料数据</param>
/// <param name="error">错误信息</param>
/// <returns>添加成功返回True，失败返回False</returns>
public bool InsertData(ZPX_DisposableGoods disposeGoods, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.ZPX_DisposableGoods
where a.ProductType == disposeGoods.ProductType && a.GoodsCode == disposeGoods.GoodsCode &&
a.GoodsName == disposeGoods.GoodsName && a.Spec == disposeGoods.Spec
select a;
if (result.Count() > 0)
{
error = disposeGoods.ProductType + "产品的" + disposeGoods.GoodsCode + "零件已经存在。";
return(false);
}
else
{
dataContxt.ZPX_DisposableGoods.InsertOnSubmit(disposeGoods);
dataContxt.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 批量添加物料信息
/// </summary>
/// <param name="copyProductType">复制的产品型号</param>
/// <param name="productType">复制给该产品的产品型号</param>
/// <param name="error">错误信息</param>
/// <returns>添加成功返回True，失败返回False</returns>
public bool InsertBatchData(string copyProductType, string productType, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.ZPX_DisposableGoods
where a.ProductType == productType
select a;
if (result.Count() > 0)
{
dataContxt.ZPX_DisposableGoods.DeleteAllOnSubmit(result);
}
var resultCopy = from a in dataContxt.ZPX_DisposableGoods
where a.ProductType == copyProductType
select a;
if (resultCopy.Count() > 0)
{
foreach (ZPX_DisposableGoods item in resultCopy)
{
ZPX_DisposableGoods dispozeGoods = new ZPX_DisposableGoods();
dispozeGoods.ProductType = productType;
dispozeGoods.Count = item.Count;
dispozeGoods.Date = ServerTime.Time;
dispozeGoods.GoodsCode = item.GoodsCode;
dispozeGoods.GoodsName = item.GoodsName;
dispozeGoods.Spec = item.Spec;
dispozeGoods.UserCode = BasicInfo.LoginID;
dataContxt.ZPX_DisposableGoods.InsertOnSubmit(dispozeGoods);
}
}
else
{
error = "复制的产品中没有物料信息！";
return(false);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (cmbProductType.Text == "")
{
MessageDialog.ShowPromptMessage("请选择产品型号！");
return;
}
if (txtGoodsCode.Text.Trim() == "" && txtGoodsName.Text.Trim() == "")
{
MessageDialog.ShowPromptMessage("请选择物品名称！");
return;
}
if (numCount.Value == 0)
{
MessageDialog.ShowPromptMessage("请填写数量！");
return;
}
ZPX_DisposableGoods dis = new ZPX_DisposableGoods();
dis.Count = Convert.ToInt32(numCount.Value);
dis.Date = ServerTime.Time;
dis.GoodsCode = txtGoodsCode.Text;
dis.GoodsName = txtGoodsName.Text;
dis.ProductType = cmbProductType.Text;
dis.Spec = txtSpec.Text;
dis.UserCode = BasicInfo.LoginID;
if (!m_disposeGoodsServer.InsertData(dis, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
}
else
{
MessageDialog.ShowPromptMessage("添加成功！");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
if (MessageDialog.ShowEnquiryMessage("您确定删除选中的数据吗？") == DialogResult.Yes)
{
string goodsInfo = "";
for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
ZPX_DisposableGoods dis = new ZPX_DisposableGoods();
dis.GoodsCode = dataGridView1.SelectedRows[i].Cells["图号型号"].Value.ToString();
dis.GoodsName = dataGridView1.SelectedRows[i].Cells["物品名称"].Value.ToString();
dis.ProductType = dataGridView1.SelectedRows[i].Cells["产品型号"].Value.ToString();
dis.Spec = dataGridView1.SelectedRows[i].Cells["规格"].Value.ToString();
if (!m_disposeGoodsServer.DeleteData(dis, out m_error))
{
goodsInfo += "产品型号为" + dataGridView1.SelectedRows[i].Cells["产品型号"].Value.ToString() + "；物品名称：" + dataGridView1.SelectedRows[i].Cells["物品名称"].Value.ToString() + "；图号型号：" + dataGridView1.SelectedRows[i].Cells["图号型号"].Value.ToString() + "；规格：" + dataGridView1.SelectedRows[i].Cells["规格"].Value.ToString() + "\r\n";
}
}
if (goodsInfo == "")
{
MessageDialog.ShowPromptMessage("删除成功！");
RefreshGridView();
}
else
{
MessageDialog.ShowPromptMessage("删除失败！\r\n" + goodsInfo);
}
}
}
else
{
MessageDialog.ShowPromptMessage("请选择需要删除的数据行！");
}
}
