예제 #1
0
        //加载功能
        private void LoadModule(ModuleModel m, out NavBarGroup CurrentGroup, out BarSubItem CurrentBarItem)
        {
            var ModuleImage = LoadUIImage.LoadNavBarImage_Group(ConvertLib.ToString(m.ModuleImg));

            //添加模块到navBarControl1

            //m.ModuleName = "(新)" + m.ModuleName;
            //LoadModule(hp, dtModulesFun, m);
            //hp.CurrentGroup.Appearance.ForeColor = Color.FromArgb(0x99, 0x00, 0x33);
            //hp.CurrentGroup.Appearance.Font = new Font(hp.CurrentGroup.Appearance.Font, FontStyle.Bold);

            CurrentGroup = new NavBarGroup()
            {
                Caption    = m.Caption,
                SmallImage = ModuleImage,
                Tag        = m
            };
            navBarControl1.Groups.Add(CurrentGroup);


            //添加模块到bbi_Module
            CurrentBarItem = new BarSubItem()
            {
                Caption = m.Caption,
                Glyph   = ModuleImage
            };
            if (m.IsNew)
            {
                CurrentGroup.Appearance.ForeColor = Color.FromArgb(0x99, 0x00, 0x33);
                CurrentGroup.Appearance.Font      = new Font(CurrentGroup.Appearance.Font, FontStyle.Bold);
            }

            ribbonControl1.Items.Add(CurrentBarItem);
            bsi_Modules.AddItem(CurrentBarItem);
        }
예제 #2
0
        private void TreeProductCategory_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            var v = ConvertLib.ToString(e.Node.GetValue(treeListColumn1));

            gc_Detail_tb_PODetail.DataSource = bll.SearchListData(v);
            gv_Detail_tb_PODetail.ExpandAllGroups();
        }
예제 #3
0
        private static void LoadSummaryData(GridView gv, DataTable dt)
        {
            DataRow row = dt.Rows[0];

            //交替行颜色
            gv.OptionsView.EnableAppearanceEvenRow = gv.OptionsView.EnableAppearanceOddRow = Object.Equals(row[sys_GridViewLayout.IntervalColor], "Y");
            //标题高
            gv.ColumnPanelRowHeight = ConvertLib.ToInt(row[sys_GridViewLayout.HeadHeight], -1);
            //行高
            gv.RowHeight = ConvertLib.ToInt(row[sys_GridViewLayout.RowHeight], -1);
            //显示横线
            gv.OptionsView.ShowHorizontalLines = Object.Equals(row[sys_GridViewLayout.HorzLine], "Y") ? DefaultBoolean.True : DefaultBoolean.False;
            //显示竖线
            gv.OptionsView.ShowVerticalLines = Object.Equals(row[sys_GridViewLayout.VertLine], "Y") ? DefaultBoolean.True : DefaultBoolean.False;

            //横线颜色
            if (ConvertLib.ToInt(row[sys_GridViewLayout.HorzLineColor]) != 0)
            {
                gv.Appearance.HorzLine.BackColor = Color.FromArgb(ConvertLib.ToInt(row[sys_GridViewLayout.HorzLineColor]));
            }
            //竖线颜色
            if (ConvertLib.ToInt(row[sys_GridViewLayout.VertLineColor]) != 0)
            {
                gv.Appearance.VertLine.BackColor = Color.FromArgb(ConvertLib.ToInt(row[sys_GridViewLayout.VertLineColor]));
            }
        }
예제 #4
0
        void refreshDataSource()
        {
            var v = ConvertLib.ToString(treeProductCategory.FocusedNode.GetValue(treeListColumn1));

            gc_Detail_tb_PODetail.DataSource = bll.SearchData(v);
            gv_Detail_tb_PODetail.ExpandAllGroups();
        }
예제 #5
0
        void refreshAmount()
        {
            int     qty   = ConvertLib.ToInt(txtQty.EditValue);
            decimal price = ConvertLib.ToDecimal(txtUnitPrice.EditValue, 0);

            txtTotalAmount.EditValue = qty * price;
        }
예제 #6
0
        bool validateApprove()
        {
            DataRow row = gvMainData.GetFocusedDataRow();
            bool    app = ConvertLib.ToInt(row[tb_PO.AppStatus]) != 0;

            return(app);
        }
