/// <summary>
/// 物料BOM编辑加载窗口
/// </summary>
/// <param name="MaterialFatherGuid"></param>
public void EditBom(string MaterialFatherGuid)
{
//选择的品名填充
if (MaterialFatherGuid != "")
{
//得到料件的信息
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(MaterialFatherGuid);
//填充数据
txtMaterialID.Tag = material.MaterialGuID;
txtMaterialID.Text = material.MaterialID;
txtMaterialName.Text = material.MaterialName;
txtUnit.Text = base.GetBasicDataNameByID(material.Unit);
txtSpec.Text = base.GetBasicDataNameByID(material.Spec);
//得到bom主表的备注信息
txtRemark.Text = MaterialBOMManage.GetBOMRemarkByMaterialGuid(MaterialFatherGuid);
}
//载入子件列表
LoadMaterialChildData();
//母件子件按树型显示
LoadBomTree();
treeView1.ExpandAll();
this.ShowDialog();
}
private void btnAddDetail_Click(object sender, EventArgs e)
{
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial();
frmSelectMaterial.ShowDialog();
if (frmSelectMaterial.Tag != null)
{
//取出选择的料件Guid
List <string> lstGuid = frmSelectMaterial.Tag as List <string>;
//选择的品名填充
if (lstGuid.Count > 0)
{
//得到料件的信息
for (int i = 0; i < lstGuid.Count; i++)
{
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(lstGuid[i]);
//填充数据
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue(gridMaterialGuID, material.MaterialGuID);
gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialID);
gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName);
gridView1.SetFocusedRowCellValue(gridUnit, base.GetBasicDataNameByID(material.Unit));
gridView1.SetFocusedRowCellValue(gridSpec, base.GetBasicDataNameByID(material.Spec));
gridView1.SetFocusedRowCellValue(gridPrice, material.Price.ToString("g0"));
}
}
}
}
private void btnSelectMaterialGuid_Click(object sender, EventArgs e)
{
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(1);
frmSelectMaterial.ShowDialog();
if (frmSelectMaterial.Tag != null)
{
//取出选择的料件Guid
List <string> lstGuid = frmSelectMaterial.Tag as List <string>;
//选择的品名填充
if (lstGuid.Count > 0)
{
//得到料件的信息
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(lstGuid[0]);
//填充数据
txtMaterialGuid.Text = material.MaterialID;
txtMaterialGuid.Tag = material.MaterialGuID;
txtMaterialName.Text = material.MaterialName;
}
}
}
private void btnAddDetail_Click(object sender, EventArgs e)
{
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial();
frmSelectMaterial.Tag = "";
frmSelectMaterial.ShowDialog();
//选择的料件填充
if (frmSelectMaterial.Tag.ToString() != "")
{
//得到选择的料件guid，然后得到
Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString());
//填充数据
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue(gridMaterialGuid, material.MaterialGuid);
gridView1.SetFocusedRowCellValue(gridMaterialId, material.MaterialId);
gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName);
gridView1.SetFocusedRowCellValue(gridClassName, material.ClassId);
gridView1.SetFocusedRowCellValue(gridBarNo, material.BarNo);
gridView1.SetFocusedRowCellValue(gridSpec, material.Spec);
gridView1.SetFocusedRowCellValue(gridUnit, material.Unit);
gridView1.SetFocusedRowCellValue(gridRemark, material.Remark);
}
}
public void LoadData(string strMaterialGuid)
{
MaterialManage MaterialManage = new MaterialManage();
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(strMaterialGuid);
txtMaterialID.Text = material.MaterialID;
txtMaterialName.Text = material.MaterialName;
txtSpec.Text = base.GetBasicDataNameByID(material.Spec);
txtUnit.Text = base.GetBasicDataNameByID(material.Unit);
DataTable dtl = MaterialManage.sp_GetStorageSumData(strMaterialGuid);
gridControl1.DataSource = dtl;
}
//选择料件
private void btnSelectMaterial_Click(object sender, EventArgs e)
{
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial();
frmSelectMaterial.Tag = "";
frmSelectMaterial.ShowDialog();
//选择的料件填充
if (frmSelectMaterial.Tag.ToString() != "")
{
//得到选择的料件guid，然后得到
Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString());
//填充数据
txtMaterialGuid.Text = material.MaterialGuid;
txtBarNo.Text = material.BarNo;
txtMaterialName.Text = material.MaterialName;
txtMaterialId.Text = material.MaterialId;
txtSpec.Text = material.Spec;
}
}
private void btnAddDetail_Click(object sender, EventArgs e)
{
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial();
frmSelectMaterial.Tag = "";
frmSelectMaterial.ShowDialog();
//选择的料件填充
if (frmSelectMaterial.Tag.ToString() != "")
{
//得到选择的料件guid，然后得到
Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString());
//填充数据
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue(gridMaterialGuid, material.MaterialGuid);
gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialId);
gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName);
gridView1.SetFocusedRowCellValue(gridClassName, material.ClassId);
gridView1.SetFocusedRowCellValue(gridBarNo, material.BarNo);
gridView1.SetFocusedRowCellValue(gridSpec, material.Spec);
gridView1.SetFocusedRowCellValue(gridUnit, material.Unit);
gridView1.SetFocusedRowCellValue(gridRemark, material.Remark);
//出库单货品是否自动计算平均单价
if (this.Text == "出库单新增" || this.Text == "出库单编辑")
{
string AutoFillBillOutPrice = System.Configuration.ConfigurationSettings.AppSettings["IsAutoFillBillOutPrice"].ToString();;
if (AutoFillBillOutPrice == "true")
{
decimal priceAVG = 0;
string guid = ((DataRowView)(gridView1.GetFocusedRow())).Row[0].ToString();
//得到此料件在某个仓库中的平均价,写入单价列中
priceAVG = bm.sp_GetMaterialPrice(guid, cboDepot.Text);
gridView1.SetFocusedRowCellValue(gridPrice, priceAVG);
}
}
}
}
//增加明细
private void btnAddMaterial_Click(object sender, EventArgs e)
{
MaterialManage MaterialManage = new MaterialManage();
frmSelectMaterial frmSelectMaterial = new frmSelectMaterial();
frmSelectMaterial.ShowDialog();
if (frmSelectMaterial.Tag != null)
{
//取出选择的料件Guid
List <string> lstGuid = frmSelectMaterial.Tag as List <string>;
//选择的品名填充
if (lstGuid.Count > 0)
{
//得到料件的信息
for (int i = 0; i < lstGuid.Count; i++)
{
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(lstGuid[i]);
//填充数据
gridView2.AddNewRow();
gridView2.SetFocusedRowCellValue(gridMaterialGuidDetail, material.MaterialGuID);
gridView2.SetFocusedRowCellValue(gridMaterialIDDetail, material.MaterialID);
gridView2.SetFocusedRowCellValue(gridMaterialNameDetail, material.MaterialName);
gridView2.SetFocusedRowCellValue(gridUnitDetail, base.GetBasicDataNameByID(material.Unit));
gridView2.SetFocusedRowCellValue(gridSpecDetail, base.GetBasicDataNameByID(material.Spec));
gridView2.SetFocusedRowCellValue(gridMaterialSumDetail, 0);
gridView2.SetFocusedRowCellValue(gridStorageSum, 0);
gridView2.SetFocusedRowCellValue(gridStorageMaterialSum, 0);
gridView2.SetFocusedRowCellValue(gridOnlySum, 0);
}
}
}
}
private void btnAddDetail_Click(object sender, EventArgs e)
{
MaterialBOMManage MaterialBOMManage = new MaterialBOMManage();
frmSelectMaterial2 frmSelectMaterial2 = new frmSelectMaterial2();
frmSelectMaterial2.ShowDialog();
if (frmSelectMaterial2.Tag != null)
{
//取出选择的料件Guid
List <string> lstGuid = frmSelectMaterial2.Tag as List <string>;
//选择的品名填充
if (lstGuid.Count > 0)
{
//组建物料sql
string strsql = " where 1<>1 ";
for (int i = 0; i < lstGuid.Count; i++)
{
strsql = strsql + " or MaterialGuid='" + lstGuid[i] + "'";
}
//加载单耗
DataSet dsetConsume = new DataSet();
if (frmSelectMaterial2.txtQryValue.Text.Trim() != "")
{
if (frmSelectMaterial2.txtQryValue.Tag != null)
{
//确认是点击了BOM查询
dsetConsume = MaterialBOMManage.sp_GetMaterialBomConsumeByDrawOrder(strsql, frmSelectMaterial2.txtQryValue.Tag.ToString());
}
}
//得到料件的信息
for (int i = 0; i < lstGuid.Count; i++)
{
Material material = new Material();
material = MaterialManage.GetMaterialByGuid(lstGuid[i]);
//填充数据
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue(gridMaterialGuID, material.MaterialGuID);
gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialID);
gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName);
gridView1.SetFocusedRowCellValue(gridUnit, base.GetBasicDataNameByID(material.Unit));
gridView1.SetFocusedRowCellValue(gridSpec, base.GetBasicDataNameByID(material.Spec));
//加载单耗
if (frmSelectMaterial2.txtQryValue.Text.Trim() != "")
{
if (frmSelectMaterial2.txtQryValue.Tag != null)
{
decimal decConsumeSum = GetConsumeSum(material.MaterialGuID, dsetConsume);
gridView1.SetFocusedRowCellValue(gridConsumeSum, decConsumeSum.ToString("g0"));
}
}
}
}
}
}
