public static void Main()
    {
        // Read the 'StockQuote.wsdl' file as input.
        ServiceDescription myServiceDescription = ServiceDescription.Read("StockQuote.wsdl");

        // Get the operation fault collection and remove the operation fault with the name 'ErrorString'.
        PortTypeCollection       myPortTypeCollection       = myServiceDescription.PortTypes;
        PortType                 myPortType                 = myPortTypeCollection[0];
        OperationCollection      myOperationCollection      = myPortType.Operations;
        Operation                myOperation                = myOperationCollection[0];
        OperationFaultCollection myOperationFaultCollection = myOperation.Faults;

        if (myOperationFaultCollection.Contains(myOperationFaultCollection["ErrorString"]))
        {
            myOperationFaultCollection.Remove(myOperationFaultCollection["ErrorString"]);
        }

        // Get the fault binding collection and remove the fault binding with the name 'ErrorString'.
// <Snippet1>
        BindingCollection          myBindingCollection          = myServiceDescription.Bindings;
        Binding                    myBinding                    = myBindingCollection[0];
        OperationBindingCollection myOperationBindingCollection = myBinding.Operations;
        OperationBinding           myOperationBinding           = myOperationBindingCollection[0];
        FaultBindingCollection     myFaultBindingCollection     = myOperationBinding.Faults;

        if (myFaultBindingCollection.Contains(myFaultBindingCollection["ErrorString"]))
        {
            myFaultBindingCollection.Remove(myFaultBindingCollection["ErrorString"]);
        }
// </Snippet1>

        myServiceDescription.Write(Console.Out);
    }
