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;
}
}
