示例#1
0
        void PopualteData()
        {
            if (Datalayer.T010_PACKINGSLIPID > 0)
            {
                DataTable dt = new DataTable();
                dt = dl.SelectMethod("SELECT * FROM T010_PACKINGSLIP WHERE T010_PACKINGSLIPID=" + Datalayer.T010_PACKINGSLIPID);
                if (dt != null && dt.Rows.Count > 0)
                {
                    cmbName.SelectedValue = int.Parse(dt.Rows[0]["T001_ACCOUNTID"].ToString());
                    PopualtePackingDetails();
                    cmbName.Enabled   = false;
                    dtpDate.Text      = dt.Rows[0]["T010_DATE"].ToString();
                    txtBillNo.Text    = dt.Rows[0]["T010_NO"].ToString();
                    txtTransport.Text = dt.Rows[0]["T010_TRANSPORT"].ToString();
                    txtLRNo.Text      = dt.Rows[0]["T010_LRNO"].ToString();

                    MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
                    List <USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_IDResult> lstCategory = new List <USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_IDResult>();
                    lstCategory = MyDa.USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_ID(Datalayer.T010_PACKINGSLIPID.ToString(), Datalayer.iT001_COMPANYID.ToString()).ToList();
                    dgDisplayData.DataSource = lstCategory;

                    dgDisplayData.Columns["T004_ORDERID"].Visible = false;

                    dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name";
                    dgDisplayData.Columns["TM02_PRICE"].Visible   = false;
                    dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Size";
                    dgDisplayData.Columns["T004_DATE"].HeaderText = "Date";
                    dgDisplayData.Columns["T004_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy";
                    dgDisplayData.Columns["T004_QTY"].HeaderText         = "Qty";
                    dgDisplayData.Columns["T004_PENDING_QTY"].HeaderText = "Packing Qty";
                    dgDisplayData.Columns["T004_IS_COMPLITE"].HeaderText = "Is Complite ?";
                    dgDisplayData.Columns["T004_IS_URGENT"].HeaderText   = "Is Urgent ?";

                    dgDisplayData.Columns["T004_DATE"].DisplayIndex        = 0;
                    dgDisplayData.Columns["TM01_NAME"].DisplayIndex        = 1;
                    dgDisplayData.Columns["TM02_SIZE"].DisplayIndex        = 2;
                    dgDisplayData.Columns["T004_QTY"].DisplayIndex         = 3;
                    dgDisplayData.Columns["T004_PENDING_QTY"].DisplayIndex = 4;
                    dgDisplayData.Columns["T004_IS_COMPLITE"].DisplayIndex = 5;
                    dgDisplayData.Columns["T004_IS_URGENT"].DisplayIndex   = 6;

                    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;

                    dgDisplayData.Columns["T004_DATE"].Width = 100;
                    dgDisplayData.Columns["TM01_NAME"].Width = 350;

                    dgDisplayData.Columns["T004_DATE"].ReadOnly        = true;
                    dgDisplayData.Columns["TM01_NAME"].ReadOnly        = true;
                    dgDisplayData.Columns["TM02_SIZE"].ReadOnly        = true;
                    dgDisplayData.Columns["T004_QTY"].ReadOnly         = true;
                    dgDisplayData.Columns["T004_IS_COMPLITE"].ReadOnly = true;
                    dgDisplayData.Columns["T004_IS_URGENT"].ReadOnly   = true;


                    cmbName.Focus();
                }
            }
        }