| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工单已关闭,不允许开报工操作!"; |
| | | mes.message = "当前工单已关闭,不允许开报工操作!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | |
| | | //1.根据工单+工序查找当前工序是否首道工序 |
| | | sql = @"select A.wo_code,P.partcode,P.partname,P.partspec, T.stepcode,T.stepname,A.seq,T.flwtype,T.descr,A.status,A.plan_qty,A.isbott,A.isend,L.org_code,L.org_name |
| | | sql = @"select A.wo_code,P.partcode,P.partname,P.partspec, T.stepcode,T.stepname,A.stepprice,A.seq,T.flwtype,T.descr,A.status,A.plan_qty,A.isbott,A.isend,L.torg_code,L.torg_name |
| | | from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | left join TK_Wrk_Man M on A.wo_code=M.wo_code |
| | | left join TMateriel_Info P on M.materiel_code=P.partcode |
| | | left join TOrganization L on M.wkshp_code=L.org_code |
| | | left join TOrganization L on M.wkshp_code=L.torg_code |
| | | where A.wo_code=@ordercode and A.step_code=@stepcode"; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | | dynamicParams.Add("@stepcode", stepcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | rt.wkshopcode = data.Rows[0]["org_code"].ToString(); //车间编码 |
| | | rt.wkshopname = data.Rows[0]["org_name"].ToString(); //车间名称 |
| | | rt.wkshopcode = data.Rows[0]["torg_code"].ToString(); //车间编码 |
| | | rt.wkshopname = data.Rows[0]["torg_name"].ToString(); //车间名称 |
| | | rt.wo_code = data.Rows[0]["WO_CODE"].ToString(); //工单号 |
| | | rt.partnumber = data.Rows[0]["PARTCODE"].ToString(); //产品编码 |
| | | rt.partname = data.Rows[0]["PARTNAME"].ToString(); //产品名称 |
| | |
| | | rt.stepcode = data.Rows[0]["STEPCODE"].ToString(); //工序编码 |
| | | rt.stepname = data.Rows[0]["STEPNAME"].ToString(); //工序名称 |
| | | rt.stepdesc = data.Rows[0]["DESCR"].ToString(); //工序描述 |
| | | rt.stepprice= data.Rows[0]["STEPPRICE"].ToString(); //工序工价 |
| | | rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量 |
| | | |
| | | flwtype = data.Rows[0]["FLWTYPE"].ToString();//获取工序属性 |
| | |
| | | rt.seq = data.Rows[0]["SEQ"].ToString();//工序序号 |
| | | |
| | | //获取当前工序下道工序 |
| | | sql = @"select A.isbott,A.isend,T.stepcode,T.stepname from TK_Wrk_Step A |
| | | sql = @"select A.isbott,A.isend,T.stepcode,T.stepname,A.stepprice from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | where A.wo_code=@ordercode and A.seq=@seq+1 "; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | |
| | | { |
| | | rt.nextstepcode = dt.Rows[0]["STEPCODE"].ToString();//下道工序编码 |
| | | rt.nextstepname = dt.Rows[0]["STEPNAME"].ToString();//下道工序名称 |
| | | rt.nextstepprice = dt.Rows[0]["STEPPRICE"].ToString(); //下道工序工价 |
| | | } |
| | | if (isend == "Y") //当前工序是末道工序 |
| | | { |
| | | rt.nextstepcode = "";//data.Rows[0]["STEPCODE"].ToString();//当前工序编码 |
| | | rt.nextstepname = "";// data.Rows[0]["STEPNAME"].ToString();//当前工序名称 |
| | | rt.nextstepprice = "";// data.Rows[0]["STEPPRICE"].ToString();//当前工序工价 |
| | | } |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序任务不存在!"; |
| | | mes.message = "当前工序任务不存在!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序无可报工数量!"; |
| | | mes.message = "当前工序无可报工数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.reportqty = good_qty + ng_qty + laborbad_qty+ materielbad_qty; //已报数量=报工数量+不良数量+工废数量+料废数量 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "查找成功!"; |
| | | mes.message = "查找成功!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | rt.reportqty = 0; //已报数量 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "查找成功!"; |
| | | mes.message = "查找成功!"; |
| | | mes.data = rt; |
| | | } |
| | | |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可报数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可报数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.reportqty = good_qty + ng_qty + laborbad_qty+ materielbad_qty;//已报数量=本道报工总数量+本道报工总不良+本道工废总数+本道料废总数 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "弹窗报工界面!"; |
| | | mes.message = "弹窗报工界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可报数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可报数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许开报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许开报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.reportqty = good_qty + ng_qty + laborbad_qty+materielbad_qty; //已报数量=本道报工总数量+本道报工总不良+本道总工废数+本道总料废数 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "查找成功!"; |
| | | mes.message = "查找成功!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许开报工,请前往外协操作页执行!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许开报工,请前往外协操作页执行!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许开报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许开报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.reportqty = 0; //已报数量 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "查找成功!"; |
| | | mes.message = "查找成功!"; |
| | | mes.data = rt; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许开报工!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许开报工!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.reportqty = 0; //已报数量 |
| | | mes.code = "200"; |
| | | mes.count = 1; |
| | | mes.Message = "查找成功!"; |
| | | mes.message = "查找成功!"; |
| | | mes.data = rt; |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许报工,请前往外协操作页执行!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许报工,请前往外协操作页执行!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | case "W": //外协工序 |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工单工序任务为外协,请前往外协操作标签页操作!"; |
| | | mes.message = "当前工单工序任务为外协,请前往外协操作标签页操作!"; |
| | | mes.data = null; |
| | | break; |
| | | default: //自制+外协工序 |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.message = e.Message; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工单已关闭,不允许开报工操作!"; |
| | | mes.message = "当前工单已关闭,不允许开报工操作!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | | |
| | | //1.根据工单+工序查找当前工序是否首道工序 |
| | | sql = @"select A.wo_code,P.partcode,P.partname,P.partspec, T.stepcode,T.stepname,A.seq,T.flwtype,T.descr,A.status,A.plan_qty,A.isbott,A.isend,L.org_code,L.org_name |
| | | sql = @"select A.wo_code,P.partcode,P.partname,P.partspec, T.stepcode,T.stepname,A.seq,T.flwtype,T.descr,A.stepprice,A.status,A.plan_qty,A.isbott,A.isend,L.torg_code,L.torg_name |
| | | from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | left join TK_Wrk_Man M on A.wo_code=M.wo_code |
| | | left join TMateriel_Info P on M.materiel_code=P.partcode |
| | | left join TOrganization L on M.wkshp_code=L.org_code |
| | | left join TOrganization L on M.wkshp_code=L.torg_code |
| | | where A.wo_code=@ordercode and A.step_code=@stepcode"; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | | dynamicParams.Add("@stepcode", stepcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | rt.wkshopcode = data.Rows[0]["org_code"].ToString(); //车间编码 |
| | | rt.wkshopname = data.Rows[0]["org_name"].ToString(); //车间名称 |
| | | rt.wkshopcode = data.Rows[0]["torg_code"].ToString(); //车间编码 |
| | | rt.wkshopname = data.Rows[0]["torg_name"].ToString(); //车间名称 |
| | | rt.wo_code = data.Rows[0]["WO_CODE"].ToString(); //工单号 |
| | | rt.partnumber = data.Rows[0]["PARTCODE"].ToString(); //产品编码 |
| | | rt.partname = data.Rows[0]["PARTNAME"].ToString(); //产品名称 |
| | |
| | | rt.stepname = data.Rows[0]["STEPNAME"].ToString(); //工序名称 |
| | | rt.stepdesc = data.Rows[0]["DESCR"].ToString(); //工序描述 |
| | | rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量 |
| | | |
| | | rt.stepprice = data.Rows[0]["STEPPRICE"].ToString(); //工序工价 |
| | | flwtype = data.Rows[0]["FLWTYPE"].ToString();//获取工序属性 |
| | | isbott = data.Rows[0]["ISBOTT"].ToString();//首道工序 |
| | | isend = data.Rows[0]["ISEND"].ToString();//末道工序 |
| | | rt.seq = data.Rows[0]["SEQ"].ToString();//工序序号 |
| | | |
| | | //获取当前工序下道工序 |
| | | sql = @"select A.isbott,A.isend,T.stepcode,T.stepname from TK_Wrk_Step A |
| | | sql = @"select A.isbott,A.isend,T.stepcode,T.stepname,A.stepprice from TK_Wrk_Step A |
| | | left join TStep T on A.step_code=T.stepcode |
| | | where A.wo_code=@ordercode and A.seq=@seq+1 "; |
| | | dynamicParams.Add("@ordercode", ordercode); |
| | |
| | | { |
| | | rt.nextstepcode = dt.Rows[0]["STEPCODE"].ToString();//下道工序编码 |
| | | rt.nextstepname = dt.Rows[0]["STEPNAME"].ToString();//下道工序名称 |
| | | rt.nextstepprice = dt.Rows[0]["STEPPRICE"].ToString(); //下道工序工价 |
| | | } |
| | | if (isend == "Y") //当前工序是末道工序 |
| | | { |
| | | rt.nextstepcode = "";// data.Rows[0]["STEPCODE"].ToString();//当前工序编码 |
| | | rt.nextstepname = "";// data.Rows[0]["STEPNAME"].ToString();//当前工序名称 |
| | | rt.nextstepprice = ""; //data.Rows[0]["NEXTSTEPPRICE"].ToString();//下道工序工价 |
| | | } |
| | | } |
| | | else |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前扫码工序任务不存在!"; |
| | | mes.message = "当前扫码工序任务不存在!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | case "Z": |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前标签为自制标签,请前往自制操作标签页扫码!"; |
| | | mes.message = "当前标签为自制标签,请前往自制操作标签页扫码!"; |
| | | mes.data = null; |
| | | break; |
| | | case "W": |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序无可发料数量!"; |
| | | mes.message = "当前工序无可发料数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | rt.startqty = kfqty; //发料数量=剩余可发数量 |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "查询成功!"; |
| | | mes.message = "查询成功!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | rt.startqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //发料数量=任务数量 |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "弹窗发料界面!"; |
| | | mes.message = "弹窗发料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "弹窗发料界面!"; |
| | | mes.message = "弹窗发料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "弹窗发料界面!"; |
| | | mes.message = "弹窗发料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未发料,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未发料,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格产出为0,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "弹窗发料界面!"; |
| | | mes.message = "弹窗发料界面!"; |
| | | mes.data = rt; |
| | | |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未报工,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + "无可发数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 合格收料为0,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 2; |
| | | mes.Message = "弹窗发料界面!"; |
| | | mes.message = "弹窗发料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 的上道工序:" + data0.Rows[0]["STEPNAME"].ToString() + " 未收料,本道不允许发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | case "Z"://自制 |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前标签为自制标签,请前往自制操作标签页扫码!"; |
| | | mes.message = "当前标签为自制标签,请前往自制操作标签页扫码!"; |
| | | mes.data = null; |
| | | break; |
| | | case "W": |
| | |
| | | { |
| | | //1.首道工序时,判断是否有发料记录 |
| | | sql = @"select R.wo_code,R.step_code,R.wx_code as code,C.name,R.materiel_code, |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.bad_qty),0) as bad_qty |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.laborbad_qty),0) as laborbad_qty,isnull(sum(R.materielbad_qty),0) as materielbad_qty |
| | | from TK_Wrk_OutRecord R |
| | | left join TCustomer C on R.wx_code=C.code |
| | | where R.wo_code=@ordercode and R.step_code=@stepcode and R.style='F' |
| | |
| | | { |
| | | //1.首道工序时,判断是否有收料记录 |
| | | sql = @"select R.wo_code,R.step_code,R.wx_code as code,C.name,R.materiel_code, |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.bad_qty),0) as bad_qty |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.laborbad_qty),0) as laborbad_qty,isnull(sum(R.materielbad_qty),0) as materielbad_qty |
| | | from TK_Wrk_OutRecord R |
| | | left join TCustomer C on R.wx_code=C.code |
| | | where R.wo_code=@ordercode and R.step_code=@stepcode and R.style='S' |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 无可收料数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 无可收料数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | fqty = g.Sum(i => (decimal)i["fqty"]), |
| | | sqty = g.Sum(i => (decimal)i["sqty"]), |
| | | ng_qty = g.Sum(i => (decimal)i["ng_qty"]), |
| | | bad_qty = g.Sum(i => (decimal)i["bad_qty"]) |
| | | laborbad_qty = g.Sum(i => (decimal)i["laborbad_qty"]), |
| | | materielbad_qty = g.Sum(i => (decimal)i["materielbad_qty"]) |
| | | }).ToList(); |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 3; |
| | | mes.Message = "弹窗收料界面!"; |
| | | mes.message = "弹窗收料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | |
| | |
| | | fqty = g.Sum(i => (decimal)i["fqty"]), |
| | | sqty = g.Sum(i => (decimal)i["sqty"]), |
| | | ng_qty = g.Sum(i => (decimal)i["ng_qty"]), |
| | | bad_qty = g.Sum(i => (decimal)i["bad_qty"]) |
| | | laborbad_qty = g.Sum(i => (decimal)i["laborbad_qty"]), |
| | | materielbad_qty = g.Sum(i => (decimal)i["materielbad_qty"]) |
| | | }).ToList(); |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 3; |
| | | mes.Message = "弹窗收料界面!"; |
| | | mes.message = "弹窗收料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 未发料,请先发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 未发料,请先发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | //1.非首道工序时,判断本道是否有发料记录 |
| | | sql = @"select R.wo_code,R.step_code,R.wx_code as code,C.name,R.materiel_code, |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.bad_qty),0) as bad_qty |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.laborbad_qty),0) as laborbad_qty,isnull(sum(R.materielbad_qty),0) as materielbad_qty |
| | | from TK_Wrk_OutRecord R |
| | | left join TCustomer C on R.wx_code=C.code |
| | | where R.wo_code=@ordercode and R.step_code=@stepcode and R.style='F' |
| | |
| | | { |
| | | //2.非首道工序时,判断本道是否有收料记录 |
| | | sql = @"select R.wo_code,R.step_code,R.wx_code as code,C.name,R.materiel_code, |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.bad_qty),0) as bad_qty |
| | | isnull(sum(R.fqty),0) as fqty,isnull(sum(R.sqty),0) as sqty,isnull(sum(R.ng_qty),0) as ng_qty,isnull(sum(R.laborbad_qty),0) as laborbad_qty,isnull(sum(R.materielbad_qty),0) as materielbad_qty |
| | | from TK_Wrk_OutRecord R |
| | | left join TCustomer C on R.wx_code=C.code |
| | | where R.wo_code=@ordercode and R.step_code=@stepcode and R.style='S' |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 无可收料数量!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 无可收料数量!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | fqty = g.Sum(i => (decimal)i["fqty"]), |
| | | sqty = g.Sum(i => (decimal)i["sqty"]), |
| | | ng_qty = g.Sum(i => (decimal)i["ng_qty"]), |
| | | bad_qty = g.Sum(i => (decimal)i["bad_qty"]) |
| | | laborbad_qty = g.Sum(i => (decimal)i["laborbad_qty"]), |
| | | materielbad_qty = g.Sum(i => (decimal)i["materielbad_qty"]) |
| | | }).ToList(); |
| | | |
| | | mes.code = "200"; |
| | | mes.count = 3; |
| | | mes.Message = "弹窗收料界面!"; |
| | | mes.message = "弹窗收料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | fqty = g.Sum(i => (decimal)i["fqty"]), |
| | | sqty = g.Sum(i => (decimal)i["sqty"]), |
| | | ng_qty = g.Sum(i => (decimal)i["ng_qty"]), |
| | | bad_qty = g.Sum(i => (decimal)i["bad_qty"]) |
| | | laborbad_qty = g.Sum(i => (decimal)i["laborbad_qty"]), |
| | | materielbad_qty = g.Sum(i => (decimal)i["materielbad_qty"]) |
| | | }).ToList(); |
| | | mes.code = "200"; |
| | | mes.count = 3; |
| | | mes.Message = "弹窗收料界面!"; |
| | | mes.message = "弹窗收料界面!"; |
| | | mes.data = rt; |
| | | } |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 未发料,请先发料!"; |
| | | mes.message = "当前工序:" + data.Rows[0]["STEPNAME"].ToString() + " 未发料,请先发料!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.message = "未找到当前工序的上道工序信息,请联系管理员核实!"; |
| | | mes.data = null; |
| | | return mes; |
| | | } |
| | |
| | | { |
| | | mes.code = "300"; |
| | | mes.count = 0; |
| | | mes.Message = e.Message; |
| | | mes.message = e.Message; |
| | | mes.data = null; |
| | | return mes; |
| | | } |