示例#2
0
 /// <summary>
 /// get all productionformmaterial
 /// <summary>
 /// <param name=formid>formid</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all productionformmaterial</returns>
 public BindingCollection <modProductionFormMaterial> GetProductionFormMaterial(string formid, out string emsg)
 {
     try
     {
         BindingCollection <modProductionFormMaterial> modellist = new BindingCollection <modProductionFormMaterial>();
         //Execute a query to read the categories
         string sql = string.Format("select form_id,seq,product_id,product_name,specify,size,qty,cost_price,warehouse_id,remark from production_form_material where form_id='{0}' order by form_id,seq", formid);
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modProductionFormMaterial model = new modProductionFormMaterial();
                 model.FormId      = dalUtility.ConvertToString(rdr["form_id"]);
                 model.Seq         = dalUtility.ConvertToInt(rdr["seq"]);
                 model.ProductId   = dalUtility.ConvertToString(rdr["product_id"]);
                 model.ProductName = dalUtility.ConvertToString(rdr["product_name"]);
                 model.Specify     = dalUtility.ConvertToString(rdr["specify"]);
                 model.Size        = dalUtility.ConvertToDecimal(rdr["size"]);
                 model.Qty         = dalUtility.ConvertToDecimal(rdr["qty"]);
                 model.CostPrice   = dalUtility.ConvertToDecimal(rdr["cost_price"]);
                 model.WarehouseId = dalUtility.ConvertToString(rdr["warehouse_id"]);
                 model.Remark      = dalUtility.ConvertToString(rdr["remark"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
        private Dictionary <string, BindingCollection> MergeBindings(IEnumerable <DefaultBinding> bindingSets)
        {
            var final = new Dictionary <string, BindingCollection>();

            foreach (var bindingSet in bindingSets)
            {
                foreach (KeyValuePair <string, BindingCollection> kvp in bindingSet.bindings)
                {
                    string            actionSetName = kvp.Key;
                    BindingCollection bindings      = kvp.Value;

                    if (!final.ContainsKey(actionSetName))
                    {
                        final.Add(actionSetName, new BindingCollection());
                    }

                    final[actionSetName].chords.AddRange(bindings.chords);
                    final[actionSetName].haptics.AddRange(bindings.haptics);
                    final[actionSetName].poses.AddRange(bindings.poses);
                    final[actionSetName].skeleton.AddRange(bindings.skeleton);
                    final[actionSetName].sources.AddRange(bindings.sources);
                }
            }

            return(final);
        }
示例#4
0
        public void Test_Create_Collection_With_Null_Array()
        {
            IBindingCollection collection = new BindingCollection(null);

            Assert.Equal(0, collection.TypeCount);
            Assert.Equal(0, collection.BindingCount);
        }
示例#5
0
        public static void SetFormStatus(Form frm)
        {
            dalTaskGrant bll = new dalTaskGrant();
            BindingCollection <modTaskGrant> grantlist = bll.GetUserGrantData(true, false, Util.UserId, string.Empty, string.Empty, out Util.emsg);

            foreach (Control ctl in frm.Controls)
            {
                if (ctl.GetType().ToString() == "LXMS.ButtonEx" || ctl.GetType().ToString() == "System.Windows.Forms.LinkLabel")
                {
                    ctl.Enabled = false;
                    foreach (modTaskGrant mod in grantlist)
                    {
                        if (mod.Url.CompareTo(ctl.Name) == 0)
                        {
                            ctl.Enabled = true;
                            break;
                        }
                    }
                }
                else
                {
                    SetSubControlStatus(ctl, grantlist);
                }
            }
        }
示例#6
0
 public void LoadData()
 {
     try
     {
         this.Cursor = Cursors.WaitCursor;
         DBGrid.Rows.Clear();
         BindingCollection <modAccProfitReport> list = _dal.GetAccProfitReport(cboAccName.ComboBox.SelectedValue.ToString(), Util.IsTrialBalance, out Util.emsg);
         DBGrid.DataSource = list;
         if (list != null && list.Count > 0)
         {
             DBGrid.AlternatingRowsDefaultCellStyle.BackColor            = Color.Empty;
             DBGrid.Rows[DBGrid.RowCount - 1].DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;
             DBGrid.Rows[DBGrid.RowCount - 1].DefaultCellStyle.ForeColor = Color.Red;
             DBGrid.Columns["ThisMonth"].DefaultCellStyle.Alignment      = DataGridViewContentAlignment.MiddleRight;
             DBGrid.Columns["ThisYear"].DefaultCellStyle.Alignment       = DataGridViewContentAlignment.MiddleRight;
             DBGrid.Columns["AdFlag"].DefaultCellStyle.Alignment         = DataGridViewContentAlignment.MiddleRight;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
示例#7
0
 /// <summary>
 /// get all sysparameters
 /// <summary>
 /// <param name=paraid>paraid</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all sysparameters</returns>
 public BindingCollection <modSysParameters> GetIList(string paraid, out string emsg)
 {
     try
     {
         BindingCollection <modSysParameters> modellist = new BindingCollection <modSysParameters>();
         //Execute a query to read the categories
         string sql = string.Format("select para_id,para_name,para_value,remark,update_user,update_time from sys_parameters where para_id='{0}' order by para_id", paraid);
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modSysParameters model = new modSysParameters();
                 model.ParaId     = dalUtility.ConvertToString(rdr["para_id"]);
                 model.ParaName   = dalUtility.ConvertToString(rdr["para_name"]);
                 model.ParaValue  = dalUtility.ConvertToString(rdr["para_value"]);
                 model.Remark     = dalUtility.ConvertToString(rdr["remark"]);
                 model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime = dalUtility.ConvertToString(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#8
0
        /// <summary>
        /// audit production form
        /// <summary>
        /// <param name=formid>formid</param>
        /// <param name=updateuser>updateuser</param>
        /// <param name=out emsg>return error message</param>
        /// <returns>true/false</returns>
        public bool Audit(string formid, string updateuser, out string emsg)
        {
            string        sql  = string.Empty;
            SqlConnection conn = SqlHelper.getConn();

            conn.Open();
            SqlTransaction trans = conn.BeginTransaction();
            SqlCommand     cmd   = new SqlCommand();

            try
            {
                modProductionForm mod = GetItem(formid, out emsg);
                if (mod.Status == 1)
                {
                    emsg = "这张单据已经审核,您无须再审";
                    return(false);
                }
                BindingCollection <modProductionFormWare> listware = GetProductionFormWare(formid, out emsg);
                if (listware != null && listware.Count > 0)
                {
                    foreach (modProductionFormWare modware in listware)
                    {
                        sql = string.Format("insert into warehouse_product_inout(warehouse_id,product_id,size,form_id,form_type,inv_no,inout_date,start_qty,input_qty,output_qty,remark,update_user,update_time)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',getdate())", modware.WarehouseId, modware.ProductId, modware.Size, formid, mod.FormType, mod.No, mod.FormDate, 0, modware.Qty, 0, modware.Remark, updateuser);
                        SqlHelper.PrepareCommand(cmd, conn, trans, CommandType.Text, sql, null);
                        cmd.ExecuteNonQuery();
                    }
                }
                BindingCollection <modProductionFormMaterial> listmaterial = GetProductionFormMaterial(formid, out emsg);
                if (listmaterial != null && listmaterial.Count > 0)
                {
                    foreach (modProductionFormMaterial modmaterial in listmaterial)
                    {
                        sql = string.Format("insert into warehouse_product_inout(warehouse_id,product_id,size,form_id,form_type,inv_no,inout_date,start_qty,input_qty,output_qty,remark,update_user,update_time)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',getdate())", modmaterial.WarehouseId, modmaterial.ProductId, modmaterial.Size, formid, mod.FormType, mod.No, mod.FormDate, 0, 0, modmaterial.Qty, modmaterial.Remark, updateuser);
                        SqlHelper.PrepareCommand(cmd, conn, trans, CommandType.Text, sql, null);
                        cmd.ExecuteNonQuery();
                    }
                }
                sql = string.Format("update production_form set status={0},audit_man='{1}',audit_time=getdate() where form_id='{2}'", 1, updateuser, formid);
                SqlHelper.PrepareCommand(cmd, conn, trans, CommandType.Text, sql, null);
                cmd.ExecuteNonQuery();
                trans.Commit();
                emsg = string.Empty;
                return(true);
            }
            catch (Exception ex)
            {
                trans.Rollback();
                emsg = dalUtility.ErrorMessage(ex.Message);
                return(false);
            }
            finally
            {
                trans.Dispose();
                cmd.Dispose();
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Dispose();
                }
            }
        }
示例#9
0
 private void LoadTree()
 {
     try
     {
         this.Cursor      = Cursors.WaitCursor;
         tvLeft.AllowDrop = true;
         tvLeft.Nodes.Clear();
         tvLeft.ImageList = Util.GetImageList();
         dalProductTypeList dal = new dalProductTypeList();
         BindingCollection <modProductTypeList> list = dal.GetIList(true, out Util.emsg);
         if (list != null)
         {
             foreach (modProductTypeList mod in list)
             {
                 tvLeft.Nodes.Add(mod.ProductType, mod.ProductType, 0, 1);
             }
             if (tvLeft.Nodes.Count > 0)
             {
                 tvLeft.SelectedNode = tvLeft.Nodes[0];
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
示例#10
0
 private void LoadData()
 {
     try
     {
         this.Cursor = Cursors.WaitCursor;
         BindingCollection <modAccCredenceSummary> list = _dal.GetCredenceSummary(cboAccName.ComboBox.SelectedValue.ToString(), Util.IsTrialBalance, out Util.emsg);
         DBGrid.DataSource = list;
         if (list == null && !string.IsNullOrEmpty(Util.emsg))
         {
             MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
             return;
         }
         else
         {
             DBGrid.Columns["BorrowMoney"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
             DBGrid.Columns["LendMoney"].DefaultCellStyle.Alignment   = DataGridViewContentAlignment.MiddleRight;
             DBGrid.Columns["BorrowMoney"].Width = 140;
             DBGrid.Columns["LendMoney"].Width   = 140;
             DBGrid.AlternatingRowsDefaultCellStyle.BackColor            = Color.Empty;
             DBGrid.Rows[DBGrid.RowCount - 1].DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;
             modAccCredenceSummary mod = (modAccCredenceSummary)DBGrid.Rows[DBGrid.RowCount - 1].DataBoundItem;
             Status1.Text = clsTranslate.TranslateString("Borrow Money") + ": " + mod.BorrowMoney;
             Status2.Text = clsTranslate.TranslateString("Lend Money") + ": " + mod.LendMoney;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
示例#11
0
        public void LoadPriceData(string productid)
        {
            dalProductSalePrice dal = new dalProductSalePrice();
            BindingCollection <modProductSalePrice> list = dal.GetProductSalePrice(productid, out Util.emsg);

            DBGridPrice.DataSource = list;
            if (list != null)
            {
                DBGridPrice.Columns["ProductId"].Visible  = false;
                DBGridPrice.Columns["UpdateUser"].Visible = false;
                DBGridPrice.Columns["UpdateTime"].Visible = false;

                DBGridPrice.ReadOnly = false;
                DBGridPrice.Columns["CustLevel"].Width = 80;
                DBGridPrice.Columns["Price"].Width     = 100;
                DBGridPrice.Columns["Price"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                DBGridPrice.Columns["CustLevel"].ReadOnly                   = true;
                DBGridPrice.Columns["Price"].ReadOnly                       = false;
                DBGridPrice.AlternatingRowsDefaultCellStyle.BackColor       = Color.Empty;
                DBGridPrice.Columns["CustLevel"].DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;

                if (DBGridPrice.RowCount > 0)
                {
                    DBGridPrice.CurrentCell = DBGridPrice.Rows[0].Cells["Price"];
                }
            }
        }
示例#12
0
        private void toolSavePrice_Click(object sender, EventArgs e)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                DBGridPrice.EndEdit();

                dalProductSalePrice dal = new dalProductSalePrice();
                BindingCollection <modProductSalePrice> list = (BindingCollection <modProductSalePrice>)DBGridPrice.DataSource;
                bool ret = dal.Save(list, out Util.emsg);
                if (ret)
                {
                    MessageBox.Show("数据保存成功!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
示例#13
0
 /// <summary>
 /// get all accreceivablelist
 /// <summary>
 /// <param name=accname>accname</param>
 /// <param name=currency>currency</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all accreceivablelist</returns>
 public BindingCollection <modStartReceivable> GetStartReceivable(string accname, string currency, decimal exchange_rate, out string emsg)
 {
     try
     {
         BindingCollection <modStartReceivable> modellist = new BindingCollection <modStartReceivable>();
         //Execute a query to read the categories
         string sql = string.Format("select a.cust_id,a.cust_name,isnull(b.start_mny,0) start_mny from customer_list a left join "
                                    + "(select cust_id,currency,start_mny,exchange_rate from acc_receivable_list where acc_name='{0}' and seq=0 and currency='{1}') b on a.cust_id=b.cust_id where a.currency='{2}'", accname, currency, currency);
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modStartReceivable model = new modStartReceivable();
                 model.AccName      = accname;
                 model.CustId       = dalUtility.ConvertToString(rdr["cust_id"]);
                 model.CustName     = dalUtility.ConvertToString(rdr["cust_name"]);
                 model.Currency     = currency;
                 model.ExchangeRate = exchange_rate;
                 model.StartMny     = dalUtility.ConvertToDecimal(rdr["start_mny"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#14
0
        private void LoadData()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                BindingCollection <modCustReceivableSummary> list = _dal.GetCustReceivableSummary(cboAccName.ComboBox.SelectedValue.ToString(), out Util.emsg);
                DBGrid.DataSource = list;
                if (list == null && !string.IsNullOrEmpty(Util.emsg))
                {
                    MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    return;
                }
                else
                {
                    DBGrid.Columns[0].Visible = false;
                    DBGrid.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                    DBGrid.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                    DBGrid.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                    DBGrid.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                    DBGrid.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;

                    DBGrid.AlternatingRowsDefaultCellStyle.BackColor            = Color.Empty;
                    DBGrid.Rows[DBGrid.RowCount - 1].DefaultCellStyle.BackColor = frmOptions.ALTERNATING_BACKCOLOR;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
示例#15
0
 private void mnuDetail_Click(object sender, EventArgs e)
 {
     try
     {
         this.Cursor = Cursors.WaitCursor;
         if (DBGrid.CurrentRow == null)
         {
             return;
         }
         BindingCollection <modAccReceivableList> list = _dal.GetIList(cboAccName.ComboBox.SelectedValue.ToString(), DBGrid.CurrentRow.Cells["custid"].Value.ToString(), out Util.emsg);
         if (list != null && list.Count > 0)
         {
             frmViewList frm = new frmViewList();
             frm.InitViewList(list[0].CustName, list);
             frm.ShowDialog();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
示例#16
0
 /// <summary>
 /// get all accperiodlist
 /// <summary>
 /// <param name=accyear>accyear</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all accperiodlist</returns>
 public BindingCollection <modAccPeriodList> GetIList(out string emsg)
 {
     try
     {
         BindingCollection <modAccPeriodList> modellist = new BindingCollection <modAccPeriodList>();
         //Execute a query to read the categories
         string sql = "select acc_name,seq,acc_year,acc_month,start_date,end_date,cost_flag,lock_flag,employee_count,update_user,update_time from acc_period_list order by seq desc";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modAccPeriodList model = new modAccPeriodList();
                 model.AccName       = dalUtility.ConvertToString(rdr["acc_name"]);
                 model.Seq           = dalUtility.ConvertToInt(rdr["seq"]);
                 model.AccYear       = dalUtility.ConvertToInt(rdr["acc_year"]);
                 model.AccMonth      = dalUtility.ConvertToInt(rdr["acc_month"]);
                 model.StartDate     = dalUtility.ConvertToDateTime(rdr["start_date"]);
                 model.EndDate       = dalUtility.ConvertToDateTime(rdr["end_date"]);
                 model.CostFlag      = dalUtility.ConvertToInt(rdr["cost_flag"]);
                 model.LockFlag      = dalUtility.ConvertToInt(rdr["lock_flag"]);
                 model.EmployeeCount = dalUtility.ConvertToInt(rdr["employee_count"]);
                 model.UpdateUser    = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime    = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#17
0
        internal FPageGridColumnsSetting(Control parentControl, DataGridView dgv,
                                         Func <string> getColSettingFilePath, Action <string, bool> columnVisibleChangedNotify)
            : this()
        {
            this._parentControl              = parentControl;
            this._dgv                        = dgv;
            this._getColSettingFilePath      = getColSettingFilePath;
            this._columnVisibleChangedNotify = columnVisibleChangedNotify;

            this._columnSettingInfoList  = new BindingCollection <ColumnSettingInfo>(this);
            this._dgv.DataSourceChanged += this.DataSourceChanged;

            this.TopLevel               = false;
            this.Dock                   = DockStyle.Fill;
            this.IsAllowMinimize        = false;
            this.IsUseInOutEffect       = false;
            this._lastParentControlSize = new Size(100, 100);

            this.dgvColumnSetting.DataSource = this._columnSettingInfoList.DataSource;
            this.dgvColumnSetting.Columns[this.dgvColumnSetting.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

            this.Visible = true;
            this.SwitchColumnSettingDockStatus(this._columnSettingDockStatus, PageGridColumnSettingStatus.Dock);

            dgvColumnSetting.LostFocus += DgvColumnSetting_LostFocus;
        }
示例#18
0
 /// <summary>
 /// get all acccommondigest
 /// <summary>
 /// <param name=digesttypelist>digesttypelist</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all acccommondigest</returns>
 public BindingCollection <modAccCommonDigest> GetIList(string digesttypelist, out string emsg)
 {
     try
     {
         BindingCollection <modAccCommonDigest> modellist = new BindingCollection <modAccCommonDigest>();
         //Execute a query to read the categories
         string digesttypewhere = string.Empty;
         if (!string.IsNullOrEmpty(digesttypelist) && digesttypelist.CompareTo("ALL") != 0)
         {
             digesttypewhere = "and digest_type in ('" + digesttypelist.Replace(",", "','") + "') ";
         }
         string sql = "select digest,digest_type,update_user,update_time from acc_common_digest where 1=1 " + digesttypewhere + "order by digest_type, digest";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modAccCommonDigest model = new modAccCommonDigest();
                 model.Digest     = dalUtility.ConvertToString(rdr["digest"]);
                 model.DigestType = dalUtility.ConvertToString(rdr["digest_type"]);
                 model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#19
0
        private void LoadData()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                if (cboAccName.SelectedIndex == -1)
                {
                    return;
                }
                DBGrid.toolCancelFrozen_Click(null, null);

                modAccPeriodList modPeriod = (modAccPeriodList)cboAccName.SelectedItem;
                BindingCollection <modAccCredenceList> list = _dal.GetIList(modPeriod.AccName, string.Empty, Util.IsTrialBalance, out Util.emsg);
                DBGrid.DataSource = list;
                if (list == null && !string.IsNullOrEmpty(Util.emsg))
                {
                    MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
                else
                {
                    AddComboBoxColumns();
                    for (int i = 0; i < list.Count; i++)
                    {
                        if (list[i].Status == 1)
                        {
                            DBGrid.Rows[i].DefaultCellStyle.ForeColor = Color.DarkGray;
                        }
                    }
                    if (modPeriod.LockFlag == 1 || Util.IsTrialBalance)
                    {
                        toolNew.Visible     = false;
                        toolEdit.Visible    = false;
                        toolDel.Visible     = false;
                        toolAudit.Visible   = false;
                        toolReset.Visible   = false;
                        toolTrial.Visible   = false;
                        toolBalance.Visible = false;
                    }
                    else
                    {
                        toolNew.Visible     = true;
                        toolEdit.Visible    = true;
                        toolDel.Visible     = true;
                        toolAudit.Visible   = true;
                        toolReset.Visible   = true;
                        toolTrial.Visible   = true;
                        toolBalance.Visible = true;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
示例#20
0
 private void LoadData()
 {
     try
     {
         this.Cursor = Cursors.WaitCursor;
         DBGrid.toolCancelFrozen_Click(null, null);
         BindingCollection <modAccOtherReceivableForm> list = _dal.GetIList(rbStatus0.Checked ? "0" : "1", string.Empty, string.Empty, rbStatus0.Checked ? string.Empty : dtpFrom.Text, rbStatus0.Checked ? string.Empty : dtpTo.Text, out Util.emsg);
         DBGrid.DataSource = list;
         if (list == null && !string.IsNullOrEmpty(Util.emsg))
         {
             MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
         }
         else
         {
             AddComboBoxColumns();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     finally
     {
         this.Cursor = Cursors.Default;
     }
 }
示例#21
0
        /// <summary>
        /// get new credence list
        /// <summary>
        /// <param name=fromdate>fromdate</param>
        /// <param name=todate>todate</param>
        /// <param name=out emsg>return error message</param>
        ///<returns>details of all salesshipment</returns>
        public BindingCollection <modAccReceivableForm> GetWaitCredenceList(string fromdate, string todate, out string emsg)
        {
            try
            {
                BindingCollection <modAccReceivableForm> modellist = new BindingCollection <modAccReceivableForm>();
                //Execute a query to read the categories
                string formdatewhere = string.Empty;
                if (!string.IsNullOrEmpty(fromdate))
                {
                    formdatewhere = "and a.form_date >= '" + Convert.ToDateTime(fromdate) + "' ";
                }
                if (!string.IsNullOrEmpty(todate))
                {
                    formdatewhere += "and a.form_date <= '" + Convert.ToDateTime(todate) + "' ";
                }

                string sql = "select a.id,a.status,a.form_date,a.no,a.cust_id,b.cust_name,a.currency,a.exchange_rate,a.get_mny,a.receivable_mny,a.subject_id,c.subject_name,a.detail_id,a.detail_name,a.check_no,a.check_type,a.bank_name,a.promise_date,a.remark,a.update_user,a.update_time,a.audit_man,a.audit_time,a.acc_name,a.acc_seq "
                             + "from acc_receivable_form a inner join customer_list b on a.cust_id=b.cust_id inner join acc_subject_list c on a.subject_id=c.subject_id where a.status=1 and (a.acc_name is null or a.acc_name='') and a.acc_seq=0 " + formdatewhere + " order by a.id";
                using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
                {
                    while (rdr.Read())
                    {
                        modAccReceivableForm model = new modAccReceivableForm();
                        model.Id            = dalUtility.ConvertToInt(rdr["id"]);
                        model.Status        = dalUtility.ConvertToInt(rdr["status"]);
                        model.FormDate      = dalUtility.ConvertToDateTime(rdr["form_date"]);
                        model.No            = dalUtility.ConvertToString(rdr["no"]);
                        model.CustId        = dalUtility.ConvertToString(rdr["cust_id"]);
                        model.CustName      = dalUtility.ConvertToString(rdr["cust_name"]);
                        model.Currency      = dalUtility.ConvertToString(rdr["currency"]);
                        model.ExchangeRate  = dalUtility.ConvertToDecimal(rdr["exchange_rate"]);
                        model.GetMny        = dalUtility.ConvertToDecimal(rdr["get_mny"]);
                        model.ReceivableMny = dalUtility.ConvertToDecimal(rdr["receivable_mny"]);
                        model.SubjectId     = dalUtility.ConvertToString(rdr["subject_id"]);
                        model.SubjectName   = dalUtility.ConvertToString(rdr["subject_name"]);
                        model.DetailId      = dalUtility.ConvertToString(rdr["detail_id"]);
                        model.DetailName    = dalUtility.ConvertToString(rdr["detail_name"]);
                        model.CheckNo       = dalUtility.ConvertToString(rdr["check_no"]);
                        model.CheckType     = dalUtility.ConvertToString(rdr["check_type"]);
                        model.BankName      = dalUtility.ConvertToString(rdr["bank_name"]);
                        model.PromiseDate   = dalUtility.ConvertToDateTime(rdr["promise_date"]);
                        model.Remark        = dalUtility.ConvertToString(rdr["remark"]);
                        model.UpdateUser    = dalUtility.ConvertToString(rdr["update_user"]);
                        model.UpdateTime    = dalUtility.ConvertToDateTime(rdr["update_time"]);
                        model.AuditMan      = dalUtility.ConvertToString(rdr["audit_man"]);
                        model.AuditTime     = dalUtility.ConvertToDateTime(rdr["audit_time"]);
                        model.AccName       = dalUtility.ConvertToString(rdr["acc_name"]);
                        model.AccSeq        = dalUtility.ConvertToInt(rdr["acc_seq"]);
                        modellist.Add(model);
                    }
                }
                emsg = null;
                return(modellist);
            }
            catch (Exception ex)
            {
                emsg = dalUtility.ErrorMessage(ex.Message);
                return(null);
            }
        }
示例#22
0
 /// <summary>
 /// update price of production form
 /// <summary>
 /// <param name=mod>model object of production form</param>
 /// <param name=out emsg>return error message</param>
 /// <returns>true/false</returns>
 public bool UpdatePrice(BindingCollection <modProductionFormWare> listware, BindingCollection <modProductionFormMaterial> listmaterial, decimal detailsum, decimal processmny, string updateuser, out string emsg)
 {
     using (TransactionScope transaction = new TransactionScope())//使用事务
     {
         try
         {
             string sql = string.Empty;
             foreach (modProductionFormWare modware in listware)
             {
                 sql = string.Format("update production_form_ware set cost_price={0} where form_id='{1}' and seq='{2}'", modware.CostPrice, modware.FormId, modware.Seq);
                 SqlHelper.ExecuteNonQuery(sql);
             }
             foreach (modProductionFormMaterial modmaterial in listmaterial)
             {
                 sql = string.Format("update production_form_material set cost_price={0} where form_id='{1}' and seq='{2}'", modmaterial.CostPrice, modmaterial.FormId, modmaterial.Seq);
                 SqlHelper.ExecuteNonQuery(sql);
             }
             sql = string.Format("update production_form set detail_sum={0},process_mny={1},price_status={2},audit_man='{3}',audit_time=getdate() where form_id='{4}'", detailsum, processmny, 1, updateuser, listware[0].FormId);
             SqlHelper.ExecuteNonQuery(sql);
             transaction.Complete();//就这句就可以了。
             emsg = string.Empty;
             return(true);
         }
         catch (Exception ex)
         {
             emsg = dalUtility.ErrorMessage(ex.Message);
             return(false);
         }
     }
 }
示例#23
0
 /// <summary>
 /// get all accbalancestyle
 /// <summary>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all accbalancestyle</returns>
 public BindingCollection <modAccBalanceStyle> GetIList(out string emsg)
 {
     try
     {
         BindingCollection <modAccBalanceStyle> modellist = new BindingCollection <modAccBalanceStyle>();
         //Execute a query to read the categories
         string sql = "select balance_style,update_user,update_time from acc_balance_style order by balance_style";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modAccBalanceStyle model = new modAccBalanceStyle();
                 model.BalanceStyle = dalUtility.ConvertToString(rdr["balance_style"]);
                 model.UpdateUser   = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime   = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#24
0
 /// <summary>
 /// get all customertype
 /// <summary>
 /// <param name=validonly>status is valid</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all customertype</returns>
 public BindingCollection <modCustomerType> GetIList(bool validonly, out string emsg)
 {
     try
     {
         BindingCollection <modCustomerType> modellist = new BindingCollection <modCustomerType>();
         //Execute a query to read the categories
         string getwhere = validonly == true ? "and status=1" : string.Empty;
         string sql      = "select cust_type,status,update_user,update_time from customer_type where 1=1 " + getwhere + "order by cust_type";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modCustomerType model = new modCustomerType(dalUtility.ConvertToString(rdr["cust_type"]), dalUtility.ConvertToInt(rdr["status"]), dalUtility.ConvertToString(rdr["update_user"]), dalUtility.ConvertToDateTime(rdr["update_time"]));
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#25
0
 /// <summary>
 /// get all acccurrencylist
 /// <summary>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all acccurrencylist</returns>
 public BindingCollection <modAccCurrencyList> GetIList(out string emsg)
 {
     try
     {
         BindingCollection <modAccCurrencyList> modellist = new BindingCollection <modAccCurrencyList>();
         //Execute a query to read the categories
         string sql = "select currency,exchange_rate,owner_flag,update_user,update_time from acc_currency_list order by owner_flag desc,currency";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modAccCurrencyList model = new modAccCurrencyList();
                 model.Currency     = dalUtility.ConvertToString(rdr["currency"]);
                 model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]);
                 model.OwnerFlag    = dalUtility.ConvertToInt(rdr["owner_flag"]);
                 model.UpdateUser   = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime   = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#26
0
 public static void SetSubControlStatus(Control ctl, BindingCollection <modTaskGrant> grantlist)
 {
     if (ctl.Controls.Count > 0)
     {
         foreach (Control ch in ctl.Controls)
         {
             if (ch.GetType().ToString() == "LXMS.ButtonEx" || ch.GetType().ToString() == "System.Windows.Forms.LinkLabel")
             {
                 ch.Enabled = false;
                 foreach (modTaskGrant mod in grantlist)
                 {
                     if (mod.Url.CompareTo(ch.Name) == 0)
                     {
                         ch.Enabled = true;
                         break;
                     }
                 }
             }
             else
             {
                 SetSubControlStatus(ch, grantlist);
             }
         }
     }
 }
示例#27
0
 /// <summary>
 /// get web grant form name list
 /// <summary>
 /// <param name=userid>userid</param>
 /// <param name=groupidlist>groupidlist</param>
 ///<returns>get granted data by userid</returns>
 public string GetWebGrantForm(string userid, out string emsg)
 {
     try
     {
         System.Text.StringBuilder        sb        = new System.Text.StringBuilder();
         BindingCollection <modTaskGrant> modellist = new BindingCollection <modTaskGrant>();
         string sql = string.Format("select a.form_name from sys_task_list a,sys_task_grant b where a.task_code=b.task_code and b.role_id='{0}' "
                                    + "union select a.form_name from sys_task_list a,sys_task_grant b,sys_user_list c where a.task_code=b.task_code and b.role_id=c.role_id "
                                    + "and a.status=1 and c.user_id='{1}' ", userid, userid);
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 sb.Append(rdr[0].ToString());
                 sb.Append(";");
             }
             emsg = string.Empty;
             return(sb.ToString());
         }
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#28
0
 /// <summary>
 /// get all customerscorerule
 /// <summary>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all customerscorerule</returns>
 public BindingCollection <modCustomerScoreRule> GetIList(string traceflaglist, out string emsg)
 {
     try
     {
         BindingCollection <modCustomerScoreRule> modellist = new BindingCollection <modCustomerScoreRule>();
         //Execute a query to read the categories
         string traceflagwhere = string.Empty;
         if (!string.IsNullOrEmpty(traceflaglist) && traceflaglist.CompareTo("ALL") != 0)
         {
             traceflagwhere = "and trace_flag in ('" + traceflaglist.Replace(",", "','") + "') ";
         }
         string sql = "select action_code,action_type,scores,trace_flag,update_user,update_time from customer_score_rule where 1=1 " + traceflagwhere + " order by seq";
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modCustomerScoreRule model = new modCustomerScoreRule();
                 model.ActionCode = dalUtility.ConvertToString(rdr["action_code"]);
                 model.ActionType = dalUtility.ConvertToString(rdr["action_type"]);
                 model.Scores     = dalUtility.ConvertToDecimal(rdr["scores"]);
                 model.TraceFlag  = dalUtility.ConvertToInt(rdr["trace_flag"]);
                 model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#29
0
 /// <summary>
 /// get all assetworkqty
 /// <summary>
 /// <param name=accname>accname</param>
 /// <param name=out emsg>return error message</param>
 ///<returns>details of all assetworkqty</returns>
 public BindingCollection <modAssetWorkQty> GetIList(string accname, out string emsg)
 {
     try
     {
         BindingCollection <modAssetWorkQty> modellist = new BindingCollection <modAssetWorkQty>();
         //Execute a query to read the categories
         string sql = string.Format("select a.asset_id,b.asset_name,a.acc_name,a.work_qty,a.remark,a.update_user,a.update_time from asset_work_qty a inner join asset_list b on a.asset_id=b.asset_id where a.acc_name='{0}' order by a.asset_id,a.acc_name", accname);
         using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
         {
             while (rdr.Read())
             {
                 modAssetWorkQty model = new modAssetWorkQty();
                 model.AssetId    = dalUtility.ConvertToString(rdr["asset_id"]);
                 model.AssetName  = dalUtility.ConvertToString(rdr["asset_name"]);
                 model.AccName    = dalUtility.ConvertToString(rdr["acc_name"]);
                 model.WorkQty    = dalUtility.ConvertToDecimal(rdr["work_qty"]);
                 model.Remark     = dalUtility.ConvertToString(rdr["remark"]);
                 model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
                 model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
                 modellist.Add(model);
             }
         }
         emsg = null;
         return(modellist);
     }
     catch (Exception ex)
     {
         emsg = dalUtility.ErrorMessage(ex.Message);
         return(null);
     }
 }
示例#30
0
        public void Test_Create_Empty_Collection()
        {
            IBindingCollection collection = new BindingCollection();

            Assert.Equal(0, collection.TypeCount);
            Assert.Equal(0, collection.BindingCount);
        }
 public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
 {
     var ctx = value as CommandContext;
     if (ctx == null) return null;
     BindingCollection<object> result = new BindingCollection<object>();
     ctx.PropertyChanged += (s, e) => result.Load(Load(ctx));
     result.Load(Load(ctx));
     return result;
 }
 internal Binding(string protocol, string bindingInformation, byte[] hash, string store, SslFlags flags, BindingCollection parent)
     : base(null, "binding", null, parent, null, null)
 {
     BindingInformation = bindingInformation;
     Protocol = protocol;
     CertificateHash = hash;
     CertificateStoreName = store;
     SslFlags = flags;
     Parent = parent;
 }
示例#33
0
 /// <summary>
 /// Initializes a new instance of the <see cref="MultiBinding"/> class.
 /// </summary>
 public MultiBinding()
 {
     Bindings = new BindingCollection ();
     _curBindingCount = 0;
 }
 public Binding(ConfigurationElement element, BindingCollection parent)
     : base(element, null, null, parent, null, null)
 {
     Parent = parent;
 }
示例#35
0
        public static ArrayList GetAllBindings(BindingCollection bindings)
        {
            ArrayList list = new ArrayList();
            int num = 0;
            foreach (Binding binding in bindings)
            {
                PropertyBag bag = new PropertyBag();
                bag[FtpSiteGlobals.BindingProtocol] = binding.Protocol;
                bag[FtpSiteGlobals.BindingInformation] = binding.BindingInformation;
				bag[FtpSiteGlobals.BindingIndex] = num;
                list.Add(bag);
                num++;
            }
            return list;
        }
示例#36
0
 public static ArrayList GetFtpBindings(BindingCollection bindings)
 {
     ArrayList list = new ArrayList();
     foreach (Binding binding in bindings)
     {
         if (string.Equals(binding.Protocol.Trim(), "ftp", StringComparison.OrdinalIgnoreCase))
         {
             list.Add(binding.BindingInformation);
         }
     }
     return list;
 }
示例#37
0
		private List<IPBindingDesiredState> GetBindings(BindingCollection bindings)
		{
			var siteBindingList = new List<IPBindingDesiredState>();

			foreach (var binding in bindings)
			{
				if (binding.Protocol.ToLower().StartsWith("http"))
				{
					var b = new IPBindingDesiredState(binding);

					siteBindingList.Add(b);
				}
			}

			return siteBindingList;
		}
示例#38
0
    //----------------------------------------------------- 
    //
    //  Constructors 
    //
    //-----------------------------------------------------

    /// <summary> Constructor </summary> 
    public PriorityBinding() : base()
    { 
        _bindingCollection = new BindingCollection(this, new BindingCollectionChangedCallback(OnBindingCollectionChanged)); 
    }
示例#39
0
    //-----------------------------------------------------
    // 
    //  Constructors
    // 
    //----------------------------------------------------- 

    /// <summary> Default constructor </summary> 
    public MultiBinding()
    {
        _bindingCollection = new BindingCollection(this, new BindingCollectionChangedCallback(OnBindingCollectionChanged));
    } 
示例#40
0
 //--------------------------------------------------------------
 /// <summary>
 /// Initializes a new instance of the <see cref="MultiBinding"/> class.
 /// </summary>
 public MultiBinding()
 {
     Bindings = new BindingCollection();
 }
 public void ModificarUsuario(string p, BindingCollection.UsuarioView user)
 {
     throw new NotImplementedException();
 }
		void DoBindings (IScriptObject owner, BindingCollection bindings)
		{
			Assert.AreEqual (owner, ((IScriptObject)bindings).Owner, "A4");
			Assert.AreEqual (0, bindings.Count, "b1");
			Assert.AreEqual ("", ((IScriptObject)bindings).ID, "b2");
		}
示例#43
0
		/// <summary>
		/// Unbinds any bindings in the <see cref="Bindings"/> collection and removes the bindings
		/// </summary>
		public virtual void Unbind ()
		{
			if (bindings != null) {
				bindings.Unbind();
				bindings = null;
			}
		}