public void DeleteInput(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string DeleteSql = "";
string StrID = "";
T_C_Input input;
// string[] ID = Newtonsoft.Json.Linq.JArray(Data["ID"].);
Newtonsoft.Json.Linq.JArray ID = (Newtonsoft.Json.Linq.JArray)Data["ID"];
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.BeginTrain();
input = new T_C_Input(sfcdb, DBTYPE);
for (int i = 0; i < ID.Count; i++)
{
StrID = ID[i].ToString();
Row_C_Input row = (Row_C_Input)input.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)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void AddInput(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string InsertSql = "";
T_C_Input input;
string InputName = Data["InputName"].ToString().Trim();
string DisplayType = Data["DisplayType"].ToString().Trim();
string DataSourceApi = Data["DataSourceApi"].ToString().Trim();
string DataSourceApiPara = Data["DataSourceApiPara"].ToString();
string RefreshType = Data["RefreshType"].ToString();
string Desc = Data["Desc"].ToString();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
input = new T_C_Input(sfcdb, DBTYPE);
if (input.CheckDataExist(InputName, sfcdb))
{
Row_C_Input row = (Row_C_Input)input.NewRow();
row.ID = input.GetNewID(BU, sfcdb);
row.INPUT_NAME = InputName;
row.DISPLAY_TYPE = DisplayType;
row.DATA_SOURCE_API = DataSourceApi;
row.DATA_SOURCE_API_PARA = DataSourceApiPara;
row.REFRESH_TYPE = RefreshType;
row.DESCRIPTION = Desc;
row.EDIT_EMP = LoginUser.EMP_NO;
row.EDIT_TIME = GetDBDateTime();
InsertSql = row.GetInsertString(DBTYPE);
sfcdb.ExecSQL(InsertSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = row.ID;
StationReturn.MessageCode = "MES00000002";
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000005";
}
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 初始化方法
/// </summary>
public virtual void Init(string _DisplayName, string _Line, string _BU, OleExec DB)
{
Inputs.Clear();
SFCDB = DB;
Line = _Line;
BU = _BU;
//加載Station Input
try
{
T_R_Station T = new T_R_Station(SFCDB, DBType);
Row_R_Station R = T.GetRowByDisplayName(_DisplayName, SFCDB);
_StationInfo = R.GetDataObject();
T_R_Station_Input T_I = new T_R_Station_Input(SFCDB, DBType);
List <Row_R_Station_Input> R_Inputs = T_I.GetRowsByStationID(_StationInfo.ID, SFCDB);
T_C_Input T_INPUT = new T_C_Input(SFCDB, DBType);
for (int i = 0; i < R_Inputs.Count; i++)
{
Row_C_Input R_C_I = (Row_C_Input)T_INPUT.GetObjByID(R_Inputs[i].INPUT_ID, SFCDB);
C_Input C_Input = R_C_I.GetDataObject();
MESStationInput Input = new MESStationInput();
Input.Station = this;
Input.Init(C_Input, R_Inputs[i].GetDataObject());
Inputs.Add(Input);
}
//加載Station OutPut
T_R_Station_Output TRSO = new T_R_Station_Output(SFCDB, DBType);
List <Row_R_Station_Output> R_Outputs = TRSO.GetStationOutputByStationID(_StationInfo.ID, SFCDB);
ROutputs = R_Outputs;
for (int i = 0; i < R_Outputs.Count; i++)
{
R_Station_Output o = R_Outputs[i].GetDataObject();
DisplayOutPut o1 = new DisplayOutPut();
o1.DisplayType = o.DISPLAY_TYPE;
o1.Value = "";
o1.Name = o.NAME;
StationOutputs.Add(o);
DisplayOutput.Add(o1);
}
}
catch (Exception ex)
{
throw ex;
}
if (_StationInfo.FAIL_STATION_ID != null && _StationInfo.FAIL_STATION_ID.ToString().Trim() != "")
{
if (this.FailStation != null)
{
this.FailStation.StationMessages.Clear();
this.NextInput = null;
}
else
{
this.FailStation = new MESStationBase();
}
this.FailStation.LoginUser = LoginUser;
this.FailStation.Init(_StationInfo.FAIL_STATION_ID, _Line, _BU, DB);
}
}
