public frmLogin()
{
InitializeComponent();
this.btnExit.Image = FWImageDic.EXIT_IMAGE16;
this.btnConfig.Image = FWImageDic.CONFIG_IMAGE16;
this.btnLogin.Image = FWImageDic.LOGIN_IMAGE16;
this.Icon = FrameworkParams.ApplicationIcon;
components = new System.ComponentModel.Container();
user = new User();
user.loadCookies();
txtUsername.EditValue = user.username;
txtPassword.EditValue = user.password;
if (user.savePass == "Y") chkRememberPwd.Checked = true;
if (user.isAutoLogin == "Y") chkAutoLogin.Checked = true;
if (chkAutoLogin.Checked) FrameworkParams.isSkipLogin = true;
// init skin
FrameworkParams.currentSkin = new PLSkin(this.components);
FrameworkParams.option = new Option();
FrameworkParams.option.load();
Application.CurrentCulture = ApplyFormatAction.GetCultureInfo();
FrameworkParams.currentSkin.SelectSkin(HelpNumber.ParseInt32(FrameworkParams.option.Skin));
this.Shown += new EventHandler(frmLogin_Shown);
}
public frmUserChild(Form formUserMan, string actionName, object selectedUserId)
{
InitializeComponent();
//this.btnClose.Image = FWImageDic.CLOSE_IMAGE16;
//this.btnSave.Image = FWImageDic.SAVE_IMAGE16;
this.btnSelect.Image = FWImageDic.CHOICE_IMAGE16;
this.formUserMan = formUserMan;
this.actionName = actionName;
this.selectedUser = new User();
if (selectedUserId != null)
{
selectedUser.id = HelpNumber.ParseInt64(selectedUserId.ToString());
selectedUser.loadByUserId();
employee_id = selectedUser.employee_id;
txtUsername.Enabled = false;
btnSelect.Enabled = false;
}
initData();
//HUNG
//string select = "select employee.id , employee.name as employee_name, employee.department_id, department.name as department_name, user_cat.userid, user_cat.username " +
// "from employee left join user_cat on employee.id = user_cat.employee_id " +
// "join department on department.id=employee.department_id where user_cat.userid is null and 1=1";
string select = "select DM_NHAN_VIEN.id , DM_NHAN_VIEN.name as employee_name, DM_NHAN_VIEN.department_id, department.name as department_name, user_cat.userid, user_cat.username " +
"from DM_NHAN_VIEN left join user_cat on DM_NHAN_VIEN.id = user_cat.employee_id " +
"join department on department.id=DM_NHAN_VIEN.department_id where user_cat.userid is null and 1=1";
DataSet dsGrid = DABase.getDatabase().LoadDataSet(new QueryBuilder(select), "DETAIL");
if (plChonUser == null)
plChonUser = new PLChonNhanVien();
plChonUser.Init("DEPARTMENT", "ID", "PARENT_ID", new string[] { "NAME" }, new string[] {"Tên phòng ban" }, dsGrid, new string[] { "Nhân viên ID", "Họ tên nhân viên", "Phòng ban ID", "Tên phòng ban", "Người dùng ID", "Tên truy cập" }, "DEPARTMENT_ID", "USERNAME", HelpGen.G_FW_ID);
plChonUser.SetShowChonNhanVien(btnSelect);
plChonUser.mDlgGetSelectDataset = new PLChonNhanVien.DlgGetSelectDataset(_getSelectedDataSet);
plChonUser.mDlgGetUnSelectDataset = new PLChonNhanVien.DlgGetUnSelectDataset(_getUnSelectedDataSet);
plChonUser.m_IsMultiselect = true;
plChonUser.mVisibleGridColumn(new string[] { "id", "department_id", "department_name", "userid" });
//--------------------------
}
public ApplyPermissionAction(string formName)
{
this.user = FrameworkParams.currentUser;
}
public void initData()
{
user = new User();
user.loadCookies();
user.loadByUserName();
}
private void barButtonItemDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup"))
{
if (gridViewGroup.FocusedRowHandle < 0) return;
DataRow row = gridViewGroup.GetDataRow(gridViewGroup.FocusedRowHandle);
DialogResult reply = FWMsgBox.questionGroupDelete(row["GROUPNAME"].ToString());
if (reply == DialogResult.Yes)
{
Group group = new Group();
group.id = HelpNumber.ParseInt64(row["GROUPID"].ToString());
if (!group.delete())
{
FWMsgBox.showDeleteUsing();
return;
}
else
{
gridViewGroup.DeleteRow(gridViewGroup.FocusedRowHandle);
editEnabledButtonDeleteAndEdit();
}
}
}
else
{
if (gridViewUser.FocusedRowHandle < 0) return;
DataRow row = gridViewUser.GetDataRow(gridViewUser.FocusedRowHandle);
if (row["USERNAME"].ToString() == "admin")
{
HelpMsgBox.ShowNotificationMessage("Bạn không thể xóa người dùng 'admin'");
return;
}
DialogResult reply = FWMsgBox.questionUserDelete(row["USERNAME"].ToString());
if (reply == DialogResult.Yes)
{
User user = new User();
user.id = HelpNumber.ParseInt64(row["USERID"].ToString());
if (!user.delete())
{
FWMsgBox.showDeleteUsing();
return;
}
else
{
this.gridViewUser.DeleteRow(gridViewUser.FocusedRowHandle);
editEnabledButtonDeleteAndEdit();
}
}
}
//HUNG
reLoadGroupUserThanhPhan();
}
//PHUOC TEST
public User findByUserName(String username)
{
DatabaseFB db = DABase.getDatabase();
DbCommand dbSelect = db.GetSQLStringCommand("SELECT * FROM USER_CAT WHERE USERNAME=@username");
db.AddInParameter(dbSelect, "@username", DbType.String, username);
IDataReader reader = db.ExecuteReader(dbSelect);
if (reader.Read())
{
User user = new User();
user.id = HelpNumber.ParseInt64(reader["USERID"].ToString());
//user.password = reader["PWD"].ToString();
user.password = "******";
user.username = reader["USERNAME"].ToString();
user.isChangePass = (reader["ISCHANGEPWD_BIT"].ToString().Equals("Y") ? true : false);
user.isActive = (reader["ISACTIVE_BIT"].ToString().Equals("Y") ? true : false);
if (!reader["LASTACCESS"].ToString().Equals(""))
user.lastAccess = DateTime.Parse(reader["LASTACCESS"].ToString());
user.employee_id = (reader["EMPLOYEE_ID"] == null? -1: HelpNumber.ParseInt64(reader["EMPLOYEE_ID"].ToString()));
reader.Close();
user.fullname = GetFullName(user.id);
return user;
}
return null;
}
public static User loadUser()
{
User user = new User();
DataSet ds = new DataSet();
try
{
if (ConfigFile.ReadXML(FAUser.COOKIES, ds) == false)
{
saveUser("admin", "admin", "Y", "N");
ConfigFile.ReadXML(FAUser.COOKIES, ds);
}
DataTable myDataTable = ds.Tables["SYS_USER"];
if (myDataTable.Rows.Count > 0)
{
DataRow row = myDataTable.Rows[0];
user.username = (string)row["username"];
user.password = (string)row["password"];
user.savePass = (string)row["savepassword"];
user.isAutoLogin = (string)row["isautologin"];
}
}
catch
{
user.username = "";
user.password = "";
user.savePass = "";
user.isAutoLogin = "";
}
return user;
}
//PHUOC TEST
public User findById(long userId)
{
DatabaseFB db = DABase.getDatabase();
//DbCommand dbSelect = db.GetSQLStringCommand("SELECT user_cat.*, employee.name as fullname FROM user_cat inner join employee on employee.id=user_cat.employee_id WHERE USERID=@userId");
DbCommand dbSelect = db.GetSQLStringCommand("SELECT user_cat.*, DM_NHAN_VIEN.name as fullname FROM user_cat left join DM_NHAN_VIEN on DM_NHAN_VIEN.id=user_cat.employee_id WHERE user_cat.USERID=@userId");
db.AddInParameter(dbSelect, "@userId", DbType.Int64, userId);
IDataReader reader = db.ExecuteReader(dbSelect);
if (reader.Read())
{
User user = new User();
user.id = HelpNumber.ParseInt64(reader["USERID"].ToString());
user.fullname = (reader["fullname"]==null? "" : reader["fullname"].ToString());
user.password = "******";
user.username = reader["USERNAME"].ToString();
user.isChangePass = (reader["ISCHANGEPWD_BIT"].ToString().Equals("Y") ? true : false);
user.isActive = (reader["ISACTIVE_BIT"].ToString().Equals("Y") ? true : false);
if (!reader["LASTACCESS"].ToString().Equals(""))
user.lastAccess = DateTime.Parse(reader["LASTACCESS"].ToString());
user.employee_id = (reader["EMPLOYEE_ID"] == null? -1 : HelpNumber.ParseInt64(reader["EMPLOYEE_ID"]));
reader.Close();
return user;
}
return null;
}
//PHUOC
public List<User> findAll()
{
List<User> users = new List<User>();
DatabaseFB db = DABase.getDatabase();
DbCommand dbSelect = db.GetSQLStringCommand("SELECT * FROM USER_CAT ORDER BY lower(USERNAME)");
IDataReader reader = db.ExecuteReader(dbSelect);
while (reader.Read())
{
User user = new User();
user.id = HelpNumber.ParseInt64(reader["USERID"].ToString());
user.username = reader["USERNAME"].ToString();
//user.password = reader["PWD"].ToString();
user.password = "******";
user.isChangePass = (reader["ISCHANGEPWD_BIT"].ToString().Equals("Y") ? true : false);
user.isActive = (reader["ISACTIVE_BIT"].ToString().Equals("Y") ? true : false);
if (!reader["LASTACCESS"].ToString().Equals(""))
user.lastAccess = DateTime.Parse(reader["LASTACCESS"].ToString());
users.Add(user);
}
reader.Close();
return users;
}
//PHUOC OK
public List<User> getListUserByIdGroup(long groupId)
{
List<User> users = new List<User>();
DatabaseFB db = DABase.getDatabase();
DbCommand select = db.GetSQLStringCommand("SELECT * FROM USER_CAT u,GROUP_USER_REL ug WHERE" +
" u.USERID=ug.USERID AND ug.GROUPID=@groupId ORDER BY lower(USERNAME) ASC");
db.AddInParameter(select, "@groupId", DbType.Int64, groupId);
IDataReader reader = db.ExecuteReader(select);
while (reader.Read())
{
User user = new User();
user.id = HelpNumber.ParseInt64(reader["USERID"]);
user.username = reader["USERNAME"].ToString();
user.fullname = "Chưa kết với Employee";
user.isActive = (reader["ISACTIVE_BIT"].ToString() == "Y" ? true : false);
user.isChangePass = (reader["ISCHANGEPWD_BIT"].ToString() == "Y" ? true : false);
users.Add(user);
}
reader.Close();
return users;
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
SplashScreen.SetCommentaryString("..Đang nạp giao diện.");
this.btnExit.Image = FWImageDic.EXIT_IMAGE16;
this.btnConfig.Image = FWImageDic.CONFIG_IMAGE16;
this.btnLogin.Image = FWImageDic.LOGIN_IMAGE16;
this.Icon = FrameworkParams.ApplicationIcon;
components = new System.ComponentModel.Container();
user = new User();
user.loadCookies();
txtUsername.EditValue = user.username;
txtPassword.EditValue = user.password;
if (user.savePass == "Y") chkRememberPwd.Checked = true;
if (user.isAutoLogin == "Y") chkAutoLogin.Checked = true;
if (frmLoginInstance == null)
{
if (chkAutoLogin.Checked) FrameworkParams.isSkipLogin = true;
frmLoginInstance = this;
}
// init skin
if(FrameworkParams.UsingSkin == true)
FrameworkParams.currentSkin = new DevExpressSkin(this.components);
FrameworkParams.option = new Option();
FrameworkParams.option.load();
Application.CurrentCulture = ApplyFormatAction.GetCultureInfo();
if(FrameworkParams.currentSkin!=null)
FrameworkParams.currentSkin.SelectSkin(HelpNumber.ParseInt32(FrameworkParams.option.Skin));
if (FrameworkParams.isSkipLogin==true)
{
SplashScreen.SetCommentaryString("..Đang xử lý đăng nhập tự động.");
this.isDirect = true;
this.LoginAction();
}
}
private void lbUser_DoubleClick(object sender, System.EventArgs e)
{
if (lbUser.SelectedIndex <= 0) return;
User u = new User();
u.username = lbUser.SelectedItem.ToString();
u.loadByUserName();
frmUserChild form = new frmUserChild(null, "EDIT", u.id.ToString());
ProtocolForm.ShowModalDialog(this, form);
}