예제 #7
0
        private void gv_Detail_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
        {
            var view = sender as DevExpress.XtraGrid.Views.Grid.GridView;

            if (Object.Equals(view.FocusedColumn.Tag, "NotNull"))
            {
                if (Object.Equals(string.Empty, e.Value) || Object.Equals(null, e.Value) || Object.Equals(DBNull.Value, e.Value))
                {
                    e.Valid     = false;
                    e.ErrorText = view.FocusedColumn.Caption + "不能为空!";
                }
            }
            if (view.FocusedColumn.FieldName == tb_PODetail.Qty || view.FocusedColumn.FieldName == tb_PODetail.POPrice)
            {
                decimal price = 0; int qty = 0;
                if (view.FocusedColumn.FieldName == tb_PODetail.Qty)
                {
                    price = ConvertLib.ToDecimal(view.GetFocusedDataRow()[tb_PODetail.POPrice], 0);
                    qty   = ConvertLib.ToInt(e.Value, 0);
                }
                else
                {
                    price = ConvertLib.ToDecimal(e.Value, 0);
                    qty   = ConvertLib.ToInt(view.GetFocusedDataRow()[tb_PODetail.Qty], 0);
                }



                decimal amount = price * qty;
                view.SetFocusedRowCellValue(tb_PODetail.TotalPOAmount, amount);
                RefreshSummary();
            }
        }
            public static void AddColumns(DataTable dt, params string[] Cols)
            {
                if (dt.Columns[DefNewColName] != null)
                {
                    return;
                }

                dt.Columns.Add(DefNewColName, Type.GetType("System.String"));
                foreach (DataRow dr in dt.Rows)
                {
                    string Combine = string.Empty;
                    foreach (string Col in Cols)
                    {
                        if (String.IsNullOrEmpty(Combine))
                        {
                            Combine = ConvertLib.ToString(dr[Col]);
                        }
                        else
                        {
                            Combine += " - " + ConvertLib.ToString(dr[Col]);
                        }
                    }
                    dr[DefNewColName] = Combine;
                }
            }
예제 #9
0
        /// <summary>
        /// 审核
        /// </summary>
        protected override void DoApproval(object sender)
        {
            DataRow row = gvMainData.GetFocusedDataRow();

            if (row == null)
            {
                return;
            }
            frmAppResult LoadResult = (frmAppResult)ConvertLib.ToInt(row["AppStatus"]);
            frmAppResult appstatus  = frmApp.ShowForm(LoadResult);

            if (appstatus != frmAppResult.未审核)
            {
                string docno = row[tb_PO.DocNo] + "";
                bll.Approval(docno, (int)appstatus);
                row[tb_PO.AppUser]   = Loginer.CurrentLoginer.Account;
                row[tb_PO.AppDate]   = DateTime.Now;
                row[tb_PO.AppStatus] = (int)appstatus;

                if (this.CurrentDataState == FormDataState.View)
                {
                    EditData.Tables[tb_PO._TableName].Rows[0][tb_PO.AppUser]   = Loginer.CurrentLoginer.Account;
                    EditData.Tables[tb_PO._TableName].Rows[0][tb_PO.AppDate]   = DateTime.Now;
                    EditData.Tables[tb_PO._TableName].Rows[0][tb_PO.AppStatus] = (int)appstatus;
                }

                row.AcceptChanges();
            }
        }
        private void BoundData(DataSet ds, string LayoutID)
        {
            DataTable dtDetail = ds.Tables[sys_GridViewLayoutDetail._TableName];

            DataRow row;

            foreach (GridColumn col in _View.Columns)
            {
                if (dtDetail.Select(String.Format("{0}='{1}'", sys_GridViewLayoutDetail.FileName, col.FieldName)).Length == 0)
                {
                    row = dtDetail.Rows.Add();

                    row[sys_GridViewLayoutDetail.LayoutID]      = LayoutID;
                    row[sys_GridViewLayoutDetail.FileName]      = col.FieldName;
                    row[sys_GridViewLayoutDetail.FileCaptionBK] = col.Caption;
                    row[sys_GridViewLayoutDetail.FileCaption]   = col.Caption;
                    row[sys_GridViewLayoutDetail.IsShow]        = col.Visible ? "Y" : "N";
                    row[sys_GridViewLayoutDetail.Width]         = col.Width;
                    row[sys_GridViewLayoutDetail.FontColor]     = col.AppearanceCell.ForeColor.ToArgb();
                    row[sys_GridViewLayoutDetail.BackColor]     = col.AppearanceCell.BackColor.ToArgb();
                    row[sys_GridViewLayoutDetail.Alignment]     = (int)col.AppearanceCell.TextOptions.HAlignment;
                    if (col.SummaryItem != null)
                    {
                        row[sys_GridViewLayoutDetail.SummaryType]   = (int)col.SummaryItem.SummaryType;
                        row[sys_GridViewLayoutDetail.SummaryFormat] = col.SummaryItem.DisplayFormat;
                    }
                }
            }

            gridControl1.DataSource     = ds.Tables[sys_GridViewLayoutDetail._TableName];
            dataBindingView1.DataSource = ds.Tables[sys_GridViewLayout._TableName];

            txt_HorzLineColor.Color = Color.FromArgb(ConvertLib.ToInt(ds.Tables[sys_GridViewLayout._TableName].Rows[0][sys_GridViewLayout.HorzLineColor]));
            txt_VertLineColor.Color = Color.FromArgb(ConvertLib.ToInt(ds.Tables[sys_GridViewLayout._TableName].Rows[0][sys_GridViewLayout.VertLineColor]));
        }
        void RefreshNodeCheckState()
        {
            this.UncheckAll();
            if (_EditData == null)
            {
                return;
            }
            string Key;

            foreach (DataRow row in EditData.Rows)
            {
                int authority = ConvertLib.ToInt(row[dt_MyRoleAuthority.Authority]);
                var v         = ConvertLib.ToBinaryNums(authority);
                foreach (int i in v)
                {
                    Key = String.Format("{0}.{1}", row[dt_MyRoleAuthority.FunctionID], i);
                    TreeListNode node = this.FindNodeByKeyID(Key);
                    if (node == null)
                    {
                        continue;
                    }

                    _TreeListInitial.SetNodeCheckState(node, CheckState.Checked);
                }
            }
        }
