/// <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("请选择需要删除的数据行!"); } }