| | |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | oCN.BeginTran(); |
| | | |
| | | ////获取系统参数 |
| | | //string Ret = ""; |
| | | //if (oSystemParameter.ShowBill(ref Ret)) |
| | | //{ |
| | | // //判断是否只能删除自己生成的条码 |
| | | // if (oSystemParameter.omodel.BarCode_DeleterAndMakerllustSame != "龙山汽配") //系统参数 |
| | | // { |
| | | |
| | | // } |
| | | //} |
| | | |
| | | oCN.RunProc("Delete from Gy_BarCodeBill Where HItemID in (" + HInterID + ")"); |
| | | |
| | | //写入系统日志 |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 1000 * from h_v_Gy_RoutingBillList order by hmainid desc", "h_v_Gy_RoutingBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList order by hmainid desc", "h_v_Gy_RoutingBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; |
| | | string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc,cast(工序号 as int)"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); |
| | | } |
| | |
| | | "-", |
| | | num27.ToString() |
| | | })); |
| | | string text20 = sBarCodeNew.Remove(0, 16); |
| | | string text21 = text20.Remove(text20.Length - 9, 9); |
| | | ClsCN clsCN3 = new ClsCN(); |
| | | string text20 = sBarCodeNew.Remove(0, 16); //SAE1300100230309 2303704250308010 |
| | | string text21 = text20.Remove(text20.Length - 9 , 9); //SAE1300100230309 2303704 250308010 |
| | | ClsCN clsCN3 = new ClsCN(); |
| | | DataSet dataSet13 = clsCN3.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + str6 + "' and huseorgid = " + HOrgID.ToString(), "Gy_Material"); |
| | | long num28 = ClsPub.isLong(dataSet13.Tables[0].Rows[0]["HItemID"]); |
| | | string text22 = ClsPub.isStrNull(dataSet13.Tables[0].Rows[0]["HName"]); |