Example #1
0
 private void setData(int row, int col)
 {
     if (!string.IsNullOrEmpty(dataGridViewX1.Rows[row].Cells["sum"].Value.ToString()))
     {
         int s = 1;
         int.TryParse(dataGridViewX1.Rows[row].Cells["sum"].Value.ToString(), out s);
         if (s == 0)
         {
             MessageBox.Show("数量不能是零!");
             return;
         }
     }
     Maptool.soso.Link_Mid m = new soso.Link_Mid();
     m.id        = (int)dataGridViewX1.Rows[row].Cells["linkid"].Value;
     m.iden      = Convert.ToInt32(iden_lab.Text);
     m.Sum       = string.IsNullOrEmpty(dataGridViewX1.Rows[row].Cells["sum"].Value.ToString()) ? 1 : (int)dataGridViewX1.Rows[row].Cells["sum"].Value;
     m.StockType = GetUnitNo(dataGridViewX1.Rows[row].Cells["stocktypes"].Value.ToString());
     m.PriceType = GetUnitNo(dataGridViewX1.Rows[row].Cells["pricetypes"].Value.ToString());
     m.Updated   = DateTime.Now;
     if (m.StockType != 1 && string.IsNullOrEmpty(dataGridViewX1.Rows[row].Cells["sum"].Value.ToString()))
     {
         MessageBox.Show("数量不能空!");
     }
     else
     {
         if (m.Sum == 0)
         {
             m.Sum = 1;
         }
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         bll.SetData(m, col, Login.authKey);
     }
 }
 private void dataGridViewX1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
 {
     //修改的是加点
     if (e.ColumnIndex == dataGridViewX1.Columns["Price_Plus"].Index)
     {
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         string  ID         = dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
         string  CateGory   = dataGridViewX1.Rows[e.RowIndex].Cells["CateGory"].Value.ToString();
         Decimal Price_Plus = dataGridViewX1.Rows[e.RowIndex].Cells["Price_Plus"].Value == null ? 0 : Convert.ToDecimal(dataGridViewX1.Rows[e.RowIndex].Cells["Price_Plus"].Value);
         bll.SetPricePlus(ID, Price_Plus, CateGory);
     }
     //修改的是售价
     if (e.ColumnIndex == dataGridViewX1.Columns["Price_Sale"].Index)
     {
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         string  ID         = dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
         string  CateGory   = dataGridViewX1.Rows[e.RowIndex].Cells["CateGory"].Value.ToString();
         Decimal Price      = dataGridViewX1.Rows[e.RowIndex].Cells["Price"].Value == null ? 0 : Convert.ToDecimal(dataGridViewX1.Rows[e.RowIndex].Cells["Price"].Value);
         Decimal Price_Sale = dataGridViewX1.Rows[e.RowIndex].Cells["Price_Sale"].Value == null ? 0 : Convert.ToDecimal(dataGridViewX1.Rows[e.RowIndex].Cells["Price_Sale"].Value);
         decimal Price_Plus = Price_Sale / Price;
         bll.SetPricePlus(ID, Price_Plus, CateGory);
     }
     //重新绑定数据
     Bind();
 }
