示例#1
0
        private bool WfChkSecurity()
        {
            // 輸入的帳號及密碼
            string              userId, passWord;
            StringBuilder       sbSql;
            List <SqlParameter> sqlParmList;

            try
            {
                userId   = txt_InputUserid.Text;
                passWord = txt_InputPassword.Text;
                if (GlobalFn.varIsNull(userId))
                {
                    WfShowErrorMsg("請輸入使用者 ID !");
                    return(false);
                }
                if (GlobalFn.varIsNull(passWord))
                {
                    WfShowErrorMsg("請輸入使用者 密碼 !");
                    return(false);
                }
                sbSql = new StringBuilder();
                sbSql.AppendLine("SELECT * FROM ada_tb ");
                sbSql.AppendLine("WHERE  ada01=@ada01");
                //sbSql.AppendLine("AND ada05=@ada05");
                sqlParmList = new List <SqlParameter>();

                sqlParmList.Add(new SqlParameter("ada01", userId));
                //sqlParmList.Add(new SqlParameter("ada05", passWord));

                //drAda = BoSecurity.OfGetDataRow(sbSql.ToString(), sqlParmList.ToArray());
                var adaModel = BoSecurity.OfGetAdaModel(userId);    //取得使用者資料
                if (adaModel == null)
                {
                    WfShowErrorMsg("無此帳號,請重新輸入!");
                    IntTryTimes++;

                    if (IntTryTimes >= 3)
                    {
                        WfShowErrorMsg("輸入錯誤三次以上,程式即將關閉...!");
                        this.DialogResult = DialogResult.Cancel;
                        this.Close();
                    }
                    return(false);
                }
                else
                {
                    var md5Hash = GlobalFn.genMd5Hash(passWord);
                    if (md5Hash != adaModel.ada05)
                    {
                        WfShowErrorMsg("帳號或密碼錯誤,請重新輸入!");
                        IntTryTimes++;

                        if (IntTryTimes >= 3)
                        {
                            WfShowErrorMsg("輸入錯誤三次以上,程式即將關 閉...!");
                            this.DialogResult = DialogResult.Cancel;
                            this.Close();
                        }
                        return(false);
                    }
                }

                LoginInfo.UserNo   = GlobalFn.isNullRet(adaModel.ada01, "");
                LoginInfo.UserName = GlobalFn.isNullRet(adaModel.ada02, "");
                LoginInfo.GroupNo  = GlobalFn.isNullRet(adaModel.ada03, "");
                if (!GlobalFn.varIsNull(LoginInfo.GroupNo))
                {
                    var adeTbModel = BoSecurity.OfGetAdeModel(LoginInfo.GroupNo);
                    if (adeTbModel != null)
                    {
                        LoginInfo.GroupLevel = adeTbModel.ade03;
                    }
                }
                //LoginInfo.DeptNo = Global_Fn.isNullRet(ldr_ada["ada03"], "");     //移至開啟視窗中執行
                //LoginInfo.DeptName = "";                                            //移至開啟視窗中執行

                LoginInfo.UserRole = GlobalFn.isNullRet(adaModel.ada04, "");
                this.DialogResult  = DialogResult.OK;
                return(true);
                //this.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#2
0
        protected override bool WfItemCheck(object sender, ItemCheckInfo e)
        {
            List <vw_admi100s> detailList = null;
            int chkCnts = 0;

            try
            {
                #region 單頭 vw_admi100
                if (e.Row.Table.Prefix.ToLower() == "vw_admi100")
                {
                    switch (e.Column.ToLower())
                    {
                    case "ada01":       //使用者ID
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            return(true);
                        }
                        if (FormEditMode == YREditType.新增)
                        {
                            if (BoAdm.OfChkAdaPKExists(e.Value.ToString()))
                            {
                                WfShowErrorMsg("使用者ID已存在!");
                                return(false);
                            }
                        }
                        break;

                    case "ada03":       //使用者部門
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            e.Row["ada03_c"] = "";
                            break;
                        }
                        if (BoAdm.OfChkAdePKExists(e.Value.ToString()) == false)
                        {
                            WfShowErrorMsg("無此使用者部門代號,請確認!");
                            return(false);
                        }
                        e.Row["ada03_c"] = BoAdm.OfGetAde02(e.Value.ToString());

                        break;

                    case "ada04":
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            e.Row["ada04_c"] = "";
                            break;
                        }
                        if (BoAdm.OfChkAdcPKExists(e.Value.ToString()) == false)
                        {
                            WfShowErrorMsg("無此角色代號,請確認!");
                            return(false);
                        }
                        e.Row["ada04_c"] = BoAdm.OfGetAdc02(e.Value.ToString());
                        break;

                    case "ada05":       //登入密碼 要處理編碼方式
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            if (!GlobalFn.varIsNull(OldValue))
                            {
                                e.Row["ada05"] = OldValue;
                                return(true);
                            }
                        }
                        e.Row["ada05"] = GlobalFn.genMd5Hash(e.Value.ToString());
                        e.Row["ada06"] = "Y";
                        break;

                    case "ada08":       //預設營運公司
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            return(true);
                        }
                        if (BoAdm.OfChkAtaPKExists(e.Value.ToString()) == false)
                        {
                            WfShowErrorMsg("無此公司別,請確認!");
                            return(false);
                        }
                        //檢查單身是否有此登入公司
                        detailList = TabDetailList[0].DtSource.ToList <vw_admi100s>();
                        if (detailList != null)
                        {
                            chkCnts = detailList.Where(p => p.adb02 == e.Value.ToString())
                                      .Count();
                        }
                        if (detailList == null || chkCnts == 0)
                        {
                            var result = WfShowConfirmMsg("無此登入公司別權限,是否要新增?");
                            if (result == DialogResult.Yes)
                            {
                                var newRow = TabDetailList[0].DtSource.NewRow();
                                WfSetDetailRowDefault(0, newRow);
                                newRow["adb02"] = e.Value;
                                var ataModel = BoAdm.OfGetAtaModel(e.Value.ToString());
                                newRow["adb02_c"] = ataModel.ata02;
                                TabDetailList[0].DtSource.Rows.Add(newRow);
                            }
                        }
                        break;
                    }
                }
                #endregion

                #region 單身 vw_admi100s
                if (e.Row.Table.Prefix.ToLower() == "vw_admi100s")
                {
                    switch (e.Column.ToLower())
                    {
                    case "adb02":       //可登入公司
                        if (GlobalFn.varIsNull(e.Value))
                        {
                            e.Row["adb02_c"] = "";
                            return(true);
                        }

                        if (BoAdm.OfChkAtaPKExists(e.Value.ToString()) == false)
                        {
                            WfShowErrorMsg("無此公司代號,請確認!");
                            return(false);
                        }
                        detailList = TabDetailList[0].DtSource.ToList <vw_admi100s>();
                        chkCnts    = detailList.Where(p => p.adb02.ToUpper() == e.Value.ToString().ToUpper()).Count();
                        if (chkCnts > 1)
                        {
                            WfShowErrorMsg("公司代碼重覆,請確認!");
                            return(false);
                        }

                        e.Row["adb02_c"] = BoAdm.OfGetAta02(e.Value.ToString());
                        break;
                    }
                }
                #endregion
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }