/// <summary>
/// 控制申请数量只能填写数字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgv1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
int i = e.ColumnIndex;
DataGridViewColumn column = dgv1.Columns[e.ColumnIndex];
if (column.Name == "申请数量")
{
if (dgv1.Rows[e.RowIndex].Cells[i].Value != null)
{
string rqty = dgv1.Rows[e.RowIndex].Cells[i].Value.ToString();
if (BaseClass.validateNum(rqty) == false)
{
MessageBox.Show("请输入数字!!!", "提示");
dgv1.Rows[e.RowIndex].Cells[i].Value = "";
}
}
}
else if (column.Name == "零件号")
{
if (dgv1.Rows[e.RowIndex].Cells[i].Value != null)
{
string rqty = dgv1.Rows[e.RowIndex].Cells[i].Value.ToString();
string Site = cmb_site.SelectedValue.ToString();
InventoryPart invpartnew = InventoryPart.FindInvInfor(rqty, Site);
if (invpartnew != null)
{
dgv1.Rows[e.RowIndex].Cells[i].Value = invpartnew.PART_NO;
dgv1.Rows[e.RowIndex].Cells[i + 1].Value = invpartnew.description;
dgv1.Rows[e.RowIndex].Cells["单位"].Value = invpartnew.unit_meas;
}
else
{
MessageBox.Show("无此材料编码");
return;
}
InventoryPart invpart = InventoryPart.GetOnhandqty(Site, rqty, ProjectId);
if (invpart != null)
{
dgv1.Rows[e.RowIndex].Cells["inventory_qty"].Value = invpart.qty_onhand;
dgv1.Rows[e.RowIndex].Cells["JYstock"].Value = invpart.qty_reserved;
dgv1.Rows[e.RowIndex].Cells["meo_qty"].Value = Convert.ToDecimal(invpart.qty_onhand) - Convert.ToDecimal(invpart.qty_reserved);
}
}
}
}
}
public void listviewBind(string sql)
{
//更改并设置列名称以及属性
DataSet ds = PartParameter.QueryPartPara(sql);
dgv1.DataSource = ds.Tables[0];
//DataGridViewComboBoxColumn dgvcom = new DataGridViewComboBoxColumn();
//dgvcom.DataSource = PartParameter.QueryPartPara("select name from mm_unit_tab").Tables[0].DefaultView;;
//dgvcom.DisplayMember = "name";
//dgvcom.ValueMember = "name";
////dgv1.Columns.Insert(1, dgvcom);
//dgv1.GridColumnStyles[1]=dgvcom;
//dgv1.Columns["零件认证"].Width = 100;
//dgv1.Columns["单位密度"].ValueType = typeof();
//dgv1.Columns["零件材质"].ValueType = typeof(float);
dgv1.Columns["域"].ReadOnly = true;
dgv1.Columns["序号"].ReadOnly = true;
dgv1.Columns["零件号"].ReadOnly = true;
//dgv1.Columns["零件类别"].ReadOnly = true;
//dgv1.Columns["零件规格"].ReadOnly = true;
//dgv1.Columns["材质"].ReadOnly = true;
//dgv1.Columns["证书"].ReadOnly = true;
//dgv1.Columns["单位"].ReadOnly = true;
dgv1.Columns["parentid"].Visible = false;
#region 将库存值填入表格
if (cb_showqty.Checked == true)
{
dgv1.Columns["项目预留数量"].ReadOnly = true;
dgv1.Columns["项目采购数量"].ReadOnly = true;
dgv1.Columns["项目可用库存量"].ReadOnly = true;
if (dgv1.RowCount != 0)
{
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择所查询的项目");
return;
}
string projectname = item.Value;
for (int i = 0; i < dgv1.Rows.Count; i++)
{
string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString();
InventoryPart part_kucun = InventoryPart.GetOnhandqty(site, partno, projectname.Substring(projectname.Length - 3, 3));;
if (part_kucun != null)
{
dgv1.Rows[i].Cells["项目可用库存量"].Value = part_kucun.qty_onhand;
dgv1.Rows[i].Cells["项目采购数量"].Value = Convert.ToDecimal(part_kucun.qty_onhand) - Convert.ToDecimal(part_kucun.qty_reserved);
dgv1.Rows[i].Cells["项目预留数量"].Value = part_kucun.qty_reserved;
}
else
{
dgv1.Rows[i].Cells["预估量"].Value = 0;
//dgv1.Rows[i].Cells[2].Value = "M";
}
}
//}
}
}
#endregion
//#region 设置列的只读性
//int specnum = PartParameter.GetSpecCou(activity);
//if (specnum != 0)
//{
// if (specnum > 0)
// {
// string colstr = PartParameter.GetSpecName(activity, "1").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 1)
// {
// string colstr = PartParameter.GetSpecName(activity, "2").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 2)
// {
// string colstr = PartParameter.GetSpecName(activity, "3").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
// if (specnum > 3)
// {
// string colstr = PartParameter.GetSpecName(activity, "4").Trim();
// dgv1.Columns[colstr].ReadOnly = true;
// }
//}
//#endregion
#region 将已设置过的预估值填入表格
//if (dgv1.RowCount != 0)
//{
// List<PartParameter> pp = PartParameter.FindPartList(activity, ProjectId,LoginUser,1);
// //if (pp.Count != 0)
// // {
// for (int i = 0; i < dgv1.Rows.Count; i++)
// {
// int partid = int.Parse(dgv1.Rows[i].Cells["序号"].Value.ToString());
// PartParameter pone = pp.Find(delegate(PartParameter bb) { return bb.ID == partid; });
// if (pone != null)
// {
// dgv1.Rows[i].Cells["预估量"].Value = pone.PREDICTION_QTY;
// //dgv1.Rows[i].Cells[2].Value = pone.UNIT;
// }
// else
// {
// dgv1.Rows[i].Cells["预估量"].Value = 0;
// //dgv1.Rows[i].Cells[2].Value = "M";
// }
// }
// //}
//}
#endregion
}