Example #3
0
        //Yj2015.0226 Add 双击通用名显示图片 ---
        void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == dataGridViewX1.Columns["Column1"].Index)
            {
                int goodsPackageId = 0;
                int goodsId        = 0;
                if (int.TryParse(dataGridViewX1.Rows[e.RowIndex].Cells["Product_ID"].Value.ToString(), out goodsPackageId) &&
                    int.TryParse(dataGridViewX1.Rows[e.RowIndex].Cells["Goods_Id"].Value.ToString(), out goodsId))
                {
                    soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
                    string imgUrl = bll.GetImageUrl(goodsId, goodsPackageId);

                    string frmCaption = dataGridViewX1.Rows[e.RowIndex].Cells["Column1"].Value.ToString()
                                        + "—"
                                        + dataGridViewX1.Rows[e.RowIndex].Cells["Column2"].Value.ToString()
                                        + "—"
                                        + dataGridViewX1.Rows[e.RowIndex].Cells["Column4"].Value.ToString();

                    frmShowGoodsImage frmTmp = new frmShowGoodsImage(imgUrl);
                    frmTmp.Text = frmCaption;
                    frmTmp.Show(this);
                }
                else
                {
                    MessageBox.Show("无有效的物品编号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Example #4
0
        public void Bind()
        {
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            var li = bll.GetConfigList();

            if (li != null)
            {
                int i = 0;
                foreach (var item in li)
                {
                    dataGridViewX1.Rows.Add();
                    dataGridViewX1.Rows[i].Cells["id"].Value     = item.id;
                    dataGridViewX1.Rows[i].Cells["id"].ValueType = typeof(int);

                    dataGridViewX1.Rows[i].Cells["incName"].Value = item.incName;

                    dataGridViewX1.Rows[i].Cells["discountRate"].Value     = Math.Round(item.discountRate, 2);
                    dataGridViewX1.Rows[i].Cells["discountRate"].ValueType = typeof(decimal);

                    dataGridViewX1.Rows[i].Cells["cgy"].Value = item.cgy;
                    i++;
                }
                recordCount = li.Count();
                pageCount   = 1;
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #5
0
        private void buttonX1_Click(object sender, EventArgs e)
        {
            if (DialogResult.OK == MessageBox.Show("您是否确认修改?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
            {
                if (Library.Lang.DataValidator.isNULL(dataGridViewX1.Rows[0].Cells["Price_01Plus"].Value))
                {
                    dataGridViewX1.Rows[0].Cells["Price_01Plus"].ErrorText = "必填";
                }
                if (Library.Lang.DataValidator.isNULL(dataGridViewX1.Rows[0].Cells["Price_01Plus"].Value, dataGridViewX1.Rows[0].Cells["Price_01Plus"].Value))
                {
                    return;
                }
                soso.syntoolSoapClient bll   = new soso.syntoolSoapClient();
                Maptool.soso.Link      model = new soso.Link();
                model.created = DateTime.Now;
                model.updated = model.created;
                model.id      = int.Parse(dataGridViewX1.Rows[0].Cells["Product_ID"].Value.ToString());
                model.iden    = this.iden;

                model.spid = dataGridViewX1.Rows[0].Cells["Product_ID"].ToolTipText;
                model.t_id = this.knid;
                if (bll.AddLink(model, Login.authKey))
                {
                    MessageBox.Show("操作成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    from1.Bind();
                    this.Close();
                }
                else
                {
                    MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Example #6
0
        public void Bind()
        {
            string msg = Main.Menu.First(x => x.id == iden).name.Replace("数据映射", "");

            switch (BinType)
            {
            case 0: groupBox1.Text = "价格管理(" + msg + ")"; break;

            default: groupBox1.Text = "价格管理(" + msg + ")"; break;
            }
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            var li = bll.GetMaptoolList(PageSize, PageIndex, order, orderField, like, whereField, sqlext, BinType, Login.authKey, this.iden);

            if (li != null)
            {
                //#region 货源2.0新增内容(销售单位,用于控制商城前台销售商品的可售单位(最小单位、中包装、件装))
                li.Tables[0].Columns.Add("st", typeof(string));
                //#endregion

                var dt = li.Tables[0];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    //动态添加价格类型
                    string    ID         = dt.Rows[i]["ID"].ToString();
                    DataTable PriceTable = bll.GetPriceByID(ID);
                    if (PriceTable != null && PriceTable.Rows.Count > 0)
                    {
                        foreach (DataRow dr in PriceTable.Rows)
                        {
                            string  tempcategory = dr["category"] == null ? string.Empty : dr["category"].ToString();
                            decimal tempprice    = dr["price_n"] == null ? 0 : Convert.ToDecimal(dr["price_n"]);
                            //添加新列
                            if (!dt.Columns.Contains(tempcategory))
                            {
                                dt.Columns.Add(tempcategory, typeof(string));
                                if (!dataGridViewX1.Columns.Contains(tempcategory))
                                {
                                    dataGridViewX1.Columns.Insert(13, new DataGridViewTextBoxColumn()
                                    {
                                        HeaderText       = tempcategory,
                                        DataPropertyName = tempcategory,
                                        Name             = tempcategory
                                    });
                                }
                            }
                            dt.Rows[i][tempcategory] = tempprice;
                        }
                    }
                }
                dataGridViewX1.DataSource = dt;
                recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
                pageCount   = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
                paginger();
                labelX1.Text = string.Format("共{0}条记录", recordCount);
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #7
0
        private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == dataGridViewX1.Columns[0].Index)
            {
                if (DialogResult.OK == MessageBox.Show("您是否确认映射?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
                {
                    soso.syntoolSoapClient bll = new soso.syntoolSoapClient();

                    Maptool.soso.Link model = new soso.Link();
                    model.created = DateTime.Now;
                    model.updated = model.created;
                    model.id      = int.Parse(dataGridViewX1.Rows[e.RowIndex].Cells["Product_ID"].Value.ToString());
                    model.iden    = this.iden;
                    model.t_id    = this.Erp_ID;
                    if (bll.AddLink(model, Login.authKey))
                    {
                        MessageBox.Show("操作成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        from1.Bind();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("您可能已经映射过此供应商的数据!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }
        }
Example #8
0
 void dataGridViewX1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
 {
     if (dataGridViewX1.Columns[e.ColumnIndex].Name.ToLower() == "remark")
     {
         var    TempObj             = dataGridViewX1.Rows[e.RowIndex].Cells["remark"].Value;
         string Remark              = TempObj == null ? string.Empty : TempObj.ToString();
         string ERP_ID              = dataGridViewX1.Rows[e.RowIndex].Cells["ERP_Id"].Value.ToString();
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         bll.SetTag_2(ERP_ID, iden, Remark, Login.authKey);
     }
 }
Example #9
0
 private void dataGridViewX1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
 {
     if (e.ColumnIndex == dataGridViewX1.Columns["Column2"].Index)
     {
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         bll.SetTag(dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString(), iden, dataGridViewX1.Rows[e.RowIndex].Cells["Column2"].Value.ToString(), Login.authKey);
     }
     if (e.ColumnIndex == dataGridViewX1.Columns["remark"].Index)
     {
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         bll.SetTag_2(dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString(), iden, dataGridViewX1.Rows[e.RowIndex].Cells["remark"].Value.ToString(), Login.authKey);
     }
 }
Example #10
0
        public Config(string iden)
        {
            _iden = iden;
            InitializeComponent();
            this.ShowInTaskbar = false;
            dataGridViewX1.AutoGenerateColumns = false;
            dataGridViewX1.RowHeadersVisible   = false;

            dataGridViewX1.DataError += new DataGridViewDataErrorEventHandler(dataGridViewX1_DataError);
            var model = new soso.syntoolSoapClient().GetAllConfigPriceMe(Login.authKey);

            if (model != null)
            {
                dataGridViewX1.DataSource = model;
            }
        }
Example #11
0
        private void Bind()
        {
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();

            var li = bll.GetShopList(20, 1, false, "product_id", false, string.Empty, sqlext, 2, Login.authKey, this.iden);

            if (li != null && li.Tables[0].Rows.Count > 0)
            {
                var tempDT = li.Tables[0];
                dataGridViewX1.DataSource = tempDT;
                for (int i = 0; i < tempDT.Rows.Count; i++)
                {
                    if (!string.IsNullOrEmpty(tempDT.Rows[i]["image"].ToString()))
                    {
                        dataGridViewX1.Rows[i].DefaultCellStyle.ForeColor = Color.Red;
                    }
                }
            }
        }
Example #12
0
        private void Bind()
        {
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            var li = bll.GetCheckDataInfo(this.iden, PageSize, PageIndex, order, orderField, like, whereField, sqlext, Login.authKey);

            if (li != null)
            {
                li.Tables[0].Columns.Remove("row");
                dataGridViewX1.DataSource = li.Tables[0];
                recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
                pageCount   = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
                paginger();
                labelX1.Text = string.Format("共{0}条记录", recordCount);
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #13
0
 private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.ColumnIndex == dataGridViewX1.Columns["Stock"].Index)
     {
         Clipboard.SetText(dataGridViewX1.Rows[e.RowIndex].Cells["Stock"].ToolTipText.ToString());
         return;
     }
     if (e.ColumnIndex == dataGridViewX1.Columns["is_default"].Index)
     {
         if (dataGridViewX1.Rows[e.RowIndex].Cells[1].Value.ToString() == "未映射")
         {
             MessageBox.Show("未映射数据不能设置固定!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
             return;
         }
         soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
         bll.SetDefaultShop(iden, dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString(), (bool)dataGridViewX1.Rows[e.RowIndex].Cells["is_default"].EditedFormattedValue ? "1" : "0", Login.authKey);
     }
     if (e.ColumnIndex == dataGridViewX1.Columns[0].Index)
     {
         if (dataGridViewX1.Rows[e.RowIndex].Cells[1].Value.ToString() == "未映射")
         {
             MappingSet ms = new MappingSet();
             ms.Erp_ID             = dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
             ms.DrugsBase_DrugName = dataGridViewX1.Rows[e.RowIndex].Cells["DrugsBase_DrugName"].Value.ToString().Trim();
             ms.Goods_ConveRatio   = dataGridViewX1.Rows[e.RowIndex].Cells["Goods_ConveRatio"].Value.ToString();
             ms.price = 0;
             ms.iden  = this.iden;
             ms.from1 = this;
             ms.ShowDialog();
         }
         else
         {
             MappingEdit ms = new MappingEdit();
             ms.knid = dataGridViewX1.Rows[e.RowIndex].Cells["ID"].Value.ToString();
             ms.DrugsBase_DrugName = dataGridViewX1.Rows[e.RowIndex].Cells["DrugsBase_DrugName"].Value.ToString();
             ms.Goods_ConveRatio   = dataGridViewX1.Rows[e.RowIndex].Cells["Goods_ConveRatio"].Value.ToString();
             ms.price = 0;
             ms.iden  = this.iden;
             ms.from1 = this;
             ms.ShowDialog();
         }
     }
 }
        public void Bind()
        {
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            var li = bll.GetPriceByID(ERP_ID);

            if (li != null && li.Rows.Count > 0)
            {
                li.Columns.Add("Price_Sale", typeof(string));
                decimal Price      = 0;
                decimal Price_Plus = 0;
                foreach (DataRow item in li.Rows)
                {
                    Price = item["Price"] != null?Convert.ToDecimal(item["Price"]) : 0;

                    Price_Plus = item["Price_Plus"] != null?Convert.ToDecimal(item["Price_Plus"]) : 0;

                    item["Price_Sale"] = Math.Round(Price * Price_Plus, 2);
                    item["Price_Plus"] = Math.Round(Price_Plus, 2);
                }
                dataGridViewX1.DataSource = li;
            }
        }
Example #15
0
        private void buttonX1_Click_1(object sender, EventArgs e)
        {
            List <soso.Config> li = new List <soso.Config>();

            foreach (DataGridViewRow item in dataGridViewX1.Rows)
            {
                if (item.Cells["id"].Value == null)
                {
                    break;
                }
                soso.Config model = new soso.Config();
                model.id           = item.Cells["id"].Value.ToString();
                model.cgy          = item.Cells["cgy"].Value.ToString();
                model.incName      = item.Cells["incName"].Value.ToString();
                model.discountRate = float.Parse(item.Cells["discountRate"].Value.ToString());
                li.Add(model);
            }
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();

            bll.SetConfigList(li.ToArray(), Login.authKey);
            MessageBox.Show("操作成功!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Example #16
0
        private void buttonX1_Click(object sender, EventArgs e)
        {
            var NewData = dataGridViewX1.DataSource as Maptool.soso.ConfigPriceMe[];

            if (NewData != null)
            {
                //需要更新的价格类型
                DataTable dt = new DataTable();
                dt.Columns.Add("Price_Plus", typeof(decimal));
                dt.Columns.Add("CateGory", typeof(string));
                dt.TableName = "Table_PricePlus";
                foreach (var item in NewData)
                {
                    string Name       = item.name;
                    float  Price_Plus = item.Price_Plus;
                    if (!string.IsNullOrEmpty(Name) && Price_Plus > 0)
                    {
                        var dr = dt.NewRow();
                        dr["Price_Plus"] = Price_Plus;
                        dr["CateGory"]   = Name;
                        dt.Rows.Add(dr);
                    }
                }
                soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
                bool Result = bll.SetConfigPriceMe(Login.authKey, dt);
                if (Result)
                {
                    MessageBox.Show("保存成功!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("保存失败!");
                }
                this.Close();
            }
        }
Example #17
0
        public void Bind()
        {
            string msg = Main.Menu.First(x => x.id == iden).name.Replace("数据映射", "");

            switch (BinType)
            {
            case 0: groupBox1.Text = "全部数据(" + msg + ")"; break;

            case 1: groupBox1.Text = "未映射数据(" + msg + ")"; break;

            case 2: groupBox1.Text = "已映射数据(" + msg + ")"; break;
            }
            if (BinType != 1)
            {
                dataGridViewX1.Columns["Column2"].Visible = false;
            }
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            var li = bll.GetMaptoolList(PageSize, PageIndex, order, orderField, like, whereField, sqlext, BinType, Login.authKey, this.iden);

            if (li != null)
            {
                var dt = li.Tables[0];
                dt.Columns.Add("s", typeof(string));
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (Library.Lang.DataValidator.isNumber(dt.Rows[i]["Linkid"]))
                    {
                        dt.Rows[i]["s"] = "已映射";
                    }
                    else
                    {
                        dt.Rows[i]["s"] = "未映射";
                    }
                    //动态添加价格类型
                    string    ID         = dt.Rows[i]["ID"].ToString();
                    DataTable PriceTable = bll.GetPriceByID(ID);
                    if (PriceTable != null && PriceTable.Rows.Count > 0)
                    {
                        foreach (DataRow dr in PriceTable.Rows)
                        {
                            string  tempcategory = dr["category"] == null ? string.Empty : dr["category"].ToString();
                            decimal tempprice    = dr["price"] == null ? 0 : Convert.ToDecimal(dr["price"]);
                            //添加新列
                            if (!dt.Columns.Contains(tempcategory))
                            {
                                dt.Columns.Add(tempcategory, typeof(string));
                                if (!dataGridViewX1.Columns.Contains(tempcategory))
                                {
                                    dataGridViewX1.Columns.Insert(13, new DataGridViewTextBoxColumn()
                                    {
                                        HeaderText       = tempcategory,
                                        DataPropertyName = tempcategory,
                                        Name             = tempcategory
                                    });
                                }
                            }
                            dt.Rows[i][tempcategory] = tempprice;
                        }
                    }
                }
                dataGridViewX1.DataSource = dt;
                recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
                pageCount   = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
                paginger();
                labelX1.Text = string.Format("共{0}条记录", recordCount);
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #18
0
        public void Bind()
        {
            string msg = "商城数据";
            switch (BinType)
            {
                case 0: groupBox1.Text = "全部数据(" + msg + ")"; break;
                case 1: groupBox1.Text = "未映射数据(" + msg + ")"; break;
                case 2: groupBox1.Text = "已映射数据(" + msg + ")"; break;
            }
            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();

            var li = bll.GetShopList(PageSize, PageIndex, order, orderField, like, whereField, sqlext, BinType, Login.authKey, iden);

            if (BinType == 1)
            {
                dataGridViewX1.Columns["sup"].Visible = false;
            }
            else
            {
                dataGridViewX1.Columns["sup"].Visible = true;
            }
            if (li != null)
            {
                //取商品流向设置
                DataTable lx = bll.GetLiuXiangList(Login.authKey);
                var dt = li.Tables[0];

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    //动态添加价格类型
                    string ID = dt.Rows[i]["spid"].ToString();
                    DataTable PriceTable = bll.GetPriceByID(ID);
                    if (PriceTable != null && PriceTable.Rows.Count > 0)
                    {

                        foreach (DataRow dr in PriceTable.Rows)
                        {
                            string tempcategory = dr["category"] == null ? string.Empty : dr["category"].ToString();
                            decimal tempprice = dr["price_n"] == null ? 0 : Convert.ToDecimal(dr["price_n"]);
                            //添加新列
                            if (!dt.Columns.Contains(tempcategory))
                            {
                                dt.Columns.Add(tempcategory, typeof(string));
                                if (!dataGridViewX1.Columns.Contains(tempcategory))
                                {
                                    dataGridViewX1.Columns.Insert(13, new DataGridViewTextBoxColumn()
                                    {
                                        HeaderText = tempcategory,
                                        DataPropertyName = tempcategory,
                                        Name = tempcategory
                                    });

                                }

                            }
                            dt.Rows[i][tempcategory] = tempprice;
                        }
                    }

                }
                dataGridViewX1.DataSource = dt;
                recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
                pageCount = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
                paginger();
                labelX1.Text = string.Format("共{0}条记录", recordCount);

            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #19
0
        public void Bind()
        {
            //中药材显示的方式
            //中药材显示的方式
            if (Program.iden_in_zyc.Contains(iden) && !dataGridViewX1.Columns.Contains("ProductionAddress"))
            {
                dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    HeaderText = "产地", DataPropertyName = "ProductionAddress", Name = "ProductionAddress"
                });
                dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    HeaderText = "片型", Name = "DrugsBase_Formulation2",
                });
                dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    HeaderText = "制法", Name = "ProductionMethodName",
                });
            }

            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
            DataSet li = new soso.syntoolSoapClient().GetCompleteLink(this.knid, iden, Login.authKey);

            if (li != null)
            {
                dataGridViewX1.Rows.Clear();

                for (int i = 0; i < li.Tables[0].Rows.Count; i++)
                {
                    dataGridViewX1.Rows.Add();

                    try
                    {
                        if (Program.iden_in_zyc.Contains(iden))
                        {
                            dataGridViewX1.Rows[i].Cells["ProductionAddress"].Value      = li.Tables[0].Rows[i]["ProductionAddress"].ToString().Trim();
                            dataGridViewX1.Rows[i].Cells["DrugsBase_Formulation2"].Value = li.Tables[0].Rows[i]["DrugsBase_Formulation2"].ToString().Trim();
                            dataGridViewX1.Rows[i].Cells["ProductionMethodName"].Value   = li.Tables[0].Rows[i]["ProductionMethodName"].ToString().Trim();
                        }

                        dataGridViewX1.Rows[i].Cells["Column1"].Value       = li.Tables[0].Rows[i]["DrugsBase_DrugName"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells["Column1"].ToolTipText = "双击查看图片";
                        dataGridViewX1.Rows[i].Cells["Column2"].Value       = li.Tables[0].Rows[i]["DrugsBase_Specification"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells["Column3"].Value       = li.Tables[0].Rows[i]["DrugsBase_Formulation"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells[5].Value = li.Tables[0].Rows[i]["DrugsBase_Manufacturer"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells[6].Value = li.Tables[0].Rows[i]["DrugsBase_ApprovalNumber"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells[7].Value = li.Tables[0].Rows[i]["Registration_No"].ToString().Trim();
                        var dr = li.Tables[0].Rows[i];
                        dataGridViewX1.Rows[i].Cells["Column6"].Value            = string.Format("{0}{1}/{2}", dr["Goods_ConveRatio"], dr["Goods_ConveRatio_Unit"], dr["Goods_Unit"]);
                        dataGridViewX1.Rows[i].Cells["Product_ID"].Value         = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells["Column8"].ToolTipText      = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
                        dataGridViewX1.Rows[i].Cells["Column7"].Value            = dr["Goods_ConveRatio"].ToString();
                        dataGridViewX1.Rows[i].Cells["Goods_Pcs"].Value          = dr["Goods_Pcs"].ToString();
                        dataGridViewX1.Rows[i].Cells["colGoods_Pcs_Small"].Value = dr["Goods_Pcs_Small"].ToString();
                        dataGridViewX1.Rows[i].Cells["Goods_Unit"].Value         = dr["Goods_Unit"].ToString();

                        dataGridViewX1.Rows[i].Cells["Goods_Id"].Value = li.Tables[0].Rows[i]["Goods_Id"].ToString().Trim();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Example #20
0
        public void Bind()
        {
            dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
            {
                HeaderText = "产地", DataPropertyName = "ProductionAddress", Name = "ProductionAddress"
            });
            dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
            {
                HeaderText = "片型", Name = "DrugsBase_Formulation2",
            });
            dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
            {
                HeaderText = "制法", Name = "ProductionMethodName",
            });
            dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
            {
                HeaderText = "等级", Name = "ProductionLevelName",
            });


            soso.syntoolSoapClient bll = new soso.syntoolSoapClient();

            var li = bll.GetListAll101(PageSize, PageIndex, order, orderField, like, whereField, whereString, sql, Login.authKey);

            if (li != null)
            {
                dataGridViewX1.Rows.Clear();
                for (int i = 0; i < li.Tables[0].Rows.Count; i++)
                {
                    dataGridViewX1.Rows.Add();

                    dataGridViewX1.Rows[i].Cells["ProductionAddress"].Value      = li.Tables[0].Rows[i]["ProductionAddress"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["DrugsBase_Formulation2"].Value = li.Tables[0].Rows[i]["DrugsBase_Formulation2"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["ProductionMethodName"].Value   = li.Tables[0].Rows[i]["ProductionMethodName"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["ProductionLevelName"].Value    = li.Tables[0].Rows[i]["ProductionLevelName"].ToString().Trim();

                    dataGridViewX1.Rows[i].Cells["Column9"].Value       = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Column1"].Value       = li.Tables[0].Rows[i]["DrugsBase_DrugName"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Column1"].ToolTipText = "双击查看图片";
                    dataGridViewX1.Rows[i].Cells["Column2"].Value       = li.Tables[0].Rows[i]["DrugsBase_Specification"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Column3"].Value       = li.Tables[0].Rows[i]["DrugsBase_Formulation"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells[6].Value            = li.Tables[0].Rows[i]["DrugsBase_Manufacturer"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells[7].Value            = li.Tables[0].Rows[i]["DrugsBase_ApprovalNumber"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells[8].Value            = li.Tables[0].Rows[i]["Registration_No"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Goods_Unit"].Value = li.Tables[0].Rows[i]["Goods_Unit"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Goods_Pcs"].Value  = li.Tables[0].Rows[i]["Goods_Pcs"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Goods_Id"].Value   = li.Tables[0].Rows[i]["Goods_Id"].ToString().Trim();

                    dataGridViewX1.Rows[i].Cells["Goods_Pcs_Small"].Value = li.Tables[0].Rows[i]["Goods_Pcs_Small"].ToString().Trim();
                    var dr = li.Tables[0].Rows[i];
                    dataGridViewX1.Rows[i].Cells["Column6"].Value       = string.Format("{0}{1}/{2}", dr["Goods_ConveRatio"], dr["Goods_ConveRatio_Unit"], dr["Goods_Unit"]);
                    dataGridViewX1.Rows[i].Cells["Product_ID"].Value    = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Column8"].ToolTipText = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
                    dataGridViewX1.Rows[i].Cells["Column7"].Value       = dr["Goods_ConveRatio"].ToString();
                }
                recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
                pageCount   = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
                paginger();
            }
            else
            {
                MessageBox.Show("您的登陆状态已经失效,请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }