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