/// <summary> /// 终止借料 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_ZZJL_Click(object sender, EventArgs e) { try { DataRow dr = gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle); if (dr == null) { return; } int[] rownumber = gv_SJXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要取样的信息!"); return; } string strs = ""; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; if (gv_SJXX.GetRowCellValue(selectedHandle, "C_BATCH_NO").ToString() != dr["C_BATCH_NO"].ToString()) { MessageBox.Show("请选择相同的批号!"); return; } strs = strs + gv_SJXX.GetRowCellValue(selectedHandle, "C_ID").ToString() + ","; } if (!bllUpdMain.Update_BATCH_NO(dr["C_BATCH_NO"].ToString())) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = gv_SJXX.GetRowCellValue(selectedHandle, "C_ID").ToString(); string strBatchNo = gv_SJXX.GetRowCellValue(selectedHandle, "C_BATCH_NO").ToString(); DataTable dt = bllUpdMain.GetList_BatchNo(strBatchNo).Tables[0]; Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_log.C_ROLL_PRODUCT_ID = strID; mod_log.C_TYPE = "4"; mod_log.C_REMARK = gv_SJXX.GetRowCellValue(selectedHandle, "C_REMARK").ToString(); mod_log.C_EMP_ID = RV.UI.UserInfo.UserID; mod_log.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_Update_Log.Add(mod_log)) { Mod_TQC_UPDATE_MATERIAL_LOG mod = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_log.C_ROLL_PRODUCT_ID = strID; mod_log.C_TYPE = "5"; mod_log.C_REMARK = gv_SJXX.GetRowCellValue(selectedHandle, "C_REMARK").ToString(); mod_log.C_EMP_ID = RV.UI.UserInfo.UserID; mod_log.D_MOD_DT = Convert.ToDateTime(dt.Rows[0]["D_MOD_DT"]); bll_Update_Log.Add(mod_log); } } MessageBox.Show("借料申请成功!"); Query1(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 申请 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Apply_Click(object sender, EventArgs e) { try { int[] rownumber = gv_XL.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要借料的信息!"); return; } for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gv_XL.GetDataRow(rownumber[i]); Mod_TQC_UPDATE_MATERIAL mod = bll_Update.GetModel(dr["C_ID"].ToString()); mod.C_TYPE = "1"; mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_Update.Update(mod)) { Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_log.C_ROLL_PRODUCT_ID = dr["C_ROLL_PRODUCT_ID"].ToString(); mod_log.C_TYPE = "1"; mod_log.C_EMP_ID = RV.UI.UserInfo.UserID; bll_Update_Log.Add(mod_log); } } MessageBox.Show("借料成功!"); Query1(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_UPDATE_MATERIAL_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_UPDATE_MATERIAL_LOG set "); strSql.Append("C_ROLL_PRODUCT_ID=:C_ROLL_PRODUCT_ID,"); strSql.Append("C_TYPE=:C_TYPE,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("N_WGT=:N_WGT,"); strSql.Append("N_WGT_DIFFERENCE=:N_WGT_DIFFERENCE,"); strSql.Append("C_SFHG=:C_SFHG"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ROLL_PRODUCT_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":N_WGT", OracleDbType.Decimal, 6), new OracleParameter(":N_WGT_DIFFERENCE", OracleDbType.Decimal, 6), new OracleParameter(":C_SFHG", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_ROLL_PRODUCT_ID; parameters[1].Value = model.C_TYPE; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.N_WGT; parameters[7].Value = model.N_WGT_DIFFERENCE; parameters[8].Value = model.C_SFHG; parameters[9].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_UPDATE_MATERIAL_LOG DataRowToModel(DataRow row) { Mod_TQC_UPDATE_MATERIAL_LOG model = new Mod_TQC_UPDATE_MATERIAL_LOG(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_ROLL_PRODUCT_ID"] != null) { model.C_ROLL_PRODUCT_ID = row["C_ROLL_PRODUCT_ID"].ToString(); } if (row["C_TYPE"] != null) { model.C_TYPE = row["C_TYPE"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } if (row["N_WGT"] != null && row["N_WGT"].ToString() != "") { model.N_WGT = decimal.Parse(row["N_WGT"].ToString()); } if (row["N_WGT_DIFFERENCE"] != null && row["N_WGT_DIFFERENCE"].ToString() != "") { model.N_WGT_DIFFERENCE = decimal.Parse(row["N_WGT_DIFFERENCE"].ToString()); } if (row["C_SFHG"] != null) { model.C_SFHG = row["C_SFHG"].ToString(); } } return(model); }
/// <summary> /// 借料 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_JL_Click(object sender, EventArgs e) { try { int[] rownumber = gv_SJXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要申请的!"); return; } string strs = ""; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; strs = strs + gv_SJXX.GetRowCellValue(selectedHandle, "C_ID").ToString() + ","; } int obj = bll.TransaTSXX(strs, "0", "待修料", "", ""); if (obj == 1) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = gv_SJXX.GetRowCellValue(selectedHandle, "C_ID").ToString(); string strBatchNo = gv_SJXX.GetRowCellValue(selectedHandle, "C_BATCH_NO").ToString(); DataTable dt = bllUpdMain.GetList_BatchNo(strBatchNo).Tables[0]; Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_log.C_ROLL_PRODUCT_ID = strID; mod_log.C_TYPE = "5"; mod_log.C_REMARK = gv_SJXX.GetRowCellValue(selectedHandle, "C_REMARK").ToString(); mod_log.C_EMP_ID = RV.UI.UserInfo.UserID; mod_log.D_MOD_DT = Convert.ToDateTime(dt.Rows[0]["D_MOD_DT"]); bll_Update_Log.Add(mod_log); } MessageBox.Show("借料申请成功!"); Query1(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add_Trans(Mod_TQC_UPDATE_MATERIAL_LOG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_UPDATE_MATERIAL_LOG("); strSql.Append("C_ROLL_PRODUCT_ID,C_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_WGT,N_WGT_DIFFERENCE,C_SFHG)"); strSql.Append(" values ("); strSql.Append(":C_ROLL_PRODUCT_ID,:C_TYPE,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT,:N_WGT,:N_WGT_DIFFERENCE,:C_SFHG)"); OracleParameter[] parameters = { new OracleParameter(":C_ROLL_PRODUCT_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":N_WGT", OracleDbType.Decimal, 6), new OracleParameter(":N_WGT_DIFFERENCE", OracleDbType.Decimal, 6), new OracleParameter(":C_SFHG", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_ROLL_PRODUCT_ID; parameters[1].Value = model.C_TYPE; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.N_WGT; parameters[7].Value = model.N_WGT_DIFFERENCE; parameters[8].Value = model.C_SFHG; int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_UPDATE_MATERIAL_LOG GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_ROLL_PRODUCT_ID,C_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_WGT,N_WGT_DIFFERENCE,C_SFHG from TQC_UPDATE_MATERIAL_LOG "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_UPDATE_MATERIAL_LOG model = new Mod_TQC_UPDATE_MATERIAL_LOG(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_UPDATE_MATERIAL_LOG model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_UPDATE_MATERIAL_LOG model) { return(dal.Add(model)); }
private void str() { try { int[] rownumber = gv_XL.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要还料的信息!"); return; } for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gv_XL.GetDataRow(rownumber[i]); Mod_TQC_UPDATE_MATERIAL mod = bll_Update.GetModel(dr["C_ID"].ToString()); Mod_TRC_ROLL_PRODCUT mod_roll = bll_roll_product.GetModel(dr["C_ROLL_PRODUCT_ID"].ToString()); decimal? wgt = mod_roll.N_WGT; DataTable dt = bll_Interface_FR.Get_TM_XL_List(dr["C_BATCH_NO"].ToString(), dr["C_TICK_NO"].ToString()).Tables[0]; if (dt.Rows.Count <= 0) { MessageBox.Show("条码库存查不到该批次!"); return; } mod.C_TYPE = "2"; mod.N_WGT = wgt; mod.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]); if (mod.N_WGT_DIFFERENCE == 0) { if (DialogResult.OK != MessageBox.Show("批号:'" + dr["C_BATCH_NO"].ToString() + "',钩号:'" + dr["C_TICK_NO"].ToString() + "',条码重量未修改,是否继续还料", "提示", MessageBoxButtons.OKCancel)) { break; } } mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_Update.Update(mod)) { Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_roll.N_WGT = Convert.ToDecimal(dt.Rows[0]["ZL"]); mod_roll.C_EMP_ID = RV.UI.UserInfo.UserID; mod_roll.D_MOD_DT = RV.UI.ServerTime.timeNow(); bll_roll_product.Update(mod_roll); mod_log.N_WGT = wgt; mod_log.N_WGT_DIFFERENCE = wgt - mod_roll.N_WGT; mod_log.C_ROLL_PRODUCT_ID = dr["C_ROLL_PRODUCT_ID"].ToString(); mod_log.C_TYPE = "2"; mod_log.C_EMP_ID = RV.UI.UserInfo.UserID; bll_Update_Log.Add(mod_log); } } MessageBox.Show("还料成功!"); Query1(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 修料 /// </summary> /// <param name="strs">线材实绩主键</param> /// <param name="Type">修料状态</param> /// <param name="PCINFO">特殊信息</param> /// <returns></returns> public int TransaTSXX(string strs, string Type, string PCINFO, string rollID, string strSFHG) { try { Dal_TRC_ROLL_PRODCUT dalTrcRollProduct = new Dal_TRC_ROLL_PRODCUT(); Dal_TQC_UPDATE_MATERIAL dal_Update = new Dal_TQC_UPDATE_MATERIAL(); Dal_TQC_UPDATE_MATERIAL_LOG dal_update_log = new Dal_TQC_UPDATE_MATERIAL_LOG(); Dal_TQC_UPD_MATERIAL_MAIN dalUpdMain = new Dal_TQC_UPD_MATERIAL_MAIN(); Dal_Interface_FR dalInterface_FR = new Dal_Interface_FR(); Dal_TQC_SPECIFIC_CONTENT_LOG dalLog = new Dal_TQC_SPECIFIC_CONTENT_LOG(); TransactionHelper.BeginTransaction(); TransactionHelper_SQL.BeginTransaction(); string strUserID = RV.UI.UserInfo.UserID; DateTime dTime = RV.UI.ServerTime.timeNow(); string[] strs_Product_ID = strs.Substring(0, strs.Length - 1).Split(','); string[] strs_ID = null; if (rollID != "") { strs_ID = rollID.Substring(0, rollID.Length - 1).Split(','); } if (strs_Product_ID.Length == 0) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } for (int i = 0; i < strs_Product_ID.Length; i++) { Mod_TRC_ROLL_PRODCUT modProduct = dalTrcRollProduct.GetModel(strs_Product_ID[i]); Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG(); decimal? wgt = modProduct.N_WGT; DataTable dt = dalInterface_FR.Get_TM_XL_List(modProduct.C_BATCH_NO, modProduct.C_TICK_NO).Tables[0]; if (dt == null) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } if (rollID == "") { Mod_TQC_UPDATE_MATERIAL mod = new Mod_TQC_UPDATE_MATERIAL(); mod.C_ROLL_PRODUCT_ID = modProduct.C_ID; mod.C_TYPE = Type; mod.C_EMP_ID = strUserID; mod.C_SFHG = strSFHG; mod_log.C_TYPE = mod.C_TYPE; dalUpdMain.Update_BATCH_NO(modProduct.C_BATCH_NO); if (!dal_Update.Add_Trans(mod)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } } else { Mod_TQC_UPDATE_MATERIAL mod = dal_Update.GetModel(strs_ID[i]); if (Type == "2") { if (mod.C_TYPE == "3") { mod.C_TYPE = "6"; PCINFO = "0"; Mod_TQC_UPDATE_MATERIAL_LOG mod_logs = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_logs.C_TYPE = "2"; mod_logs.N_WGT = wgt; mod_logs.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]); mod_logs.C_SFHG = mod.C_SFHG; mod_logs.C_ROLL_PRODUCT_ID = modProduct.C_ID; mod_logs.C_EMP_ID = strUserID; if (!dal_update_log.Add_Trans(mod_logs)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } } else { mod.C_TYPE = Type; } } if (Type == "3") { if (mod.C_TYPE == "2") { mod.C_TYPE = "6"; PCINFO = "0"; Mod_TQC_UPDATE_MATERIAL_LOG mod_logs = new Mod_TQC_UPDATE_MATERIAL_LOG(); mod_logs.C_TYPE = "3"; mod_logs.N_WGT = wgt; mod_logs.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]); mod_logs.C_SFHG = mod.C_SFHG; mod_logs.C_ROLL_PRODUCT_ID = modProduct.C_ID; mod_logs.C_EMP_ID = strUserID; if (!dal_update_log.Add_Trans(mod_logs)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } } else { mod.C_TYPE = Type; } } mod.C_EMP_ID = strUserID; mod.D_MOD_DT = dTime; mod.N_WGT = wgt; mod.C_SFHG = strSFHG; mod.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]); mod_log.C_TYPE = mod.C_TYPE; mod_log.N_WGT = wgt; mod_log.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]); mod_log.C_SFHG = mod.C_SFHG; modProduct.N_WGT = Convert.ToDecimal(dt.Rows[0]["ZL"]); if (!dal_Update.Update_Trans(mod)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } } if (PCINFO == "0") { if (modProduct.C_PCINFO.Contains("待修料;")) { modProduct.C_PCINFO = modProduct.C_PCINFO.Replace("待修料;", ""); } } else { if (modProduct.C_PCINFO == "") { modProduct.C_PCINFO = PCINFO + ";"; } else if (modProduct.C_PCINFO.Contains("待修料")) { modProduct.C_PCINFO = modProduct.C_PCINFO; } else { modProduct.C_PCINFO = modProduct.C_PCINFO + PCINFO + ";"; } } modProduct.C_EMP_ID = strUserID; modProduct.C_PLANT_DESC = dTime.ToString(); if (!dalTrcRollProduct.Update_Trans_XL(modProduct)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } mod_log.C_ROLL_PRODUCT_ID = modProduct.C_ID; mod_log.C_EMP_ID = strUserID; if (!dal_update_log.Add_Trans(mod_log)) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } string strDJ = ""; if (string.IsNullOrEmpty(modProduct.C_JUDGE_LEV_ZH)) { strDJ = "DP"; } else { strDJ = modProduct.C_JUDGE_LEV_ZH; } string sql = ""; sql += "insert into ReZJB_GPD(Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,ProduceData,PCInfo,vfree0,vfree3,GPTYPE,ZJBstatus,CAPPK,vfree1,vfree2,insertts) values('" + modProduct.C_BARCODE + "','" + modProduct.C_TRC_ROLL_MAIN_ID + "','" + modProduct.C_LINEWH_CODE + "','" + modProduct.C_LINEWH_LOC_CODE + "','" + modProduct.C_BATCH_NO + "','" + modProduct.C_MAT_CODE + "','" + modProduct.C_MAT_DESC + "','" + strDJ + "','" + modProduct.C_STL_GRD + "','" + modProduct.C_SPEC + "mm','" + modProduct.C_GROUP + "','" + modProduct.C_TICK_NO + "','" + modProduct.N_WGT + "','" + modProduct.C_STD_CODE + "','" + modProduct.D_RKRQ + "','" + modProduct.C_MOVE_DESC + "','" + modProduct.C_RKRY + "','" + modProduct.D_WEIGHT_DT + "','" + modProduct.D_PRODUCE_DATE + "','" + modProduct.C_PCINFO + "','" + modProduct.C_STOVE + "','" + modProduct.C_BZYQ + "','','0','" + modProduct.C_ID + "','" + modProduct.C_ZYX1 + "','" + modProduct.C_ZYX2 + "','" + RV.UI.ServerTime.timeNow() + "')"; if (TransactionHelper_SQL.ExecuteSql(sql) == 0) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } else { if (rollID != "") { Mod_TQC_UPDATE_MATERIAL mod = dal_Update.GetModel(strs_ID[i]); if (Type == "2") { if (mod.C_TYPE == "3") { Mod_TQC_SPECIFIC_CONTENT_LOG modLog = new Mod_TQC_SPECIFIC_CONTENT_LOG(); modLog.C_BATCH_NO = modProduct.C_BATCH_NO; modLog.C_CONTENT = "取消待修料"; modLog.C_TICK_NO = modProduct.C_TICK_NO; modLog.C_EMP_ID = strUserID; if (!dalLog.Add_Trans(modLog)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return(0); } } } if (Type == "3") { if (mod.C_TYPE == "2") { Mod_TQC_SPECIFIC_CONTENT_LOG modLog = new Mod_TQC_SPECIFIC_CONTENT_LOG(); modLog.C_BATCH_NO = modProduct.C_BATCH_NO; modLog.C_CONTENT = "取消待修料"; modLog.C_TICK_NO = modProduct.C_TICK_NO; modLog.C_EMP_ID = strUserID; if (!dalLog.Add_Trans(modLog)) { TransactionHelper.RollBack(); TransactionHelper_SQL.RollBack(); return(0); } } } } } } TransactionHelper_SQL.Commit(); TransactionHelper.Commit(); return(1); } catch (Exception ex) { TransactionHelper_SQL.RollBack(); TransactionHelper.RollBack(); return(0); } }