/// <summary>
/// 根據工號檢查密碼是否正確
/// </summary>
/// <param name="Station"></param>
/// <param name="Input"></param>
/// <param name="Paras"></param>
public static void EmpPasswordChecker(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <R_Station_Action_Para> Paras)
{
if (Paras.Count != 2)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000050"));
}
MESStationSession sessionEmp = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY);
if (sessionEmp == null || sessionEmp.Value == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE }));
}
MESStationSession sessionPwd = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY);
if (sessionPwd == null || sessionPwd.Value == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[1].SESSION_TYPE }));
}
T_c_user t_c_user = new T_c_user(Station.SFCDB, Station.DBType);
Row_c_user rowUser = t_c_user.getC_Userbyempno(sessionEmp.Value.ToString(), Station.SFCDB, Station.DBType);
if (rowUser == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180620163103", new string[] { sessionEmp.Value.ToString() }));
}
if (!rowUser.EMP_PASSWORD.Equals(sessionPwd.Value.ToString()))
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180813154717", new string[] { sessionEmp.Value.ToString() }));
}
}
/// <summary>
/// 刪除用戶信息
/// </summary>
public void DeleteInformation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string DeleteSql = "";
string strid = "";
T_c_user DeleteInformation;
Newtonsoft.Json.Linq.JArray ID = (Newtonsoft.Json.Linq.JArray)Data["ID"];
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.BeginTrain();
DeleteInformation = new T_c_user(sfcdb, DBTYPE);
for (int i = 0; i < ID.Count; i++)
{
strid = ID[i].ToString();
Row_c_user row = (Row_c_user)DeleteInformation.GetObjByID(strid, sfcdb);
DeleteSql += row.GetDeleteString(DBTYPE) + ";\n";
}
DeleteSql = "begin\n" + DeleteSql + "end;";
sfcdb.ExecSQL(DeleteSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
sfcdb.CommitTrain();
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
sfcdb.RollbackTrain();
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 根据页面传进来的每页数据行数加載出最大页数
/// </summary>
public void GetMaxPage(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_c_user LoadUsetInfo;
List <c_user_model> LoadUsetInfolsit = new List <c_user_model>();
string r = Data["PageRow"].ToString() == "" ? "10" : Data["PageRow"].ToString();
string emp_no = Data["Emp_No"].ToString();
int PageRow = Convert.ToInt32(r == "0" ? "10" : r);
int MaxPage;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
LoadUsetInfo = new T_c_user(sfcdb, DBTYPE);
MaxPage = LoadUsetInfo.CheckMaxPage(PageRow, emp_no, sfcdb);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "获取页数成功";
StationReturn.Data = MaxPage;
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 取回用戶密碼
/// </summary>
public void GetPassword(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_c_user GetPassword;
string EMP_NO = Data["EMP_NO"].ToString();
Dictionary <string, string> dic = new Dictionary <string, string>();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
GetPassword = new T_c_user(sfcdb, DBTYPE);
Row_c_user row = (Row_c_user)GetPassword.NewRow();
row = GetPassword.getC_Userbyempno(EMP_NO, sfcdb, this.DBTYPE);
if (row != null)
{
///缺發送EMAIL 或者短信功能
dic.Add("EMP_PASSWORD", row.EMP_PASSWORD.ToString());
StationReturn.MessageCode = "MES00000015";
StationReturn.Data = dic;
}
StationReturn.Status = StationReturnStatusValue.Pass;
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 登錄API
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void Login(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
string EMP_NO = Data["EMP_NO"].ToString();
string PWD = Data["Password"].ToString();
string BU_NAME = Data["BU_NAME"].ToString();
DataSet res = new DataSet();
Language = Data["Language"].ToString();
MESReturnMessage.Language = Language;
LoginReturn lr = new LoginReturn();
OleExec SFCDB = _DBPools["SFCDB"].Borrow();
T_c_user GetLoginUser = new T_c_user(SFCDB, this.DBTYPE);
Row_c_user rcu = (Row_c_user)GetLoginUser.NewRow();
rcu = GetLoginUser.getC_Userbyempno(EMP_NO, SFCDB, this.DBTYPE);
if (rcu == null)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000010";
_DBPools["SFCDB"].Return(SFCDB);
return;
}
c_user_info user_info = new c_user_info();
user_info = GetLoginUser.GetLoginUser(EMP_NO, SFCDB);
MESPubLab.MESStation.LogicObject.User lu = new MESPubLab.MESStation.LogicObject.User();
if (PWD == rcu.EMP_PASSWORD)
{
lu.ID = user_info.ID;
lu.FACTORY = user_info.FACTORY;
lu.BU = user_info.BU_NAME;
lu.EMP_NO = user_info.EMP_NO;
lu.EMP_LEVEL = user_info.EMP_LEVEL;
lu.DPT_NAME = user_info.DPT_NAME;
string token1 = DateTime.Now.ToString("yyyyMMddHHmmss");
string token2 = rand.Next(100, 999).ToString();
char[] TokenChars = (token1 + token2).ToArray();
byte[] TokenBytes = Encoding.Default.GetBytes(TokenChars);
string TokenBas64 = Convert.ToBase64String(TokenBytes);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000009";
LoginUser = lu;
lr = new LoginReturn()
{
Token = TokenBas64, User_ID = LoginUser.EMP_NO, UserInfo = user_info
};
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000010";
}
StationReturn.Data = lr;
_DBPools["SFCDB"].Return(SFCDB);
}
/// <summary>
///修改用戶密碼
/// </summary>
public void UpdatePassword(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string UpdateSql = "";
T_c_user UserInformation;
string OldPwd = Data["OLDPWD"].ToString();
string NewPwd = Data["NEWPWD"].ToString();
string ConNewPwd = Data["CONNEWPWD"].ToString();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
UserInformation = new T_c_user(sfcdb, DBTYPE);
Row_c_user row = (Row_c_user)UserInformation.GetObjByID(LoginUser.ID, sfcdb);
if (OldPwd == row.EMP_PASSWORD)
{
if (NewPwd == ConNewPwd)
{
row.ID = LoginUser.ID;
row.EMP_PASSWORD = ConNewPwd;
row.EDIT_EMP = LoginUser.EMP_NO;
row.EDIT_TIME = GetDBDateTime();
UpdateSql = row.GetUpdateString(DBTYPE);
sfcdb.ExecSQL(UpdateSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "密碼更新成功";
StationReturn.Data = "";
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "前後兩次輸入密碼不一致";
StationReturn.Data = NewPwd + " <> " + ConNewPwd;
this.DBPools["SFCDB"].Return(sfcdb);
}
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "舊密碼不正確";
StationReturn.Data = OldPwd;
this.DBPools["SFCDB"].Return(sfcdb);
}
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// REPAIR_CHECK_OUT權限檢查
/// </summary>
/// <param name="Station"></param>
/// <param name="Input"></param>
/// <param name="Paras"></param>
public static void RepairOutEmpChecker(MESStationBase Station, MESStationInput Input, List <R_Station_Action_Para> Paras)
{
if (Paras.Count != 2)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000050"));
}
string type = Paras[0].VALUE.ToString().ToUpper();
if (type == "")
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE }));
}
MESStationSession sessionEmp = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY);
if (sessionEmp == null || sessionEmp.Value == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[1].SESSION_TYPE }));
}
//Vertiv SE&RE黃克喜要求只有指定人員才能掃入和接收REPAIR_CHECK_IN
T_c_user t_c_uer = new T_c_user(Station.SFCDB, Station.DBType);
Row_c_user rowUser = t_c_uer.getC_Userbyempno(sessionEmp.Value.ToString(), Station.SFCDB, Station.DBType);
T_C_CONTROL t_c_control = new T_C_CONTROL(Station.SFCDB, Station.DBType);
string[] inEmp = t_c_control.GetControlByName("REPAIR_CHECK_OUT_SEND", Station.SFCDB).CONTROL_VALUE.Split(',');
string[] receiveEmp = t_c_control.GetControlByName("REPAIR_CHECK_OUT_RECEIVE", Station.SFCDB).CONTROL_VALUE.Split(',');
List <string> inEmpList = new List <string>(inEmp);
List <string> receiveList = new List <string>(receiveEmp);
if (rowUser == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180620163103", new string[] { sessionEmp.Value.ToString() }));
}
if (type == "SEND")
{
if (inEmpList.Find(s => s == rowUser.EMP_NO) == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180619155133", new string[] { rowUser.EMP_NO }));
}
}
else if (type == "RECEIVE")
{
if (receiveList.Find(s => s == rowUser.EMP_NO) == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180619154947", new string[] { rowUser.EMP_NO }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MSGCODE20180607163531", new string[] { "Input" }));
}
}
/// <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;
}
}
/// <summary>
/// 加載所有用戶列表
/// </summary>
public void LoadInformation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_c_user LoadUsetInfo;
List <c_user_model> LoadUsetInfolsit = new List <c_user_model>();
string r = Data["PageRow"].ToString() == "" ? "10" : Data["PageRow"].ToString();
string i = Data["PageCount"].ToString() == "" ? "1" : Data["PageCount"].ToString();
int PageRow = Convert.ToInt32(r == "0" ? "10" : r);
int PageCount = Convert.ToInt32(i == "0" ? "1" : i);
string emp_no = Data["emp_no"].ToString();//需要查询人的工号
int MaxPage;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
LoadUsetInfo = new T_c_user(sfcdb, DBTYPE);
MaxPage = LoadUsetInfo.CheckMaxPage(PageRow, emp_no, sfcdb);
if (MaxPage >= PageCount)
{
LoadUsetInfolsit = LoadUsetInfo.SelectUserInfo(PageRow, PageCount, emp_no, this.LoginUser.EMP_LEVEL, this.LoginUser.DPT_NAME, this.LoginUser.EMP_NO, this.LoginUser.FACTORY, this.LoginUser.BU, sfcdb);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000017";
StationReturn.Data = LoadUsetInfolsit;
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000018";
StationReturn.MessagePara.Add(PageCount);
StationReturn.MessagePara.Add(MaxPage);
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 RegisterNewUser(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
T_c_user USER;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
USER = new T_c_user(sfcdb, DBTYPE);
Row_c_user UserRow = (Row_c_user)USER.NewRow();
UserRow.ID = USER.GetNewID(BU, sfcdb);
UserRow.FACTORY = Data["FACTORY"].ToString();
UserRow.BU_NAME = Data["BU_NAME"].ToString();
UserRow.EMP_NO = Data["EMP_NO"].ToString();
UserRow.EMP_PASSWORD = Data["EMP_PASSWORD"].ToString();
UserRow.EMP_NAME = Data["EMP_NAME"].ToString();
UserRow.EMP_LEVEL = "0";//Data["EMP_LEVEL"].ToString();///創建用戶默認全部為普通用戶 0表示普通用戶，1表示可編輯本部門角色權限的用戶，9表示後台管理，能操作權限相關的任何動作
UserRow.DPT_NAME = Data["DPT_NAME"].ToString();
UserRow.POSITION_NAME = Data["POSITION_NAME"].ToString();
UserRow.MAIL_ADDRESS = Data["MAIL_ADDRESS"].ToString().ToLower();
UserRow.PHONE_NUMBER = Data["PHONE_NUMBER"].ToString();
UserRow.LOCATION = Data["LOCATION"].ToString();
UserRow.LOCK_FLAG = "N";
UserRow.AGENT_EMP_NO = Data["AGENT_EMP_NO"].ToString();
UserRow.CHANGE_PASSWORD_TIME = GetDBDateTime();
UserRow.EMP_DESC = Data["EMP_DESC"].ToString();
UserRow.EDIT_TIME = GetDBDateTime();
UserRow.EDIT_EMP = Data["EMP_NO"].ToString();
UserRow.EMP_EN_NAME = Data["EMP_EN_NAME"].ToString();
if (Data["FACTORY"].ToString() == null)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "";
return;
}
if (Data["BU_NAME"].ToString() == null)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "廠別為空";
return;
}
if (Data["EMP_NO"].ToString() == null)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "工號為空";
return;
}
if (Data["DPT_NAME"].ToString() == null)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "所屬部門";
return;
}
if (Data["EMP_NAME"].ToString() == null)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "員工姓名為空";
return;
}
///CHECK 用戶密碼
string STRPWD = USER.CheckPWD(Data["EMP_PASSWORD"].ToString(), sfcdb);
if (STRPWD != "Pass")
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = STRPWD;
return;
}
/// CHECK EMAIL地址
string STRMAIL = USER.CheckMail(Data["MAIL_ADDRESS"].ToString().ToLower(), sfcdb);
if (STRMAIL != "Pass")
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = STRMAIL;
return;
}
///CHECK 電話號碼
if (!USER.CheckPhone(Data["PHONE_NUMBER"].ToString(), sfcdb))
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "电话号码填寫格式不正確";
return;
}
DataTable userstr = new DataTable();
userstr = USER.SelectC_Userbyempno(UserRow.EMP_NO, sfcdb, this.DBTYPE);
if (userstr.Rows.Count != 0)
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000012";
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
string strRet = sfcdb.ExecSQL(UserRow.GetInsertString(this.DBTYPE));
if (strRet == "1")
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000013";
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000014";
this.DBPools["SFCDB"].Return(sfcdb);
}
}
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
///給用戶添加角色 INSERT C_USER_ROLE,并更新C_USER LEVEL_FLAG欄位的值 0表示普通用戶，1表示普通管理員，9 IT所有
/// </summary>
public void AddUserRolePrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string InsertSql = "", UpdateSql = "";
T_c_user_role UserRoler;
T_c_user EmpLevel;
string EMP_NO = Data["EMP_NO"].ToString();
string LEVEL_FLAG = Data["LEVEL_FLAG"].ToString();
// string[] ROLE_ID = Data["ROLE_ID"].ToString().Trim('[').Trim(']').Split(',');
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.BeginTrain();
UserRoler = new T_c_user_role(sfcdb, DBTYPE);
EmpLevel = new T_c_user(sfcdb, DBTYPE);
string USER_ID = UserRoler.GetUserID(EMP_NO, sfcdb);
foreach (string item in Data["ROLE_ID"])
{
string strroleid = item.Trim('\'').Trim('\"');
if (UserRoler.CheckUserRole(USER_ID, strroleid, sfcdb))
{
Row_c_user_role row = (Row_c_user_role)UserRoler.NewRow();
row.ID = UserRoler.GetNewID(BU, sfcdb);
row.USER_ID = USER_ID;
row.ROLE_ID = strroleid;
row.EDIT_EMP = LoginUser.EMP_NO;
row.SYSTEM_NAME = SystemName;
row.EDIT_TIME = GetDBDateTime();
InsertSql += row.GetInsertString(DBTYPE) + ";\n";
}
else
{
sfcdb.RollbackTrain();
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "該用戶已擁有該角色";
StationReturn.Data = "";
this.DBPools["SFCDB"].Return(sfcdb);
return;
}
}
InsertSql = "begin\n" + InsertSql + "end;";
sfcdb.ExecSQL(InsertSql);
if (EmpLevel.CheckEmpLevel(USER_ID, LEVEL_FLAG, sfcdb))
{
Row_c_user RowLevel = (Row_c_user)EmpLevel.GetObjByID(USER_ID, sfcdb);
RowLevel.ID = USER_ID;
RowLevel.EMP_LEVEL = LEVEL_FLAG;
RowLevel.EDIT_EMP = LoginUser.EMP_NO;
RowLevel.EDIT_TIME = GetDBDateTime();
UpdateSql = RowLevel.GetUpdateString(DBTYPE);
sfcdb.ExecSQL(UpdateSql);
}
sfcdb.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Message = "添加成功";
sfcdb.CommitTrain();
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
sfcdb.RollbackTrain();
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 更新用戶信息
/// </summary>
public void UpdateInformation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string UpdateSql = "";
T_c_user GetInformation;
string ID = Data["ID"].ToString();
string FACTORY = Data["FACTORY"].ToString();
string BU_NAME = Data["BU_NAME"].ToString();
string EMP_NO = Data["EMP_NO"].ToString();
string EMP_PASSWORD = Data["EMP_PASSWORD"].ToString();
string EMP_NAME = Data["EMP_NAME"].ToString();
string DPT_NAME = Data["DPT_NAME"].ToString();
string POSITION_NAME = Data["POSITION_NAME"].ToString();
string MAIL_ADDRESS = Data["MAIL_ADDRESS"].ToString();
string PHONE_NUMBER = Data["PHONE_NUMBER"].ToString();
string LOCATION = Data["LOCATION"].ToString();
string AGENT_EMP_NO = Data["AGENT_EMP_NO"].ToString();
string EMP_DESC = Data["EMP_DESC"].ToString();
string EMP_EN_NAME = Data["EMP_EN_NAME"].ToString();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
GetInformation = new T_c_user(sfcdb, DBTYPE);
Row_c_user row = (Row_c_user)GetInformation.GetObjByID(Data["ID"].ToString(), sfcdb);
row.ID = ID;
row.FACTORY = FACTORY;
row.BU_NAME = BU_NAME;
row.EMP_NO = EMP_NO;
row.EMP_PASSWORD = EMP_PASSWORD;
row.EMP_NAME = EMP_NAME;
row.DPT_NAME = DPT_NAME;
row.POSITION_NAME = POSITION_NAME;
row.MAIL_ADDRESS = MAIL_ADDRESS;
row.PHONE_NUMBER = PHONE_NUMBER;
row.LOCATION = LOCATION;
row.AGENT_EMP_NO = AGENT_EMP_NO;
row.EMP_DESC = EMP_DESC;
row.EMP_EN_NAME = EMP_EN_NAME;
row.EDIT_TIME = GetDBDateTime();
row.CHANGE_PASSWORD_TIME = GetDBDateTime();
///CHECK 用戶密碼
string STRPWD = GetInformation.CheckPWD(EMP_PASSWORD, sfcdb);
if (STRPWD != "Pass")
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = STRPWD;
return;
}
/// CHECK EMAIL地址
string STRMAIL = GetInformation.CheckMail(MAIL_ADDRESS.ToLower(), sfcdb);
if (STRMAIL != "Pass")
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = STRMAIL;
return;
}
///CHECK 電話號碼
if (!GetInformation.CheckPhone(PHONE_NUMBER, sfcdb))
{
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = "电话号码填寫格式不正確";
return;
}
UpdateSql = row.GetUpdateString(DBTYPE);
sfcdb.ExecSQL(UpdateSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000001";
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
