/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRC_COGDOWN_PRODUCT model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRC_COGDOWN_PRODUCT model) { return(dal.Update(model)); }
/// <summary> /// 提交实绩 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save_Click(object sender, EventArgs e) { WaitingFrom.ShowWait(""); if (DialogResult.No == MessageBox.Show("确认开坯吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } int compareDt = DateTime.Compare(this.dt_ExecStart.DateTime, this.dt_ExecEnd.DateTime); if (compareDt > 0) { MessageBox.Show("日期错误!"); return; } int errorNum = 0;//TryParse 输出参数 string planError = txt_PlanNum.Text.Trim(); if (planError != null && planError != "" && !Int32.TryParse(planError, out errorNum)) { MessageBox.Show("计划支数格式错误!"); return; } string scrapError = txt_ScrapNum.Text.Trim(); if (scrapError != null && scrapError != "" && !Int32.TryParse(scrapError, out errorNum)) { MessageBox.Show("异常支数格式错误!"); return; } DataRow dr = this.gv_GP1.GetDataRow(0);//获取计划焦点行索引 if (dr == null) { MessageBox.Show("无可开坯数据!"); return; } string gx = bll_TB_STA.GetproIdByCode(staCode); string gz = bll_TB_BCBZ.GetGZNEW(gx); sfys = bll_TB_BCBZGZ.GetSFYS(gz); var matrl = bll_TB_MATRL_MAIN.GetModel(dr["C_MAT_CODE"].ToString()); var matrl2 = bll_TB_MATRL_MAIN.GetModel(img_MatCode.EditValue.ToString()); if (matrl == null) { MessageBox.Show("请确定钢坯已出炉!"); return; } Mod_TRC_COGDOWN_PRODUCT model = new Mod_TRC_COGDOWN_PRODUCT(); model.C_COGDOWN_ID = dr["C_ID"].ToString(); //获取焦点主键 model.C_PLAN_ID = dr["C_PLAN_ID"].ToString(); //获取焦点计划主键 var planModel = bll_TRP_PLAN_COGDOWN.GetModel(model.C_PLAN_ID); model.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); //获取焦点批号 model.C_STOVE = dr["C_STOVE"].ToString(); //获取焦点炉号 model.C_STL_GRD = dr["C_STL_GRD"].ToString(); //获取焦点行钢种 model.C_STD_CODE = dr["C_STD_CODE"].ToString(); //获取焦点行执行标准 model.C_STA_ID = staID; model.C_SPEC = matrl2.C_SLAB_SIZE; //钢种规格 model.N_LEN = matrl2.N_LTH; //长度 model.C_MAT_CODE = img_MatCode.EditValue.ToString(); //获取焦点物料编码 model.C_MAT_NAME = matrl2.C_MAT_NAME; //获取焦点物料名称 model.N_QUA = 1; model.N_WGT = matrl2.N_HSL; //获取焦点单重 model.C_MOVE_TYPE = "M"; //开坯待入库 model.C_REMARK = this.txt_Remark.Text; //获取焦点备注 model.C_QR_USER = UserInfo.userID; model.D_Q_DATE = DateTime.Now; object obj = bll_TRC_ROLL_WGD.GetOutTime(model.C_COGDOWN_ID); model.D_START_DATE = obj == null ? DateTime.Now : DateTime.Parse(obj.ToString()); model.D_END_DATE = RV.UI.ServerTime.timeNow(); DateTime productionTime = model.D_START_DATE.Value; if (sfys == "延时") { if (Convert.ToInt32(model.D_START_DATE.Value.ToString("HH")) >= 20) { productionTime = productionTime.AddDays(1); } } model.D_QR_DATE = DateTime.Parse(productionTime.ToString("yyyy-MM-dd")); model.C_COGDOWN_SHIFT = this.cbo_Shift.EditValue.ToString(); model.C_COGDOWN_GROUP = this.cbo_Group.EditValue.ToString(); model.C_EXTEND1 = this.cbo_Shift.Text; model.C_EXTEND2 = this.cbo_Group.Text; model.N_STATUS = 1; model.C_STOCK_STATE = "F"; model.C_QKP_STATE = "N"; model.C_COG_STA_ID = staID; model.C_ZYX1 = planModel.C_FREE1; model.C_ZYX2 = planModel.C_FREE2; model.C_JUDGE_LEV_ZH = "合格品"; model.C_MAT_TYPE = "Y"; model.C_IS_QR = "Y"; int planNum = Convert.ToInt32(this.txt_PlanNum.Text); //计划支数 int cogDownNum = Convert.ToInt32(this.txt_CogDownNum.Text); //开坯支数 if (this.txt_ScrapNum.Text == null || this.txt_ScrapNum.Text == "") { this.txt_ScrapNum.Text = "0"; } int scrapNum = Convert.ToInt32(this.txt_ScrapNum.Text);//报废支数 if (planNum == 0) { if (bll_TRC_COGDOWN_MAIN.UpdateCogDown(model.C_COGDOWN_ID) != 0) { MessageBox.Show("操作成功!"); Query1(); Query2(); } else { MessageBox.Show("操作失败!"); } return; } string result = bll_TRC_COGDOWN_MAIN.CogDownFactHandler(model, planNum, cogDownNum, scrapNum, decimal.Parse(model.N_WGT.ToString()), decimal.Parse(dr["N_PW"].ToString()), Application.StartupPath); if (result == "1") { MessageBox.Show("操作成功!"); Query1(); Query2(); //#region 同步开坯实绩到NC //DataTable dt = bll_TRC_COGDOWN_MAIN.GetCogDownFact(2, staID, 1).Tables[0]; //if (dt == null || dt.Rows.Count == 0) //{ // return; //} //for (int i = 0; i < dt.Rows.Count; i++) //{ // string re = bll_TRC_COGDOWN_MAIN.KpSyncNc(dt.Rows[i]["C_COGDOWN_ID"].ToString(), slbwhCode, staID, Application.StartupPath, dt.Rows[i]["C_COGDOWN_SHIFT"].ToString(), dt.Rows[i]["C_COGDOWN_GROUP"].ToString()); //} //#endregion } else { MessageBox.Show("操作失败!"); } WaitingFrom.CloseWait(); }