예제 #12
0
 public static bool VerificationEmpEditValue(BaseEdit edit)
 {
     if (String.IsNullOrEmpty(ConvertLib.ToString(edit.EditValue)))
     {
         return(true);
     }
     return(false);
 }
예제 #13
0
        private void txt_ProviderName_EditValueChanged(object sender, EventArgs e)
        {
            string str = ConvertLib.ToString(txt_ProviderName.EditValue);

            xtraTabControl1.Enabled = !String.IsNullOrEmpty(str);
            str          = String.IsNullOrEmpty(str) ? "Error" : str;
            ProviderName = str;
        }
예제 #14
0
 private void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
 {
     if (String.IsNullOrEmpty(ConvertLib.ToString(e.Value)))
     {
         e.Valid     = false;
         e.ErrorText = gridView1.FocusedColumn.Caption + "不能为空!";
     }
 }
예제 #15
0
        public List <ModuleModel> GetModuleALL()
        {
            List <ModuleModel> lst = new List <ModuleModel>();
            var modules            = GetLocalAllModules();


            DataSet   ds           = new bllModules().GetUserModules(Loginer.CurrentLoginer.Account);
            DataTable dtModules    = ds.Tables[sys_Modules._TableName];
            DataTable dtModulesFun = ds.Tables[sys_ModulesFunction._TableName];


            foreach (IModule m in modules.Modules)
            {
                DataRow drModule = dtModules.Select($"{sys_Modules.ModuleID}='{m.ModuleID}'").FirstOrDefault();

                ModuleModel module = new ModuleModel()
                {
                    ModuleImg      = m.ModuleImg,
                    ModuleName     = m.ModuleName,
                    ModuleID       = m.ModuleID,
                    Sort           = -1,
                    ModuleMainType = (m is Form) ? m.GetType() : null
                };
                if (drModule != null)
                {
                    module.ModuleName = ConvertLib.ToString(drModule[sys_Modules.ModuleName]);
                    module.Sort       = ConvertLib.ToInt(drModule[sys_Modules.Sort]);
                    module.IsNew      = false;
                }

                foreach (ModuleFunction fun in m.FunctionCollection)
                {
                    fun.Sort = -1;
                    DataRow drFun = dtModulesFun.Select($"{sys_ModulesFunction.FunctionID}='{fun.FunctionID}'").FirstOrDefault();
                    if (drFun != null)
                    {
                        fun.FunctionName = ConvertLib.ToString(drFun[sys_ModulesFunction.FunctionName]);
                        fun.Sort         = ConvertLib.ToInt(drFun[sys_ModulesFunction.Sort]);
                        byte[] imgByte = drFun[sys_ModulesFunction.Image] as byte[];
                        if (imgByte != null && imgByte.Length > 0)
                        {
                            fun.FormIcon = Common.ImageLibrary.ConvertBytesToImage(imgByte);
                        }
                        fun.IsNew = false;
                    }

                    fun.UserAuthority = GZFramework.UI.Core.FunctionAuthority.All;

                    module.functions.Add(fun);
                }
                if (module.functions.Count > 0)
                {
                    lst.Add(module);
                }
            }
            SortModule(lst);
            return(lst);
        }
