/// <summary>
/// 刪除角色ID信息
/// </summary>
public void DeleteRole(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
MESDataObject.Module.T_C_ROLE GetRoleInformation = new MESDataObject.Module.T_C_ROLE(SFCDB, DB_TYPE_ENUM.Oracle);
MESDataObject.Module.Row_C_ROLE RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.NewRow();
string EMP_NO = Data["EMP_NO"].ToString();
RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.SELECTC_Rolebyrolename(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle);
if (RoleRow != null)
{
string strRet = SFCDB.ExecSQL(RoleRow.GetDeleteString(DB_TYPE_ENUM.Oracle));
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "成功刪除角色信息！";
StationReturn.Data = "";
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "無此用戶信息！";
}
this.DBPools["SFCDB"].Return(SFCDB);
}
/// <summary>
/// 更新角色ID信息
/// </summary>
public void UpdateRole(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
MESDataObject.Module.T_C_ROLE GetRoleInformation = new MESDataObject.Module.T_C_ROLE(SFCDB, DB_TYPE_ENUM.Oracle);
MESDataObject.Module.Row_C_ROLE RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.NewRow();
string ROLE_NAME = Data["ROLE_NAME"].ToString();
string ROLE_DESC = Data["ROLE_DESC"].ToString();
RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.SELECTC_Rolebyrolename(ROLE_NAME, SFCDB, DB_TYPE_ENUM.Oracle);
if (RoleRow != null)
{
RoleRow.ROLE_DESC = Data["ROLE_DESC"].ToString();
RoleRow.EDIT_EMP = Data["EDIT_EMP"].ToString();
RoleRow.EDIT_TIME = DateTime.Now;
string strRet = SFCDB.ExecSQL(RoleRow.GetUpdateString(DB_TYPE_ENUM.Oracle));
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "成功更新角色信息！";
StationReturn.Data = "";
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "無此角色信息！";
}
this.DBPools["SFCDB"].Return(SFCDB);
}
