private void GotoUserMode(string user_group_code)
{
cUser_group objUserGroup = new cUser_group();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string strCriteria = " and user_group_code = '" + user_group_code + "' ";
string strMessage = string.Empty;
objUserGroup.SP_USER_GROUP_SEL(strCriteria, ref ds, ref strMessage);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.IsLogin = "******";
this.DirectorLock = Helper.CStr(dt.Rows[0]["director_lock"]);
this.MajorLock = Helper.CStr(dt.Rows[0]["unit_lock"]);
string[] strperson_group_list = Helper.CStr(dt.Rows[0]["person_group_list"]).Split(',');
for (int i = 0; i <= (strperson_group_list.GetUpperBound(0)); i++)
{
PersonGroupList = PersonGroupList + "'" + strperson_group_list[i] + "',";
}
PersonGroupList = PersonGroupList.Substring(0, PersonGroupList.Length - 1);
cPerson objPerson = new cPerson();
strCriteria = " And person_id='" + base.PersonId + "' ";
objPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.UserLoginName = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " + Helper.CStr(dt.Rows[0]["person_thai_surname"]);
this.PersonMajorCode = Helper.CStr(dt.Rows[0]["major_code"]);
this.PersonMajorName = Helper.CStr(dt.Rows[0]["major_name"]);
this.PersonMajorAbbrev = Helper.CStr(dt.Rows[0]["major_abbrev"]);
this.DirectorCode = Helper.CStr(dt.Rows[0]["director_code"]);
this.DirectorName = Helper.CStr(dt.Rows[0]["director_name"]);
Session["username"] = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " + Helper.CStr(dt.Rows[0]["person_thai_surname"]);
}
Response.Redirect("Menu_control.aspx");
}
}
protected bool SetUserProfile(string strUserName, string strPassword, ref string _strError)
{
bool booResult = false;
cUser objUser = new cUser();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string strCriteria;
string strMessage = string.Empty;
string strDecryptPassword = string.Empty;
strCriteria = " And LoginName='" + strUserName + "' ";
objUser.SP_USER_SEL(strCriteria, ref ds, ref strMessage);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
strDecryptPassword = Cryptorengine.Decrypt(Helper.CStr(dt.Rows[0]["Password"]), true);
if (strDecryptPassword.Equals(strPassword))
{
this.IsLogin = "******";
this.UserID = Helper.CInt(dt.Rows[0]["UserID"]);
this.UserLoginName = Helper.CStr(dt.Rows[0]["LoginName"]);
this.DirectorLock = Helper.CStr(dt.Rows[0]["director_lock"]);
this.DirectorCode = Helper.CStr(dt.Rows[0]["director_code"]);
this.DirectorName = Helper.CStr(dt.Rows[0]["director_name"]);
try
{
this.UnitLock = Helper.CStr(dt.Rows[0]["unit_lock"]);
}
catch
{
this.UnitLock = "N";
}
if (this.UnitLock == "Y")
{
this.UnitCodeList = string.Empty;
string[] strunit_code_list = Helper.CStr(dt.Rows[0]["unit_code_list"]).Split(',');
for (int i = 0; i <= (strunit_code_list.GetUpperBound(0)); i++)
{
this.UnitCodeList += "'" + strunit_code_list[i].Substring(3, 5) + "',";
}
this.UnitCodeList = this.UnitCodeList.Substring(0, this.UnitCodeList.Length - 1);
}
this.myBudgetType = Helper.CStr(dt.Rows[0]["budget_type"]);
string[] strperson_group_list = Helper.CStr(dt.Rows[0]["person_group_list"]).Split(',');
for (int i = 0; i <= (strperson_group_list.GetUpperBound(0)); i++)
{
PersonGroupList = PersonGroupList + "'" + strperson_group_list[i] + "',";
}
PersonGroupList = PersonGroupList.Substring(0, PersonGroupList.Length - 1);
cItem objItem = new cItem();
DataTable dt2 = new DataTable();
DataSet ds2 = new DataSet();
string strYear = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow"].ToString();
strCriteria = " And person_group_code in (" + PersonGroupList + ") And lot_code<>'' ";
strCriteria += " And item_year = " + strYear;
objItem.SP_ITEM_LOT_GROUP_SEL(strCriteria, ref ds2, ref strMessage);
LotCodeList = string.Empty;
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
LotCodeList = LotCodeList + "'" + ds2.Tables[0].Rows[i]["lot_code"].ToString() + "',";
}
if (LotCodeList.Length > 0)
{
LotCodeList = LotCodeList.Substring(0, LotCodeList.Length - 1);
}
booResult = true;
}
else
{
_strError = "รหัสผ่านไม่ถูกต้อง";
}
}
else
{
_strError = "ไม่พบผู้ใช้งานนี้";
}
return(booResult);
}
private void GotoUserMode(string user_group_code)
{
//if (user_group_code == "001")
//{
// if (SetPersonUserProfile(txtUser.Text, ref _strMessage))
// {
// Response.Redirect("Menu_control.aspx");
// }
//}
//else
//{
cUser_group objUserGroup = new cUser_group();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string strCriteria = " and user_group_code = '" + user_group_code + "' ";
string strMessage = string.Empty;
objUserGroup.sp_USER_GROUP_SEL(strCriteria, ref ds, ref strMessage);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.IsLogin = "******";
this.DirectorLock = Helper.CStr(dt.Rows[0]["director_lock"]);
try
{
this.UnitLock = Helper.CStr(dt.Rows[0]["unit_lock"]);
}
catch
{
this.UnitLock = "N";
}
if (this.UnitLock == "Y")
{
this.UnitCodeList = string.Empty;
string[] strunit_code_list = Helper.CStr(dt.Rows[0]["unit_code_list"]).Split(',');
for (int i = 0; i <= (strunit_code_list.GetUpperBound(0)); i++)
{
this.UnitCodeList += "'" + strunit_code_list[i].Substring(3, 5) + "',";
}
this.UnitCodeList = this.UnitCodeList.Substring(0, this.UnitCodeList.Length - 1);
}
string[] strperson_group_list = Helper.CStr(dt.Rows[0]["person_group_list"]).Split(',');
for (int i = 0; i <= (strperson_group_list.GetUpperBound(0)); i++)
{
PersonGroupList = PersonGroupList + "'" + strperson_group_list[i] + "',";
}
PersonGroupList = PersonGroupList.Substring(0, PersonGroupList.Length - 1);
cPerson objPerson = new cPerson();
strCriteria = " And person_code='" + this.PersonCode + "' ";
objPerson.SP_PERSON_LIST_SEL(strCriteria, ref ds, ref strMessage);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.UserLoginName = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " "
+ Helper.CStr(dt.Rows[0]["person_thai_surname"]);
this.DirectorCode = Helper.CStr(dt.Rows[0]["director_code"]);
this.DirectorName = Helper.CStr(dt.Rows[0]["director_name"]);
Session["username"] = Helper.CStr(dt.Rows[0]["person_thai_name"]) + " "
+ Helper.CStr(dt.Rows[0]["person_thai_surname"]);
}
Response.Redirect("Menu_control.aspx");
}
// }
}
