C# (CSharp) MyDabaseDataContext.USP_VP_GET_PRODUCT_SIZE示例

示例#1

        void PopualteData()
        {
            int    iPartyID = 0;
            string sPartyID = "";

            if (!string.IsNullOrEmpty(cmbName.Text.Trim()))
            {
                int.TryParse(cmbName.SelectedValue.ToString(), out iPartyID);
            }

            if (iPartyID > 0)
            {
                sPartyID = iPartyID.ToString();
            }

            MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
            List <USP_VP_GET_PRODUCT_SIZEResult> lstCategory = new List <USP_VP_GET_PRODUCT_SIZEResult>();

            lstCategory = MyDa.USP_VP_GET_PRODUCT_SIZE("", sPartyID, null, null, Datalayer.iT001_COMPANYID.ToString()).ToList();
            dgDisplayData.DataSource = lstCategory;

            dgDisplayData.Columns["TM01_PRODUCTID"].Visible     = false;
            dgDisplayData.Columns["TM01_PRODUCTID1"].Visible    = false;
            dgDisplayData.Columns["TM01_ISSET"].Visible         = false;
            dgDisplayData.Columns["TM02_PRODUCTSIZEID"].Visible = false;
            dgDisplayData.Columns["TM01_PRODUCTID"].Visible     = false;
            dgDisplayData.Columns["TM01_HSNCODE"].Visible       = false;
            dgDisplayData.Columns["TM01_TAX_RATE"].Visible      = false;
            dgDisplayData.Columns["TM_COMPAYID"].Visible        = false;
            dgDisplayData.Columns["TM_COMPAYID1"].Visible       = false;

            dgDisplayData.Columns["TM01_NO"].HeaderText    = "No";
            dgDisplayData.Columns["TM01_NAME"].HeaderText  = "Name";
            dgDisplayData.Columns["TM02_SIZE"].HeaderText  = "Size";
            dgDisplayData.Columns["TM02_PRICE"].HeaderText = "Price";

            dgDisplayData.Columns["TM01_NO"].DisplayIndex    = 0;
            dgDisplayData.Columns["TM01_NAME"].DisplayIndex  = 1;
            dgDisplayData.Columns["TM02_SIZE"].DisplayIndex  = 2;
            dgDisplayData.Columns["TM02_PRICE"].DisplayIndex = 3;

            this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
            dgDisplayData.EnableHeadersVisualStyles = false;

            // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White;
            dgDisplayData.ColumnHeadersHeightSizeMode             = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            dgDisplayData.ColumnHeadersHeight                     = 30;
            dgDisplayData.ColumnHeadersDefaultCellStyle.Font      = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
            dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
        }