예제 #16
0
        void UpdateAuthority(TreeListNode Node)
        {
            if (Node.HasChildren)
            {
                foreach (TreeListNode Cnode in Node.Nodes)
                {
                    UpdateAuthority(Cnode);
                }
            }
            else
            {
                if (Node.Checked)
                {
                    if (ConvertLib.ToInt(Node.GetValue("AuthorityID")) <= 0)
                    {
                        return;
                    }
                    string  filter = String.Format("{0}='{1}'", dt_MyRoleAuthority.FunctionID, Node.GetValue("ParentKey"));
                    var     v      = EditData.Tables[dt_MyRoleAuthority._TableName].Select(filter);
                    DataRow dr;
                    if (v.Length > 0)
                    {
                        dr = v[0];
                        dr[dt_MyRoleAuthority.Authority] = ConvertLib.ToInt(dr[dt_MyRoleAuthority.Authority]) + ConvertLib.ToInt(Node.GetValue("AuthorityID"));
                    }
                    else
                    {
                        dr = EditData.Tables[dt_MyRoleAuthority._TableName].Rows.Add();
                        dr[dt_MyRoleAuthority.RoleID]     = EditData.Tables[dt_MyRole._TableName].Rows[0][dt_MyRole.RoleID];
                        dr[dt_MyRoleAuthority.FunctionID] = Node.GetValue("ParentKey");
                        dr[dt_MyRoleAuthority.Authority]  = Node.GetValue("AuthorityID");
                    }
                }
                else
                {
                    string filter = String.Format("{0}='{1}'", dt_MyRoleAuthority.FunctionID, Node.GetValue("ParentKey"));
                    //string stringFormat = String.Format("{0}='{1}' AND {2}='{3}'",
                    //                    dt_MyRoleAuthority.FunctionID, Node.GetValue("ParentKey"), dt_MyRoleAuthority.Authority, Node.GetValue("AuthorityID"));
                    DataRow[] drs = EditData.Tables[dt_MyRoleAuthority._TableName].Select(filter);
                    if (drs.Length > 0)
                    {
                        int authority = 0;
                        if (drs.Length > 0)
                        {
                            authority = ConvertLib.ToInt(drs[0][dt_MyRoleAuthority.Authority]);
                        }

                        int NoteValue = ConvertLib.ToInt(Node.GetValue("AuthorityID"));

                        if ((authority & NoteValue) == NoteValue)//包含权限
                        {
                            drs[0][dt_MyRoleAuthority.Authority] = authority - NoteValue;
                        }
                    }
                }
            }
        }
예제 #17
0
        protected frmApp(DataRow row)
        {
            dr = row;
            frmAppResult LoadResult = (frmAppResult)ConvertLib.ToInt(row["AppStatus"]);

            InitializeComponent();
            btn_Access.Enabled = LoadResult == frmAppResult.未审核;
            btn_Abort.Enabled  = LoadResult == frmAppResult.已审核;
            btn_Stop.Enabled   = LoadResult == frmAppResult.未审核;
        }
예제 #18
0
 private void btn_OK_Click(object sender, EventArgs e)
 {
     Num = ConvertLib.ToInt(txtNum.EditValue);
     if (Num <= 0)
     {
         Msg.Warning("数量必须大于0");
         return;
     }
     DialogResult = DialogResult.Cancel;
 }
