public void DeleteInputRuleList(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string DeleteSql = ""; string StrID = ""; T_C_INPUT_RULE inputrule; string[] ID = Data["ID"].ToString().Split(','); try { sfcdb = this.DBPools["SFCDB"].Borrow(); inputrule = new T_C_INPUT_RULE(sfcdb, DBTYPE); sfcdb.BeginTrain(); for (int i = 0; i < ID.Length; i++) { StrID = ID[i].ToString(); Row_C_INPUT_RULE row = (Row_C_INPUT_RULE)inputrule.GetObjByID(StrID, sfcdb); DeleteSql = row.GetDeleteString(DBTYPE); sfcdb.ExecSQL(DeleteSql); } sfcdb.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000004"; this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { sfcdb.RollbackTrain(); this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
/// <summary> /// 添加標簽顯示語言數據 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void AddInputRule(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string InsertSql = ""; T_C_INPUT_RULE inputrule; string PageName = Data["PageName"].ToString().Trim(); string InputName = Data["InputName"].ToString().Trim(); string Expression = Data["Expression"].ToString().Trim(); string Description = Data["Desc"].ToString().Trim(); try { sfcdb = this.DBPools["SFCDB"].Borrow(); inputrule = new T_C_INPUT_RULE(sfcdb, DBTYPE); if (inputrule.CheckDataExist(PageName, InputName, sfcdb)) { Row_C_INPUT_RULE row = (Row_C_INPUT_RULE)inputrule.NewRow(); row.ID = inputrule.GetNewID(BU, sfcdb); row.PAGE_NAME = PageName; row.INPUT_NAME = InputName; row.EXPRESSION = Expression; row.DESCRIPTION = Description; row.EDIT_EMP = LoginUser.EMP_NO; row.SYSTEM_NAME = SystemName; row.EDIT_TIME = GetDBDateTime(); InsertSql = row.GetInsertString(DBTYPE); sfcdb.ExecSQL(InsertSql); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000002"; this.DBPools["SFCDB"].Return(sfcdb); // StationReturn.MessagePara.Add("46545645674"); } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000005"; } } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }