public void DeleteEditPrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
string LoginUserEmp = Data["LoginUserEmp"].ToString().ToUpper();
string EditEmp = Data["EditEmp"].ToString().ToUpper();
string deleteSQL = "";
SFCDB.BeginTrain();
try
{
MESDataObject.Module.T_C_USER_PRIVILEGE tcp = new MESDataObject.Module.T_C_USER_PRIVILEGE(SFCDB, this.DBTYPE);
MESDataObject.Module.Row_C_USER_PRIVILEGE rcp = (MESDataObject.Module.Row_C_USER_PRIVILEGE)tcp.NewRow();
foreach (string item in Data["PRS"])
{
rcp = tcp.getC_PrivilegebyID(item, SFCDB);
deleteSQL += rcp.GetDeleteString(this.DBTYPE) + ";\n";
}
SFCDB.ExecSQL("Begin\n" + deleteSQL + "End;");
SFCDB.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "刪除權限成功！！！";
this.DBPools["SFCDB"].Return(SFCDB);
}
catch (Exception ex)
{
SFCDB.RollbackTrain();
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "刪除權限失！";
StationReturn.Data = ex.Message.ToString();
this.DBPools["SFCDB"].Return(SFCDB);
}
}
public void CreatUserPrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
string GEMP_NO = Data["GEMP_NO"].ToString().ToUpper();
string SEMP_NO = Data["SEMP_NO"].ToString().ToUpper();
string EMP_ID = "", P_code = "";
SFCDB.BeginTrain();
try
{
MESDataObject.Module.T_c_user GetInformation = new MESDataObject.Module.T_c_user(SFCDB, this.DBTYPE);
MESDataObject.Module.T_C_USER_PRIVILEGE tcup = new MESDataObject.Module.T_C_USER_PRIVILEGE(SFCDB, this.DBTYPE);
MESDataObject.Module.Row_C_USER_PRIVILEGE rcup = (MESDataObject.Module.Row_C_USER_PRIVILEGE)tcup.NewRow();
MESDataObject.Module.T_C_MENU tcm = new MESDataObject.Module.T_C_MENU(SFCDB, this.DBTYPE);
MESDataObject.Module.Row_C_MENU rcm = (MESDataObject.Module.Row_C_MENU)tcm.NewRow();
DataTable dt = GetInformation.SelectC_Userbyempno(SEMP_NO, SFCDB, this.DBTYPE);
EMP_ID = dt.Rows[0]["ID"].ToString();
string insql = "";
if (dt.Rows.Count > 0)
{
foreach (string item in Data["ID_ITEMS"])
{
string p_id = item.Trim('\'').Trim('\"');
rcup.ID = tcup.GetNewID(BU, SFCDB);
rcup.SYSTEM_NAME = SystemName;
rcup.USER_ID = EMP_ID;
rcup.PRIVILEGE_ID = p_id;
rcup.EDIT_EMP = GEMP_NO;
rcup.EDIT_TIME = DateTime.Now;
insql += rcup.GetInsertString(this.DBTYPE) + ";\n";
P_code += p_id + ",";
do
{
rcm = tcm.getC_MenubyID(p_id, SFCDB);
if (rcm.PARENT_CODE != "0")
{
p_id = rcm.PARENT_CODE;
if (P_code.IndexOf(rcm.PARENT_CODE) < 0 && tcup.getC_PrivilegebyIDemp(rcm.PARENT_CODE, SEMP_NO, SFCDB) == null)
{
rcup.ID = tcup.GetNewID(BU, SFCDB);
rcup.SYSTEM_NAME = SystemName;
rcup.USER_ID = EMP_ID;
rcup.PRIVILEGE_ID = rcm.PARENT_CODE;
rcup.EDIT_EMP = GEMP_NO;
rcup.EDIT_TIME = DateTime.Now;
insql += rcup.GetInsertString(this.DBTYPE) + ";\n";
P_code += rcm.PARENT_CODE + ",";
}
}
} while (rcm.PARENT_CODE != "0");
}
SFCDB.ExecSQL("Begin\n" + insql + "End;");
SFCDB.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "保存成功！！";
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "找不到用戶信息！";
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(SFCDB);
}
catch (Exception ex)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "刪權限失敗！！";
StationReturn.Data = ex.Message.ToString();
this.DBPools["SFCDB"].Return(SFCDB);
}
}