예제 #19
0
        private void btn_OK_Click(object sender, EventArgs e)
        {
            bool b = LibraryTools.IsNotEmpBaseEdit(txtItemNo, "货号不能为空!");

            if (b == false)
            {
                return;
            }
            Data = new DataTable();
            Data.Columns.Add(nameof(tb_PODetail.ItemNo), typeof(System.String));
            Data.Columns.Add(nameof(tb_PODetail.ItemName), typeof(System.String));
            Data.Columns.Add(nameof(tb_PODetail.CategoryID), typeof(System.String));
            Data.Columns.Add(nameof(tb_PODetail.POPrice), typeof(System.Decimal));
            Data.Columns.Add(nameof(tb_PODetail.SOPrice), typeof(System.Decimal));
            Data.Columns.Add(nameof(tb_PODetail.Color), typeof(System.String));
            Data.Columns.Add(nameof(tb_PODetail.Size), typeof(System.String));
            Data.Columns.Add(nameof(tb_PODetail.Qty), typeof(System.Int16));
            Data.Columns.Add(nameof(tb_PODetail.TotalPOAmount), typeof(System.Decimal));
            foreach (DataRow row in dtQty.Rows)
            {
                string color = ConvertLib.ToString(row["Color"]);
                for (int i = 0; i < dtSize.Rows.Count; i++)
                {
                    string fileName = "Qty_" + (i + 1);
                    int    qty      = ConvertLib.ToInt(row[fileName]);
                    if (qty > 0)
                    {
                        DataRow dr = Data.NewRow();


                        dr[tb_PODetail.ItemNo] = txtItemNo.EditValue;
                        if (!String.IsNullOrEmpty(ConvertLib.ToString(txtItemName.EditValue)))
                        {
                            dr[tb_PODetail.ItemName] = txtItemName.EditValue;
                        }
                        dr[tb_PODetail.CategoryID] = txtCategory.EditValue;
                        if (!String.IsNullOrEmpty(ConvertLib.ToString(txtPOPrice.EditValue)))
                        {
                            dr[tb_PODetail.POPrice] = txtPOPrice.EditValue;
                        }
                        if (!String.IsNullOrEmpty(ConvertLib.ToString(txtSOPrice.EditValue)))
                        {
                            dr[tb_PODetail.SOPrice] = txtSOPrice.EditValue;
                        }
                        dr[tb_PODetail.Color]         = color;
                        dr[tb_PODetail.Size]          = dtSize.Rows[i]["DataName"];
                        dr[tb_PODetail.Qty]           = qty;
                        dr[tb_PODetail.TotalPOAmount] = ConvertLib.ToDecimal(txtPOPrice.EditValue, 0) * qty;
                        Data.Rows.Add(dr);
                    }
                }
            }
            Data.AcceptChanges();
            this.DialogResult = DialogResult.OK;
        }
예제 #20
0
        private List <ModuleModel> GetModuleConfig()
        {
            List <ModuleModel> lst = new List <ModuleModel>();
            var lstModules         = GetLocalAllModules();

            DataSet   ds           = new bllModules().GetUserModules(Loginer.CurrentLoginer.Account);
            DataTable dtModules    = ds.Tables[sys_Modules._TableName];
            DataTable dtModulesFun = ds.Tables[sys_ModulesFunction._TableName];

            foreach (DataRow dr in dtModules.Rows)
            {
                var m = lstModules.Modules[dr[sys_Modules.ModuleID].ToString()];
                if (m == null)
                {
                    continue;
                }

                ModuleModel module = new ModuleModel()
                {
                    ModuleImg      = m.ModuleImg,
                    ModuleName     = dr[sys_Modules.ModuleName] + "",
                    ModuleID       = m.ModuleID,
                    Sort           = ConvertLib.ToInt(dr[sys_Modules.Sort]),
                    IsNew          = false,
                    ModuleMainType = (m is Form) ? m.GetType() : null
                };

                dtModulesFun.DefaultView.RowFilter = String.Format("{0}='{1}'", sys_ModulesFunction.ModuleID, dr[sys_Modules.ModuleID]);
                foreach (DataRow row in dtModulesFun.DefaultView.ToTable().Rows)
                {
                    var fun = m.FunctionCollection[row[sys_ModulesFunction.FunctionID].ToString()];
                    fun.UserAuthority = ConvertLib.ToInt(row["UserAuthority"]);
                    fun.FunctionName  = ConvertLib.ToString(row[sys_ModulesFunction.FunctionName]);
                    fun.Sort          = ConvertLib.ToInt(row[sys_ModulesFunction.Sort]);
                    fun.IsNew         = false;
                    byte[] imgByte = row[sys_ModulesFunction.Image] as byte[];
                    if (imgByte != null && imgByte.Length > 0)
                    {
                        fun.FormIcon = Common.ImageLibrary.ConvertBytesToImage(imgByte);
                    }
                    if (fun == null)
                    {
                        continue;
                    }
                    module.functions.Add(fun);
                }
                if (module.functions.Count > 0)
                {
                    lst.Add(module);
                }
            }
            SortModule(lst);
            return(lst);
        }
