C# (CSharp) MyDabaseDataContext.USP_VP_GET_PACKING_SLIPの例

コード例 #1

        void PopualteData()
        {
            string TM02_PARTYID  = "";
            int    iTM02_PARTYID = 0;

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

            if (iTM02_PARTYID > 0)
            {
                TM02_PARTYID = iTM02_PARTYID.ToString();
            }

            MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
            List <USP_VP_GET_PACKING_SLIPResult> lst = new List <USP_VP_GET_PACKING_SLIPResult>();

            lst = MyDa.USP_VP_GET_PACKING_SLIP(null, TM02_PARTYID, null, dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList();
            dgDisplayData.DataSource = lst;

            dgDisplayData.Columns["T010_PACKINGSLIPID"].Visible = false;
            dgDisplayData.Columns["T001_ACCOUNTID"].Visible     = false;

            dgDisplayData.Columns["T001_NAME"].HeaderText              = "Name";
            dgDisplayData.Columns["T001_MOBILE1"].HeaderText           = "Mobile No";
            dgDisplayData.Columns["T010_DATE"].HeaderText              = "Date";
            dgDisplayData.Columns["T010_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy";
            dgDisplayData.Columns["T010_NO"].HeaderText        = "Slip No";
            dgDisplayData.Columns["T010_TRANSPORT"].HeaderText = "Transport";
            dgDisplayData.Columns["T010_LRNO"].HeaderText      = "L.R. No";

            dgDisplayData.Columns["T001_NAME"].DisplayIndex      = 0;
            dgDisplayData.Columns["T001_MOBILE1"].DisplayIndex   = 1;
            dgDisplayData.Columns["T010_DATE"].DisplayIndex      = 2;
            dgDisplayData.Columns["T010_NO"].DisplayIndex        = 3;
            dgDisplayData.Columns["T010_TRANSPORT"].DisplayIndex = 4;
            dgDisplayData.Columns["T010_LRNO"].DisplayIndex      = 5;

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

            // 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;
        }