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