예제 #21
0
 private frmDialogSaleEdit(DataRow row)
 {
     InitializeComponent();
     DataSource               = row;
     txtBarCode.Text          = ConvertLib.ToString(DataSource[tb_SODetail.BarCode]);
     txtItemNo.Text           = ConvertLib.ToString(DataSource[tb_SODetail.ItemNo]);
     txtItemName.Text         = ConvertLib.ToString(DataSource[tb_SODetail.ItemName]);
     txtQty.EditValue         = DataSource[tb_SODetail.Qty];
     txtUnitPrice.EditValue   = DataSource[tb_SODetail.UnitPrice];
     txtTotalAmount.EditValue = DataSource[tb_SODetail.TotalAmount];
     txtRemark.EditValue      = DataSource[tb_SODetail.Remark];
 }
예제 #22
0
        bool ValidatePwd()
        {
            string   pwd     = ConvertLib.ToString(txt_pwd.EditValue);
            bllLogin bll     = new Business.bllLogin();
            bool     Success = bll.VerifyPwdEx(Loginer.CurrentLoginer.Account, pwd);

            if (Success == false)
            {
                txt_pwd.ErrorText = "密码错误!";
            }
            return(Success);
        }
 private void btn_OK_Click(object sender, EventArgs e)
 {
     if (ConvertLib.ToString(txt_DBName.EditValue) == "")
     {
         txt_DBName.ErrorText = "名称不能为空!";
         return;
     }
     else
     {
         this.DialogResult = DialogResult.OK;
     }
 }
예제 #24
0
 /// <summary>
 /// 绑定RadioGroup组控件的数据源
 /// </summary>
 /// <param name="edit">RadioGroup组控件</param>
 /// <param name="dataSource">数据源</param>
 /// <param name="bindField">取值字段</param>
 public static void BindingRadioEdit(RadioGroup edit, DataTable dataSource, string displayMember, string valueMember)
 {
     foreach (DataRow dr in dataSource.Rows)
     {
         string strName  = ConvertLib.ToString(dr[displayMember]); //获取名称
         string strVaule = ConvertLib.ToString(dr[valueMember]);   //获取值
         DevExpress.XtraEditors.Controls.RadioGroupItem rgItem = new DevExpress.XtraEditors.Controls.RadioGroupItem()
         {
             Description = strName,
             Value       = strVaule
         };
         edit.Properties.Items.Add(rgItem);
     }
 }
예제 #25
0
        //删除
        private void btn_Delete_Click(object sender, EventArgs e)
        {
            DataRow dr = gv_Summary.GetFocusedDataRow();

            if (dr == null)
            {
                return;
            }
            string DBCode = ConvertLib.ToString(dr[sys_DataBaseList.DBCode]);

            bll.Delete(DBCode);
            gv_Summary.DeleteSelectedRows();
            Msg.ShowInformation("删除成功!");
        }
예제 #26
0
        private void btn_OK_Click(object sender, EventArgs e)
        {
            decimal amount = ConvertLib.ToDecimal(txtAmount.EditValue, 0);

            AmountIn  = ConvertLib.ToDecimal(txtIn.EditValue, 0);
            AmountOut = ConvertLib.ToDecimal(txtOut.EditValue, 0);
            if (AmountIn < amount)
            {
                Msg.ShowError("收款金额不能小于应收款");
            }
            else
            {
                this.DialogResult = DialogResult.OK;
            }
        }
