private void dgvReview_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
DataGridViewColumnCollection columns = this.dgvReview.Columns;
switch (columns[e.ColumnIndex].Name)
{
case "选择部门":
if (e.ColumnIndex == 0)
{
FormQueryInfo frm = QueryInfoDialog.GetDepartment();
if (frm.ShowDialog() == DialogResult.OK)
{
dgvReview.CurrentRow.Cells[2].Value = frm.GetStringDataItem("部门名称");
dgvReview.CurrentRow.Cells[1].Value = frm.GetStringDataItem("部门代码");
}
}
break;
}
}
private void btnFindProvider_Click(object sender, EventArgs e)
{
m_formProvider = QueryInfoDialog.GetProviderInfoDialog();
if (m_formProvider.ShowDialog() == DialogResult.OK)
{
txtProvide.Tag = m_formProvider.GetStringDataItem("供应商编码");
txtProvide.Text = m_formProvider.GetStringDataItem("简称");
}
}
private void btnFindPurpose_Click(object sender, EventArgs e)
{
FormQueryInfo dialog = QueryInfoDialog.GetProductCodeStockSearchMode("");
if (dialog.ShowDialog() == DialogResult.OK)
{
txtProductCode.Text = dialog.GetStringDataItem("箱体编号");
cmbStorage.Tag = dialog.GetStringDataItem("库房ID").ToString();
cmbStorage.Text = dialog.GetStringDataItem("库房名称").ToString();
txtProductCode.Tag = Convert.ToInt32(dialog.GetStringDataItem("产品ID"));
btnStockCheck.Focus();
}
}
private void btnFindBillNo_Click(object sender, EventArgs e)
{
FormQueryInfo dialog = GetScrapBillDialogForFetchGoods();
if (dialog.ShowDialog() == DialogResult.OK)
{
txtScrapBillNo.Text = dialog.GetStringDataItem("报废单号");
IScrapGoodsServer scarpGoodsServer = ServerModule.ServerModuleFactory.GetServerModule <IScrapGoodsServer>();
IEnumerable <ServerModule.GoodsGroup> goodsGroup = scarpGoodsServer.GetGoodsByGroup(txtScrapBillNo.Text);
DataTable tempTable = ((DataTable)dataGridView1.DataSource).Clone();
foreach (GoodsGroup item in goodsGroup)
{
DataRow tempRow = tempTable.NewRow();
tempRow["图号型号"] = item.图号型号;
tempRow["物品名称"] = item.物品名称;
tempRow["规格"] = item.规格;
tempRow["账务库房"] = txtReceiving.Text;
tempRow["申请数量"] = item.数量;
tempRow["发货数量"] = 0;
tempRow["收货数量"] = 0;
tempRow["单位"] = UniversalFunction.GetGoodsInfo(item.物品ID).单位;
tempRow["备注"] = "";
tempRow["物品ID"] = item.物品ID;
tempRow["账务库房ID"] = txtReceiving.Tag;
tempTable.Rows.Add(tempRow);
}
dataGridView1.DataSource = tempTable;
}
}
private void btnFindPurpose_Click(object sender, EventArgs e)
{
FormQueryInfo dialog = QueryInfoDialog.GetProductCodeStockSearchMode("where b.产品编码 = '" + cmbProductType.Text + "'");
if (dialog.ShowDialog() == DialogResult.OK)
{
txtProductCode.Text = dialog.GetStringDataItem("箱体编号");
}
}
private void btnProvider_Click(object sender, EventArgs e)
{
FormQueryInfo formProvider = QueryInfoDialog.GetProviderInfoDialog();
if (formProvider.ShowDialog() == DialogResult.OK)
{
txtProvider.Text = formProvider.GetStringDataItem("供应商编码");
}
}
private void btnAskDepartment_Click(object sender, EventArgs e)
{
FormQueryInfo dialog = QueryInfoDialog.GetDepartment();
if (dialog.ShowDialog() == DialogResult.OK)
{
txtAskDepartment.Text = dialog.GetStringDataItem("部门名称");
}
}
private void btnFindProvider_Click(object sender, EventArgs e)
{
m_formProvider = QueryInfoDialog.GetProviderInfoDialog();
if (m_formProvider.ShowDialog() == DialogResult.OK)
{
txtProvider.Text = m_formProvider.GetStringDataItem("供应商编码");
txtBuyer.Text = m_serverProviderDuty.GetProviderPrincipal(txtProvider.Text);
}
}
private void btnFindCode_Click(object sender, EventArgs e)
{
if (m_operateMode != OperateMode.仓库核实)
{
FormQueryInfo form = QueryInfoDialog.GetPlanCostGoodsDialogSift(" and AttributeID = "
+ (int)CE_GoodsAttributeName.自制件 + " and AttributeValue = '" + bool.TrueString + "'");
if (form != null && form.ShowDialog() == DialogResult.OK)
{
txtCode.Text = form.GetDataItem("图号型号").ToString();
txtName.Text = form.GetDataItem("物品名称").ToString();
txtSpec.Text = form.GetDataItem("规格").ToString();
txtUnit.Text = form.GetStringDataItem("单位");
txtCode.Tag = form.GetDataItem("序号");
//txtProvider.Text = form.GetStringDataItem("供应商");
txtBatchNo.Text = form.GetStringDataItem("批次号");
txtProviderBatchNo.Text = form.GetStringDataItem("供方批次");
}
}
}
/// <summary>
/// 查询图号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFindCode_Click(object sender, EventArgs e)
{
if (lblBillStatus.Text != "新建单据")
{
return;
}
FormQueryInfo form = QueryInfoDialog.GetPlanCostGoodsDialogSift(" and AttributeID = "
+ (int)CE_GoodsAttributeName.自制件 + " and AttributeValue = '" + bool.TrueString + "'");
if (form != null && form.ShowDialog() == DialogResult.OK)
{
txtCode.Text = form.GetDataItem("图号型号").ToString();
txtName.Text = form.GetDataItem("物品名称").ToString();
txtSpec.Text = form.GetDataItem("规格").ToString();
txtUnit.Text = form.GetStringDataItem("单位");
txtCode.Tag = form.GetDataItem("序号");
txtMaterialType.Text = form.GetStringDataItem("物品类别");
}
}
/// <summary>
/// 查找打印规则信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFindRule_Click(object sender, EventArgs e)
{
FormQueryInfo dialog = QueryInfoDialog.GetBuildRuleForVehicleBarcode();
if (dialog.ShowDialog() == DialogResult.OK)
{
int buildRuleID = (int)dialog.GetDataItem("规则编号");
txtBuildRuleID.Text = buildRuleID.ToString();
txtProductType.Text = dialog.GetStringDataItem("产品类型名称");
m_buildRule = m_productBarcodeServer.GetBuildRule(buildRuleID);
}
}
/// <summary>
/// 从营销出库单导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoadDataFromOutboundOrder_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
FormQueryInfo dialog = QueryInfoDialog.GetOutboundBillDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
string billNo = dialog.GetStringDataItem("单据号");
if (MessageDialog.ShowEnquiryMessage("您确定要导入 " + billNo
+ " 营销出库单的信息吗？此过程需要一段时间，是否继续？") == DialogResult.No)
{
return;
}
// 营销出库单服务
ISellIn billServer = ServerModuleFactory.GetServerModule <ISellIn>();
DataTable bill = billServer.GetBill(billNo, 0);
string storageID = bill.Rows[0]["StorageID"].ToString();
DataTable list = billServer.GetList((int)bill.Rows[0]["ID"]);
if (list.Rows.Count > 0)
{
List <StorageGoods> lstGoods = new List <StorageGoods>(list.Rows.Count);
for (int i = 0; i < list.Rows.Count; i++)
{
StorageGoods goods = new StorageGoods();
goods.GoodsCode = list.Rows[i]["GoodsCode"].ToString();
goods.GoodsName = list.Rows[i]["GoodsName"].ToString();
goods.Spec = list.Rows[i]["Spec"].ToString();
goods.Provider = list.Rows[i]["Provider"].ToString();
goods.BatchNo = list.Rows[i]["BatchNo"].ToString();
goods.Quantity = (decimal)list.Rows[i]["Count"];
goods.StorageID = storageID;
lstGoods.Add(goods);
}
if (是否一次性物品.Checked && GlobalObject.GeneralFunction.IsNullOrEmpty(m_productNumber))
{
m_productNumber = cmbProductCode.Text;
}
if (!m_mbpServer.AddFromBill(BasicInfo.LoginID, Convert.ToInt32(
cmbPurpose.SelectedValue), m_productNumber, billNo, lstGoods, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
}
else
{
MessageDialog.ShowPromptMessage("操作成功");
SearchData(0);
}
}
}
}
private void btnLoadDataFromMRRB_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
FormQueryInfo dialog = QueryInfoDialog.GetMaterialRequisitionBillDialog(BasicInfo.LoginID, CE_BillTypeEnum.领料退库单);
if (dialog.ShowDialog() == DialogResult.OK)
{
string billNo = dialog.GetStringDataItem("退库单号");
if (MessageDialog.ShowEnquiryMessage("您确定要导入 " + billNo
+ " 领料单的信息吗？此过程需要一段时间，是否继续？") == DialogResult.No)
{
return;
}
IMaterialReturnedInTheDepot billServer = ServerModuleFactory.GetServerModule <IMaterialReturnedInTheDepot>();
IMaterialListReturnedInTheDepot goodsServer = ServerModuleFactory.GetServerModule <IMaterialListReturnedInTheDepot>();
View_S_MaterialReturnedInTheDepot bill = billServer.GetBillView(billNo);
List <View_S_MaterialListReturnedInTheDepot> lstMRGoods = (from r in goodsServer.GetGoods(billNo) select r).ToList();
if (lstMRGoods.Count > 0)
{
if (是否一次性物品.Checked && GlobalObject.GeneralFunction.IsNullOrEmpty(m_productNumber))
{
m_productNumber = cmbProductCode.Text;
}
List <StorageGoods> lstGoods = new List <StorageGoods>(lstMRGoods.Count);
foreach (var item in lstMRGoods)
{
StorageGoods goods = new StorageGoods();
goods.GoodsCode = item.图号型号;
goods.GoodsName = item.物品名称;
goods.Spec = item.规格;
goods.Provider = item.供应商;
goods.BatchNo = item.批次号;
goods.Quantity = -(decimal)item.退库数;
goods.StorageID = bill.库房代码;
lstGoods.Add(goods);
}
if (!m_mbpServer.AddFromBill(BasicInfo.LoginID, Convert.ToInt32(
cmbPurpose.SelectedValue), m_productNumber, billNo, lstGoods, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
}
else
{
MessageDialog.ShowPromptMessage("操作成功");
SearchData(0);
}
}
}
}
/// <summary>
/// 查找物品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFindCode_Click(object sender, EventArgs e)
{
if (txtAssociateID.Text.Trim() == "")
{
MessageBox.Show("请先选择关联单号", "提示");
return;
}
if (m_operateMode != CE_BusinessOperateMode.仓库核实)
{
FormQueryInfo form = QueryInfoDialog.GetStoreGoodsInfoDialog(txtAssociateID.Text, m_strProvider, m_strStorage);
if (form != null && form.ShowDialog() == DialogResult.OK)
{
txtCode.Text = (string)form.GetDataItem("图号型号");
txtCode.Tag = (int)form.GetDataItem("物品ID");
txtName.Text = (string)form.GetDataItem("物品名称");
txtSpec.Text = (string)form.GetDataItem("规格");
txtProvider.Text = (string)form.GetDataItem("供货单位");
txtProviderBatchNo.Text = (string)form.GetDataItem("供方批次");
txtBatchNo.Text = (string)form.GetDataItem("批次号");
txtUnit.Text = (string)form.GetDataItem("单位");
txtDepot.Text = (string)form.GetDataItem("物品类别名称");
txtDepot.Tag = (string)form.GetDataItem("物品类别");
txtShelf.Text = (string)form.GetDataItem("货架");
txtColumn.Text = (string)form.GetDataItem("列");
txtLayer.Text = (string)form.GetDataItem("层");
}
}
else if (m_operateMode != CE_BusinessOperateMode.修改)
{
FormQueryInfo form = QueryInfoDialog.GetOrderFormGoodsStockInfoDialog(txtAssociateID.Text, m_strStorage);
if (form.ShowDialog() == DialogResult.OK)
{
txtCode.Text = form.GetStringDataItem("图号型号");
txtCode.Tag = (int)form.GetDataItem("物品ID");
txtName.Text = form.GetStringDataItem("物品名称");
txtSpec.Text = form.GetStringDataItem("规格");
txtProvider.Text = form.GetStringDataItem("供应商");
txtBatchNo.Text = form.GetStringDataItem("批次号");
txtProviderBatchNo.Text = form.GetStringDataItem("供方批次");
txtUnit.Text = form.GetStringDataItem("单位");
txtDepot.Text = form.GetStringDataItem("物品类别");
txtShelf.Text = form.GetStringDataItem("货架");
txtColumn.Text = form.GetStringDataItem("列");
txtLayer.Text = form.GetStringDataItem("层");
}
}
}
