private void MaterialRationAdd_Load(object sender, EventArgs e)
{
ProjectCmbItem.ProjectCmbBind(cmb_project);
//ProjectCmbItem.ReasonCmbBind(cmb_reason);
//ProjectCmbItem.SiteCmbBind(cmb_site2);
ProjectCmbItem.SiteCmbBind(cmb_site);
ProjectCmbItem.BindDisciplineName(cmb_discipline);
//ProjectCmbItem.BindDiscipline(cmb_discipline2);
ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString();
UnitCmbBind();
ReasonCmbBind();
listviewTitleBind();
if (MEOID == "0")
{
btn_save.Enabled = true;
btn_select.Enabled = true;
}
else
{
if (MEOSTATE == "1")
{
btn_save.Enabled = true;
btn_select.Enabled = true;
}
}
}
private void MaterialRequireAdd_Load(object sender, EventArgs e)
{
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.ReasonCmbBind(cmb_reason);
ProjectCmbItem.SiteCmbBind(cmb_site2);
ProjectCmbItem.SiteCmbBind(cmb_site);
ProjectCmbItem.BindDiscipline(cmb_discipline);
ProjectCmbItem.BindDiscipline(cmb_discipline2);
UnitCmbBind();
ReasonCmbBind();
listviewTitleBind();
if (MEOID == "0")
{
btn_save.Enabled = true;
btn_select.Enabled = true;
}
else
{
if (MEOSTATE == "1")
{
btn_save.Enabled = true;
btn_select.Enabled = true;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
//MessageBox.Show("1.首先检查要导入的Excel数据中ERP代码是否在ERP系统中存在；\n2.将该项目该专业的原先的预估数据历史保存，然后将新数据写入数据库；\n3.完成导入；","实现步骤说明");
mSite = cmb_site.SelectedValue.ToString();
DisciplineId = cmb_dpname.SelectedValue.ToString();
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
if (mSite == string.Empty)
{
MessageBox.Show("请选择域");
return;
}
if (DisciplineId == string.Empty)
{
MessageBox.Show("请选择专业");
return;
}
ProjectId = item.Value;
if (dgv2.Rows.Count > 0)
{
CheckImportDataHanlder CheckData = new CheckImportDataHanlder(CheckImportData);
CheckData.BeginInvoke(null, null);
}
}
private void Form1_Load(object sender, EventArgs e)
{
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.ReasonCmbBind(cmb_reason);
ProjectCmbItem.SiteCmbBind(cmb_site2);
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.BindDiscipline(cmb_discipline2);
}
private void ConvertStandard_Load(object sender, EventArgs e)
{
ProjectCmbItem.ProjectCmbBind(cmb_project);
//ProjectCmbItem.ReasonCmbBind(cmb_reason);
ProjectCmbItem.SiteCmbBind(cmb_site);
Str_FX = XmlOper.getXMLContent("Fx");
Str_Discipline = XmlOper.getXMLContent("Discipline");
ActivityName = XmlOper.getXMLContent("Parttype");
}
private void MaterialRationForm_Load(object sender, EventArgs e)
{
ProjectCmbItem.SiteCmbBind(cmb_site);
Str_FX = XmlOper.getXMLContent("Fx");
ActivityName = XmlOper.getXMLContent("Parttype");
Str_Discipline = XmlOper.getXMLContent("Discipline");
DataSet MyDs = GetMaterialRationDS("SP_GETMATERIALRATION", projectid, drawing, indicator);
this.dgv1.DataSource = MyDs.Tables[0].DefaultView;
MyDs.Dispose();
}
private void MISC_PROCUREMENT_Query_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“dataSet1.MM_PART_REQUIRE_VIEW”中。您可以根据需要移动或移除它。
//this.mM_PART_REQUIRE_VIEWTableAdapter.Fill(this.dataSet1.MM_PART_REQUIRE_VIEW);
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.ReasonCmbBind(cmb_reason);
ProjectCmbItem.SiteCmbBind(cmb_site2);
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.BindDiscipline(cmb_discipline2);
BindPartNobyAct();
}
private void frmPartParaList_Load(object sender, EventArgs e)
{
//ProjectCmbBind();
//取出所有零件类别
ecprojectid = ProjectSystem.FindProjectid(ProjectId);
string sqlstr = "select typeid,type_desc from mm_part_type_tab where parent_id<>0";
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.BindDiscipline(cmb_dpname);
ProjectCmbItem.SiteCmbBind(cmb_site);
//QuerydataBindpara();
}
/// <summary>
/// 更换项目时重新构建项目结构树
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmb_project_SelectedIndexChanged(object sender, EventArgs e)
{
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
ProjectId = item.Value;
ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString();
ProjectCmbItem.BlockBind(cmb_block, ecprojectid);
}
/// <summary>
/// 查找材料以及库存
/// </summary>
public void QuerydataBind()
{
//string ProjectId = cmb_project.SelectedValue.ToString();
site = cmb_site.SelectedValue.ToString();
string partno = cmb_partno.Text.Trim().ToString();
string parttype = tb_type.Text.Trim().ToString();
string projectname = string.Empty;
string designcode = tb_designcode.Text.Trim();
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item != null)
{
projectname = item.Value;
}
else
{
MessageBox.Show("请选择项目！", "查询提醒");
return;
}
if (string.IsNullOrEmpty(partno) && string.IsNullOrEmpty(parttype))
{
MessageBox.Show("请输入零件编码或者零件描述！", "查询提醒");
return;
}
string sprojectname = projectname.Substring(projectname.Length - 3, 3);
StringBuilder sb = new StringBuilder();
if (site != string.Empty)
{
sb.Append(" AND CONTRACT = '" + site + "'");
}
if (partno != string.Empty)
{
sb.Append(" AND part_no like '" + partno + "%'");
}
if (parttype != string.Empty)
{
sb.Append(" AND description like'" + parttype + "%'");
}
//if (designcode != string.Empty) sb.Append(" AND design_code like'" + designcode + "%'");
//string sqlSelect = "SELECT '','',pp.*,'' FROM PLM.MM_PART_TAB pp WHERE 1=1 and parentid= " + activity;
string sqlSelect = "select p.contract 域,p.part_no 零件号,p.description 零件描述,p.unit_meas 单位,nvl((select sum(tt.qty_onhand - tt.qty_reserved) from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no = p.part_no and tt.contract = '03' and tt.req_dept like 'YL" + sprojectname + "%'), 0) 项目预留可用,nvl((select sum(REQUIRE_QTY ) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled' ),0) 申请数量,nvl((select sum(IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO)) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled'),0) 已下发数量,nvl((select sum(REQUIRE_QTY -IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO)) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled'),0) 余下申请数量,nvl((select sum(tt.qty_onhand ) from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no = p.part_no and tt.contract = '03' and tt.req_dept like 'YL" + sprojectname + "%'), 0) 项目预留 from ifsapp.inventory_part p where p.part_status='A' ";
string wheresql = sb.ToString();
sqlSelect = sqlSelect + wheresql + "order by p.part_no";
listviewBind(sqlSelect);
}
/// <summary>
/// 获取ERP中项目列表
/// </summary>
public void ProjectCmbBind()
{
cmb_project.AutoCompleteSource = AutoCompleteSource.ListItems;
cmb_project.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmb_project.Items.Clear();
DataSet PartDS = project.FindProDataset();
DataTable dt = PartDS.Tables[0];
foreach (DataRow row in dt.Rows)
{
ProjectCmbItem item = new ProjectCmbItem(row["description"].ToString(), row["project_id"].ToString());
cmb_project.Items.Add(item);
}
//ProjectCmbItem itemn = new ProjectCmbItem("COSLProspector 半潜式钻井平台", "YCRO11-256");
////cmb_project.SelectedIndex = 7;
//cmb_project.SelectedItem = itemn;
}
private void dgv1_DoubleClick(object sender, EventArgs e)
{
if (dgv1.RowCount > 0)
{
foreach (Form form in this.ParentForm.MdiChildren)
{
if (form.Text == "材料维护页面")
{
if (form.WindowState == FormWindowState.Minimized)
{
form.WindowState = FormWindowState.Normal;
}
form.Activate();
return;
}
}
string project_name = "";
string site_no = dgv1.CurrentRow.Cells["域"].Value.ToString();
string partno = dgv1.CurrentRow.Cells["零件号"].Value.ToString();
string partname = dgv1.CurrentRow.Cells["零件描述"].Value.ToString();
string designcode = tb_designcode.Text.Trim();
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item != null)
{
project_name = item.Value;
}
else
{
MessageBox.Show("请选择项目！", "查询提醒");
return;
}
DetailInfo.MaterialManage.MaterialDetail detailform = new DetailInfo.MaterialManage.MaterialDetail(project_name, partno, partname, site_no, designcode);
detailform.Text = "材料详情页面";
detailform.MdiParent = this.MdiParent;
detailform.Show();
}
else
{
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
ProjectId = item.Value;
Site = cmb_site.SelectedValue.ToString();
openFileDialog1.Filter = "xls files|*.xlsx";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
string aimfile = openFileDialog1.FileName.ToString();
//MessageBox.Show(aimfile);
textBox1.Text = aimfile;
//getconnect(aimfile, "Sheet1");
dgv1.DataMember = "[定 额 表$]";
dgv1.DataSource = getconnect(aimfile, "定 额 表");
dgv1.Columns[0].ReadOnly = true;
dgv1.Columns[1].ReadOnly = true;
dgv1.Columns[2].ReadOnly = true;
dgv1.Columns[3].ReadOnly = true;
dgv1.Columns[4].ReadOnly = true;
dgv1.Columns[5].ReadOnly = true;
dgv1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgv1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
//读取excel 文件
}
else
{
}
}
private void button1_Click_1(object sender, EventArgs e)
{
mSite = cmb_site.SelectedValue.ToString();
if (mSite == string.Empty)
{
MessageBox.Show("请选择域");
return;
}
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
ProjectId = item.Value;
#region 如果选择区域和专业 那么按照此专业或者区域进行汇总预估数据
QuerydataBindpara();
#endregion
#region 如果没有选择区域和专业 那么按照不进行汇总预估数据
QuerydataBindpara();
#endregion
}
/// <summary>
/// 更换项目时重新构建项目结构树
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmb_project_SelectedIndexChanged(object sender, EventArgs e)
{
tvMType.Nodes.Clear();
tn = new TreeNode();
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
ProjectId = item.Value;
tn.Tag = ProjectId;
project p = project.Find(ProjectId);
if (p != null)
{
tn.Text = p.description;
tn.ImageIndex = 3;
tn.SelectedImageIndex = 3;
}
else
{
tn.Text = "项目";
}
this.tvMType.Nodes.Add(tn);
ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString();
DataTable dt = new DataTable();
DataTable dtact = new DataTable();
//int projectid = ProjectSystem.FindProjectid(ProjectId);
dt = SubProject.FindAllSubPro(ProjectId).Tables[0];
dtact = Activity.FindActivityDs(ProjectId).Tables[0];
//string virroot = ProjectSystem.GetProName(projectID);
CreateTreeViewRecursiveNew(tn, dt, dtact, "0");
ProjectCmbItem.BlockBind(cmb_block, ecprojectid);
}
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
}
private void M_Estimate_Load(object sender, EventArgs e)
{
ProjectCmbItem.ProjectCmbBind(cmb_project);
ProjectCmbItem.BindDiscipline(cmb_dpname);
ProjectCmbItem.SiteCmbBind(cmb_site);
}
private void btn_query_Click(object sender, EventArgs e)
{
ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem;
if (item == null)
{
MessageBox.Show("请选择项目", "提示");
return;
}
Projectid = item.Value;
if (Projectid == string.Empty)
{
MessageBox.Show("请选择项目");
return;
}
mSite = cmb_site2.SelectedValue.ToString();
string meono = txt_meono.Text.Trim().ToLower();
string partno = cmb_partno.Text.Trim().ToString().ToLower();
string PartName = cmb_partname.Text.Trim().ToString().ToLower();
string ReqDateFrom = dateTimePicker3.Checked == true?dateTimePicker3.Value.ToString("yyyy-MM-dd") : string.Empty;
string ReqDateTo = dateTimePicker4.Checked == true?dateTimePicker4.Value.ToString("yyyy-MM-dd") : string.Empty;
string CreateDateFrom = dateTimePicker1.Checked == true?dateTimePicker1.Value.ToString("yyyy-MM-dd") : string.Empty;
string CreateDateTo = dateTimePicker2.Checked == true?dateTimePicker2.Value.ToString("yyyy-MM-dd") : string.Empty;
//ReasonCode Ritem = (ReasonCode)cmb_reason.SelectedValue;
string ReasonCode = cmb_reason.SelectedValue.ToString();
string DesignCode = txt_designcode.Text.Trim().ToString().ToLower();
string Creator = txt_creator.Text.Trim().ToString().ToLower();
string meostate = cmb_state.Text == null ? "" : cmb_state.Text;
string manualno = tb_manual.Text.Trim().ToLower();
StringBuilder sb = new StringBuilder();
if (meostate != string.Empty && meostate != null)
{
sb.Append(meostate == "已审核" ? " and state='4'" : "and state='1'");
}
if (meono != string.Empty)
{
sb.Append(" and MEO_ERP like '%" + meono + "%'");
}
if (Projectid != string.Empty)
{
sb.Append(" AND PROJECT_ID = '" + Projectid + "'");
}
if (partno != string.Empty)
{
sb.Append(" AND lower(part_no) like '%" + partno + "%'");
}
if (PartName != string.Empty)
{
sb.Append(" AND lower(part_name) like'%" + PartName + "%'");
}
if (Creator != string.Empty)
{
sb.Append(" AND lower(CREATER) like'%" + Creator + "%'");
}
if (manualno != string.Empty)
{
sb.Append(" AND lower(require_no) like'%" + manualno + "%'");
}
if (ReasonCode != string.Empty)
{
sb.Append(" AND REASON_CODE ='" + ReasonCode + "'");
}
if (DesignCode != string.Empty)
{
sb.Append(" AND lower(DESIGN_CODE) like'%" + DesignCode + "%'");
}
if (ReqDateFrom != string.Empty)
{
sb.Append(" and REQUIRE_DATE>=" + Util.GetOracelDateSql(ReqDateFrom));
}
if (ReqDateTo != string.Empty)
{
sb.Append(" and REQUIRE_DATE -interval '1' day <=" + Util.GetOracelDateSql(ReqDateTo));
}
if (CreateDateFrom != string.Empty)
{
sb.Append(" and CREATE_DATE>=" + Util.GetOracelDateSql(CreateDateFrom));
}
if (CreateDateTo != string.Empty)
{
sb.Append(" and CREATE_DATE -interval '1' day <=" + Util.GetOracelDateSql(CreateDateTo));
}
string sqlSelect = "select * from plm.mmm_part_require_view where 1=1 ";
string wheresql = sb.ToString();
sqlSelect = sqlSelect + wheresql;
listviewBindInter(sqlSelect);
}
