/// <summary> /// 更新標簽顯示語言數據 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void UpdateDepartment(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string UpdateSql = ""; T_C_DEPARTMENT department; string ID = Data["ID"].ToString().Trim(); string DepartmentName = Data["DepartmentName"].ToString().Trim(); string Desc = Data["Desc"].ToString().Trim(); double SeqNo = Convert.ToDouble(Data["SeqNo"]); try { sfcdb = this.DBPools["SFCDB"].Borrow(); department = new T_C_DEPARTMENT(sfcdb, DBTYPE); Row_C_DEPARTMENT row = (Row_C_DEPARTMENT)department.GetObjByID(ID, sfcdb); row.ID = ID; row.DEPARTMENT_NAME = DepartmentName; row.DESCRIPTION = Desc; row.SEQ_NO = SeqNo; row.DESCRIPTION = Desc; row.EDIT_EMP = LoginUser.EMP_NO; row.EDIT_TIME = GetDBDateTime(); UpdateSql = row.GetUpdateString(DBTYPE); sfcdb.ExecSQL(UpdateSql); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000003"; this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void DeleteDepartment(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string DeleteSql = ""; string StrID = ""; T_C_DEPARTMENT department; // 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(); department = new T_C_DEPARTMENT(sfcdb, DBTYPE); for (int i = 0; i < ID.Count; i++) { StrID = ID[i].ToString(); Row_C_DEPARTMENT row = (Row_C_DEPARTMENT)department.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; } }
/// <summary> /// 根據用戶等級獲取 部門信息 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void GetDepartmentListByEmpLevel(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string EmpLevel = string.Empty; List <String> DetpartmentList = new List <String>(); T_C_DEPARTMENT detpartment; T_c_user DptName; try { sfcdb = this.DBPools["SFCDB"].Borrow(); detpartment = new T_C_DEPARTMENT(sfcdb, DBTYPE); DptName = new T_c_user(sfcdb, DBTYPE); if (LoginUser.EMP_LEVEL != "9" && LoginUser.EMP_LEVEL != "1") { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "MES00000028"; StationReturn.Data = ""; this.DBPools["SFCDB"].Return(sfcdb); } else { if (LoginUser.EMP_LEVEL == "9") { DetpartmentList = detpartment.GetDepartment(sfcdb); } else if (LoginUser.EMP_LEVEL == "1") { DetpartmentList = DptName.GetDptName(LoginUser.EMP_NO, sfcdb); } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "MES00000001"; StationReturn.Data = DetpartmentList; this.DBPools["SFCDB"].Return(sfcdb); } } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
public void AddDepartment(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; string InsertSql = ""; T_C_DEPARTMENT department; string DepartmentName = Data["DepartmentName"].ToString().Trim(); string Desc = Data["Desc"].ToString().Trim(); double SeqNo = Convert.ToDouble(Data["SeqNo"]); try { sfcdb = this.DBPools["SFCDB"].Borrow(); department = new T_C_DEPARTMENT(sfcdb, DBTYPE); if (department.CheckDataExist(DepartmentName, sfcdb)) { Row_C_DEPARTMENT row = (Row_C_DEPARTMENT)department.NewRow(); row.ID = department.GetNewID(BU, sfcdb); row.DEPARTMENT_NAME = DepartmentName; row.DESCRIPTION = Desc; row.SEQ_NO = SeqNo; row.EDIT_EMP = LoginUser.EMP_NO; row.EDIT_TIME = GetDBDateTime(); InsertSql = row.GetInsertString(DBTYPE); sfcdb.ExecSQL(InsertSql); StationReturn.Status = StationReturnStatusValue.Pass; 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> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void GetDepartmentList(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; List <String> DetpartmentList = new List <String>(); T_C_DEPARTMENT detpartment; try { sfcdb = this.DBPools["SFCDB"].Borrow(); detpartment = new T_C_DEPARTMENT(sfcdb, DBTYPE); DetpartmentList = detpartment.GetDepartment(sfcdb); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "MES00000001"; StationReturn.Data = DetpartmentList; 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 QueryDepartment(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_DEPARTMENT department; List <C_DEPARTMENT> InputList; string ID = Data["ID"].ToString().Trim(); string DepartmentName = Data["DepartmentName"].ToString().Trim(); try { sfcdb = this.DBPools["SFCDB"].Borrow(); department = new T_C_DEPARTMENT(sfcdb, DBTYPE); InputList = department.QueryDepartment(ID, DepartmentName, sfcdb); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; StationReturn.Data = InputList; this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }