public void DeleteStationActionPara(String ID, OleExec sfcdb)
{
string DeleteSql = "";
T_R_Station_Action_Para stationactionpara;
try
{
stationactionpara = new T_R_Station_Action_Para(sfcdb, DBTYPE);
if (stationactionpara.CheckDataExistByID(ID, sfcdb))
{
Row_R_Station_Action_Para row = (Row_R_Station_Action_Para)stationactionpara.GetObjByID(ID, sfcdb);
DeleteSql = row.GetDeleteString(DBTYPE);
sfcdb.ExecSQL(DeleteSql);
}
}
catch (Exception e)
{
// this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void AddStationActionPara(Newtonsoft.Json.Linq.JToken Data, OleExec sfcdb)
{
//OleExec sfcdb = null;
string InsertSql = "";
T_R_Station_Action_Para input;
string ID = Data["ID"].ToString();
string RInputActionID = Data["R_INPUT_ACTION_ID"].ToString();
string RStationActionID = Data["R_STATION_ACTION_ID"].ToString();
double SeqNo = Convert.ToDouble(Data["SEQ_NO"]);
string SessionType = Data["SESSION_TYPE"].ToString();
string SessionValue = Data["SESSION_KEY"].ToString();
string StrValue = Data["VALUE"].ToString();
try
{
input = new T_R_Station_Action_Para(sfcdb, DBTYPE);
DeleteStationActionPara(ID, sfcdb);
Row_R_Station_Action_Para row = (Row_R_Station_Action_Para)input.NewRow();
row.ID = ID;
row.R_STATION_ACTION_ID = RStationActionID;
row.R_INPUT_ACTION_ID = RInputActionID;
row.SEQ_NO = SeqNo;
row.SESSION_TYPE = SessionType;
row.SESSION_KEY = SessionValue;
row.VALUE = StrValue;
row.EDIT_EMP = LoginUser.EMP_NO;
row.EDIT_TIME = GetDBDateTime();
InsertSql = row.GetInsertString(DBTYPE);
sfcdb.ExecSQL(InsertSql);
}
catch (Exception e)
{
// this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
