| | |
| | | |
| | | private void cmdHSaveBill_Click(object sender, EventArgs e) |
| | | { |
| | | |
| | | Display(); |
| | | } |
| | | |
| | |
| | | long HTMaterID = 0; |
| | | HTMaterID = ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HMaterID")].Value); |
| | | string sPackStr = "ZXM" + HYear + HPeriod + HDay + HTMaterID; //å¤ç®±ç åç¼ |
| | | |
| | | |
| | | //è·åå¤çè¿çæ¥æè·ä»å¤©å·®å 天 ç¶åå å 个+å· |
| | | TimeSpan HCY = Convert.ToDateTime(HPrdDate) - Convert.ToDateTime(DateTime.Now.ToString()); |
| | | int a = 1; |
| | | while (a <= HCY.Days) //å½a å°äº å·®å¼å¤©æ° 循ç¯å ä¸ + å· |
| | | { |
| | | HPrdDate = HPrdDate + "+"; |
| | | a = a + 1; |
| | | } |
| | | DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); |
| | | Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | DataSet DSet3 = oCn.RunProcReturn("select * from Gy_FactoryDayOff Where HFactoryDayOffDate='" + HDate1.ToString() + "'", "Gy_FactoryDayOff", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DSet3 == null || DSet3.Tables[0].Rows.Count == 0) |
| | | { |
| | | sPackBarCode = sPackStr + TTM_LSH.ToString() ; |
| | | } |
| | | else |
| | | { |
| | | sPackBarCode = sPackStr + TTM_LSH.ToString() + "+"; |
| | | } |
| | | |
| | | |
| | | sPackBarCode = sPackStr + TTM_LSH.ToString(); |
| | | //DataSet DSet3 = oCn.RunProcReturn("select * from Gy_FactoryDayOff Where HFactoryDayOffDate='" + HDate1.ToString() + "'", "Gy_FactoryDayOff", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //if (DSet3 == null || DSet3.Tables[0].Rows.Count == 0) |
| | | //{ |
| | | // sPackBarCode = sPackStr + TTM_LSH.ToString() ; |
| | | //} |
| | | //else |
| | | //{ |
| | | // sPackBarCode = sPackStr + TTM_LSH.ToString() + "+"; |
| | | //} |
| | | |
| | | |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sPackStr + "'"); |
| | | |
| | | |
| | |
| | | HJT = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("设å¤")].Value); |
| | | HXH = HYear + HPeriod + HDay + HBC + HJT + HMaterNumber; |
| | | Ds99 = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HXH + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH3 = ClsPub.isInt(Ds99.Tables[0].Rows[0][0]); |
| | | LSH3 = ClsPub.isInt(Ds99.Tables[0].Rows[0][0]) + 1; |
| | | LSH4 = LSH3.ToString(); |
| | | |
| | | |