生产订单编码规则(S+年(23)+五位流水号)实例:S2300001
生产订单按照日期最新的排在最前面
| | |
| | | oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'"); |
| | | } |
| | | return sBillNo; |
| | | case 3: //根据 乔一 (S + 年(23)+五位流水号)实例:S2300001 |
| | | Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''", "Gy_MaxNum"); |
| | | sKjYear = sKjYear.Substring(2, 2); |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); |
| | | Profix = Profix.Substring(0, 1); |
| | | sBillNo = Profix.Trim() + sKjYear + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); |
| | | } |
| | | else //插入新记录 |
| | | { |
| | | sStr = new string(c, CodeLen - 1); |
| | | oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + sDay + "',1)"); |
| | | sBillNo = Profix.Trim() + sKjYear + sStr + 1; |
| | | } |
| | | if (Add == true) |
| | | { |
| | | oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''"); |
| | | } |
| | | return sBillNo; |
| | | default: |
| | | return sBillNo; |
| | | |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 单据号 desc", "h_v_IF_ICMOBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 制单日期 desc,单据号 desc", "h_v_IF_ICMOBillList"); |
| | | } |
| | | catch (Exception e) |
| | | { |