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();
}
public void ImportParaData()
{
#region 逐行导入预估结果
for (int i = 0; i < dgv2.Rows.Count - 1; i++)
{
string partno = dgv2.Rows[i].Cells[4].Value.ToString().Trim();
string quyu = dgv2.Rows[i].Cells[1].Value.ToString().Trim();
string zhuanye = DisciplineId;
string parttype = dgv2.Rows[i].Cells[3].Value.ToString().Trim();
string partname = dgv2.Rows[i].Cells[5].Value.ToString().Trim();
string predict_qty = dgv2.Rows[i].Cells[6].Value.ToString().Trim();
string firstbatchqty = dgv2.Rows[i].Cells[7].Value.ToString().Trim();
string firstbatchdate = dgv2.Rows[i].Cells[8].Value.ToString().Trim();
string secondbatchqty = dgv2.Rows[i].Cells[9].Value.ToString().Trim();
string secondbatchdate = dgv2.Rows[i].Cells[10].Value.ToString().Trim();
string unit_meas = dgv2.Rows[i].Cells[11].Value.ToString().Trim();
string predict_date = dgv2.Rows[i].Cells[12].Value.ToString().Trim();
string predict_person = dgv2.Rows[i].Cells[13].Value.ToString().Trim();
PartParameter predictset = new PartParameter();
predictset.OPERATOR = User.cur_user;
predictset.PREDICT_DATE = Convert.ToDateTime(predict_date);
predictset.PREDICT_CREATOR = predict_person;
predictset.PREDICTION_QTY = string.IsNullOrEmpty(predict_qty) == true ? 0 : decimal.Parse(predict_qty);
predictset.PART_NO = partno;
predictset.PROJECT_ZONE = quyu;
predictset.DISCIPLINE = zhuanye;
predictset.PART_TYPE = parttype;
predictset.DESCRIPTION = partname;
predictset.CONTRACT = mSite;
predictset.LAST_FLAG = 1;
predictset.FIRSTBATCH_QTY = string.IsNullOrEmpty(firstbatchqty) == true ? 0 : decimal.Parse(firstbatchqty);
predictset.FIRSTBATCH_DATE = Convert.ToDateTime(firstbatchdate);
predictset.SECONDBATCH_QTY = string.IsNullOrEmpty(secondbatchqty) == true ? 0 : decimal.Parse(secondbatchqty);
predictset.SECONDBATCH_DATE = Convert.ToDateTime(secondbatchdate);
predictset.FINAL_PREDICTION_QTY = string.IsNullOrEmpty(predict_qty) == true ? 0 : decimal.Parse(predict_qty);
predictset.UNIT = unit_meas;
predictset.ECPROJECTID = ProjectSystem.FindProjectid(ProjectId);;
predictset.PROJECTID = ProjectId;
int count = predictset.Add();
}
#endregion
}