| | |
| | | string HMaterShortNumber = ls[0].HMaterShortNumber; |
| | | string HMaterName = ls[0].HMaterName; |
| | | //供应商 |
| | | long HSupID= ls[0].HSupID; |
| | | string HSupName= ls[0].HSupName; |
| | | long HSupID = lsmain[0].HSupID; |
| | | string HMaker= ls[0].HMaker; |
| | | DateTime HMakeDate= ls[0].HMakeDate; |
| | | double HQty= ls[0].HQty; //本次生成条码数量 |
| | |
| | | DataSet Ds; |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | oCn.BeginTran(); |
| | | Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH"); |
| | | //Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH"); |
| | | Ds = oCn.RunProcReturn("exec GetLSH '" + HSupID+"_"+ HMaterID+"_" + DateTime.Today+ "'", "GetLSH"); |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | #endregion |
| | | |
| | |
| | | "1, 1, '1', '" + HSourceBillType + "', '1', '" + |
| | | HKFDate + "', '" + HKFDQDate + "', " + HISKFPERIOD + ")"; |
| | | LogService.Write("生成条码: " + sql); |
| | | oCn.RunProc(sql); |
| | | oCn.RunProc("exec setLSH '" + DateTime.Today + "'"); |
| | | oCn.RunProc(sql); |
| | | oCn.RunProc("exec setLSH '" + HSupID + "_" + HMaterID + "_" + DateTime.Today + "'"); |
| | | virtualCount++; |
| | | } |
| | | |