public void AddInput(Newtonsoft.Json.Linq.JToken Data, OleExec sfcdb) { string InsertSql = ""; T_R_Station_Input input; string ID = Data["ID"].ToString(); string StationID = Data["STATION_ID"].ToString(); string InputID = Data["INPUT_ID"].ToString(); double SeqNo = Convert.ToDouble(Data["SEQ_NO"]); string Rlinput = Data["REMEMBER_LAST_INPUT"].ToString(); double ScanFlag = Convert.ToDouble(Data["SCAN_FLAG"]); string DName = Data["DISPLAY_NAME"].ToString(); try { input = new T_R_Station_Input(sfcdb, DBTYPE); DeleteStationInput(ID, sfcdb); Row_R_Station_Input row = (Row_R_Station_Input)input.NewRow(); row.ID = ID; row.STATION_ID = StationID; row.INPUT_ID = InputID; row.SEQ_NO = SeqNo; row.SCAN_FLAG = ScanFlag; row.DISPLAY_NAME = DName; row.REMEMBER_LAST_INPUT = Rlinput; 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; } }
public void DeleteStationInput(String ID, OleExec sfcdb) { string DeleteSql = ""; T_R_Station_Input stationaction; try { stationaction = new T_R_Station_Input(sfcdb, DBTYPE); if (stationaction.CheckDataExistByID(ID, sfcdb))//存在就刪除 { Row_R_Station_Input row = (Row_R_Station_Input)stationaction.GetObjByID(ID, sfcdb); DeleteSql = row.GetDeleteString(DBTYPE); sfcdb.ExecSQL(DeleteSql); } } catch (Exception e) { throw e; } }