예제 #27
0
        /// <summary>
        /// 验证用户名密码
        /// </summary>
        /// <param name="User"></param>
        /// <param name="Pwd"></param>
        /// <param name="dr"></param>
        /// <returns></returns>
        public Loginer VerifyPwd(string User, string Pwd, string LoginDBCode)
        {
            Pwd = PwdEncrypt(Pwd);

            SqlParameterProvider p = new SqlParameterProvider();

            p.AddParameter("@Account", SqlDbType.VarChar, User);
            p.AddParameter("@Pwd", SqlDbType.VarChar, Pwd);
            p.AddParameter("@LoginDBCode", SqlDbType.VarChar, LoginDBCode);

            DataTable dt = DataBaseFactoryEx.CreateDataBase(Loginer.CurrentLoginer.SystemDBCode).GetTableSP("usp_UserLogin", "tmp", p);

            if (dt.Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                DataRow row  = dt.Rows[0];
                Loginer user = new Loginer();
                user.Account     = (string)row[dt_MyUser.Account];
                user.UserName    = (string)row[dt_MyUser.UserName];
                user.IsSysAdmin  = Object.Equals(row[dt_MyUser.IsSysAdmain], "Y");
                user.IsSysLock   = Object.Equals(row[dt_MyUser.IsSysLock], "Y");
                user.LoginDBCode = ConvertLib.ToString(row[dt_MyUserDBs.DBCode]);
                user.IsDBAdmin   = Object.Equals(row[dt_MyUserDBs.IsDBAdmin], "Y");
                user.IsDBLock    = Object.Equals(row[dt_MyUserDBs.IsDBLock], "Y");
                if (user.IsSysAdmin && String.IsNullOrEmpty(user.LoginDBCode))
                {
                    user.LoginDBCode = LoginDBCode;
                }
                return(user);
            }
            //var v = DatabaseFactory.CreateDataBaseEx(Loginer.CurrentLoginer.SystemDBCode).ExecuteDataReader(sql, new { Account = User, Pwd = Pwd }, row =>
            //{
            //    return new Loginer()
            //    {
            //        Account = (string)row[dt_MyUser.Account],
            //        UserName = (string)row[dt_MyUser.UserName],
            //        IsDBAdmin = Object.Equals(row[dt_MyUser.IsAdmain], "Y")
            //    };
            //});

            //if (v.Count() > 0)
            //    return v.First();
            //else
            //    return null;
        }
예제 #28
0
        void LoadConfigDBList()
        {
            bllDataBaseList bll = new bllDataBaseList();
            DataTable       dt  = bll.GetUserDBList(Loginer.CurrentLoginer.Account);

            foreach (DataRow dr in dt.Rows)
            {
                string DBCode         = ConvertLib.ToString(dr[sys_DataBaseList.DBCode]);
                string DBConnection   = Encrypt.DESDecrypt(ConvertLib.ToString(dr[sys_DataBaseList.DBConnection]), Globals.KeyConnectionStr);
                string DBProviderName = ConvertLib.ToString(dr[sys_DataBaseList.DBProviderName]);
                dic.Add(DBCode, new DabaBaseModel()
                {
                    ConnnectionString = DBConnection, ProviderName = DBProviderName
                });
            }
        }
예제 #29
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="edit"></param>
 /// <param name="EmpErrorText">空值时提醒</param>
 /// <param name="EIA">ErrorIcon显示位置</param>
 /// <returns>不为空返回Ture,空返回false</returns>
 public static bool VerificationNotEmpEditValue(BaseEdit edit, string EmpErrorText, ErrorIconAlignment EIA = ErrorIconAlignment.MiddleRight)
 {
     if (edit.Visible == false)
     {
         return(true);
     }
     if (String.IsNullOrEmpty(ConvertLib.ToString(edit.EditValue)))
     {
         if (EmpErrorText != "")
         {
             edit.ErrorText          = EmpErrorText;
             edit.ErrorIconAlignment = EIA;
         }
         return(false);
     }
     return(true);
 }
        public static DialogResult ShowForm(ref string DBName)
        {
            frmDialogChangeDBText frm = new frmDialogChangeDBText();

            frm.ShowIcon      = frm.ShowInTaskbar = false;
            frm.StartPosition = FormStartPosition.CenterScreen;

            frm.txt_DBName.EditValue = DBName;


            var v = frm.ShowDialog();

            if (v == DialogResult.OK)
            {
                DBName = ConvertLib.ToString(frm.txt_DBName.EditValue);
            }
            return(v);
        }