public void UpdateMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
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();
string UpdateSQL = "";
SFCDB.BeginTrain();
try
{
string m_name = Data["MENU_NAME"].ToString();
string m_desc = Data["MENU_DESC"].ToString();
string m_emp = Data["EDIT_EMP"].ToString();
string m_id = Data["ID"].ToString();
rcm = tcm.getC_MenubyID(m_id, SFCDB);
rcm.MENU_NAME = m_name;
rcm.PAGE_PATH = Data["PAGE_PATH"].ToString();
rcm.STYLE_NAME = Data["STYLE_NAME"].ToString();
rcm.CLASS_NAME = Data["CLASS_NAME"].ToString();
rcm.LANGUAGE_ID = Data["LANGUAGE_ID"].ToString();
rcm.MENU_DESC = m_desc;
rcm.EDIT_TIME = DateTime.Now;
rcm.EDIT_EMP = m_emp;
UpdateSQL += rcm.GetUpdateString(this.DBTYPE) + ";\n";
MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE);
MESDataObject.Module.Row_C_PRIVILEGE rcp = (MESDataObject.Module.Row_C_PRIVILEGE)tcp.NewRow();
rcp = tcp.getC_PrivilegebyMenuID(m_id, SFCDB);
rcp.PRIVILEGE_NAME = m_name;
rcp.PRIVILEGE_DESC = m_desc;
rcp.EDIT_TIME = DateTime.Now;
rcp.EDIT_EMP = m_emp;
UpdateSQL += rcp.GetUpdateString(this.DBTYPE) + ";\n";
SFCDB.ExecSQL("Begin\n" + UpdateSQL + "End;");
SFCDB.CommitTrain();
this.DBPools["SFCDB"].Return(SFCDB);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "编辑菜單成功！！";
}
catch (Exception ex)
{
SFCDB.RollbackTrain();
this.DBPools["SFCDB"].Return(SFCDB);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "编辑菜單失敗！！";
StationReturn.Data = ex.Message.ToString();
}
}
public void DeletetMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow();
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();
string ID = Data["ID"].ToString();
string deleteSQL = "";
SFCDB.BeginTrain();
try
{
if (tcm.Check_PARENT(ID, SFCDB))
{
rcm = tcm.getC_MenubyID(ID, SFCDB);
deleteSQL += rcm.GetDeleteString(this.DBTYPE) + ";\n";
MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE);
MESDataObject.Module.Row_C_PRIVILEGE rcp = (MESDataObject.Module.Row_C_PRIVILEGE)tcp.NewRow();
rcp = tcp.getC_PrivilegebyMenuID(ID, SFCDB);
deleteSQL += rcp.GetDeleteString(this.DBTYPE) + ";\n";
SFCDB.ExecSQL("Begin\n" + deleteSQL + "End;");
SFCDB.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "刪除菜單及其權限成功！！！";
StationReturn.Data = ID;
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "要刪除的菜單存在子菜單！！不可刪除！";
}
this.DBPools["SFCDB"].Return(SFCDB);
}
catch (Exception ex)
{
SFCDB.RollbackTrain();
this.DBPools["SFCDB"].Return(SFCDB);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "刪除菜單失敗！";
StationReturn.Data = ex.Message.ToString();
}
}
