public void GetLineByLikeSearch(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
List <C_LINE> resultline;
T_C_LINE line;
string Linevalue = Data["LINE_NAME"].ToString().Trim();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
line = new T_C_LINE(sfcdb, DBTYPE);
resultline = line.GetLineBylike(Linevalue, sfcdb);
if (resultline != null && resultline.Count > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000026";
StationReturn.Data = resultline;
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000034";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw e;
}
}
public void GetLineByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
C_LINE resultline;
T_C_LINE line;
string LineId = Data["ID"].ToString().Trim();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
line = new T_C_LINE(sfcdb, DBTYPE);
resultline = line.GetLineById(LineId, sfcdb);
if (resultline != null)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000026";
StationReturn.Data = resultline;
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara.Add("Line Id:" + LineId);
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw e;
}
}
public void DeleteLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_C_LINE line;
C_LINE checkLine;
string deleteid = "";
Newtonsoft.Json.Linq.JArray ID = (Newtonsoft.Json.Linq.JArray)Data["ID"];
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
line = new T_C_LINE(sfcdb, DBTYPE);
bool isallOK = true;
sfcdb.BeginTrain();
for (int i = 0; i < ID.Count; i++)
{
deleteid = ID[i].ToString();
checkLine = line.GetLineById(deleteid, sfcdb);
if (checkLine == null)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara.Add("Line Id:" + deleteid);
isallOK = false;
break;
}
else
{
int result = line.deleteById(deleteid, sfcdb);
if (result <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000023";
StationReturn.MessagePara.Add("Line Id:" + deleteid);
isallOK = false;
break;
}
}
}
if (isallOK)
{
sfcdb.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000001";
}
else
{
sfcdb.RollbackTrain();
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw e;
}
}
public void InitLine(OleExec db)
{
List <string> line = new List <string>();
DataTable dt = new DataTable();
T_C_LINE S = new T_C_LINE(db, DB_TYPE_ENUM.Oracle);
dt = S.GetAllLine(db);
line.Add("ALL");
foreach (DataRow dr in dt.Rows)
{
line.Add(dr["line_name"].ToString());
}
Line.ValueForUse = line;
}
/// <summary>
/// 獲取所有線體
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void GetAllLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
List <C_LINE> linelist = new List <C_LINE>();
T_C_LINE line;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
line = new T_C_LINE(sfcdb, DBTYPE);
linelist = line.GetLineData(sfcdb);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000016";
StationReturn.Data = linelist;
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 更新標簽顯示語言數據
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void UpdateLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_C_LINE line;
C_LINE newline;
string ID = Data["ID"].ToString().Trim();
string LineName = Data["LINE_NAME"].ToString().Trim();
string SectionID = Data["SECTION_ID"].ToString().Trim();
string LineCode = Data["LINE_CODE"].ToString().Trim();
string LinePcas = Data["LINE_PCAS"].ToString().Trim();
string Description = Data["DESCRIPTION"].ToString().Trim();
try
{
if (ID.Length <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("ID");
return;
}
if (LineName.Length <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("LineName");
return;
}
if (SectionID.Length <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("SectionID");
return;
}
if (LineCode.Length <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("LineCode");
return;
}
if (LinePcas.Length <= 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("LinePcas");
return;
}
sfcdb = this.DBPools["SFCDB"].Borrow();
line = new T_C_LINE(sfcdb, DBTYPE);
newline = line.GetByLineName(LineName, sfcdb);
if (newline != null && newline.ID != ID)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000008";
StationReturn.MessagePara.Add(LineName);
}
else
{
newline = new C_LINE();
newline.ID = ID;
newline.LINE_NAME = LineName;
newline.SECTION_ID = SectionID;
newline.LINE_CODE = LineCode;
newline.LINE_PCAS = LinePcas;
newline.DESCRIPTION = Description;
newline.EDIT_EMP = LoginUser.EMP_NO;
newline.EDIT_TIME = GetDBDateTime();
int result = line.Update(newline, sfcdb);
if (result > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "MES00000003";
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000025";
StationReturn.MessagePara.Add(LineName);
}
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
