Esempio n. 1
0
        public frmCusOrder()
        {
            InitializeComponent();
            bussinessclass bc = new bussinessclass();
            DataSet        ds = new DataSet();

            ds = bc.Orders_GetList();
            dgview.DataSource = ds;
            dgview.DataMember = "Orders";
            DataSet dscity = new DataSet();

            dscity = bc.City_GetList();
            cmbbeginning.DataSource      = dscity.Tables["City"];
            cmbbeginning.DisplayMember   = "Name";
            cmbbeginning.ValueMember     = "Code";
            cmbdestination.DataSource    = dscity.Tables["City"];
            cmbdestination.DisplayMember = "Name";
            cmbdestination.ValueMember   = "Code";
            DataSet dsvehicle = new DataSet();

            dsvehicle                = bc.Vehicle_GetList();
            cmbvehicle.DataSource    = dsvehicle.Tables[0];
            cmbvehicle.DisplayMember = "Title";
            cmbvehicle.ValueMember   = "ID";
        }
Esempio n. 2
0
        public frmCustomerInfo()
        {
            InitializeComponent();
            bussinessclass bc  = new bussinessclass();
            DataSet        ds1 = new DataSet();

            ds1 = bc.Customer_GetList();
            dgview.DataSource = ds1;
            dgview.DataMember = "Customer";
            DataSet dscity = new DataSet();

            dscity = bc.City_GetList();
            cmbBCity.DataSource        = dscity.Tables["City"];
            cmbBCity.DisplayMember     = "Name";
            cmbBCity.ValueMember       = "Code";
            cmbLcity.DataSource        = dscity.Tables["City"];
            cmbLcity.DisplayMember     = "Name";
            cmbLcity.ValueMember       = "Code";
            cmbBProvince.DisplayMember = "فارس";
            cmbBProvince.ValueMember   = "1";
            cmbLProvince.DisplayMember = "فارس";
            cmbLProvince.ValueMember   = "1";
            cmbLPart.DisplayMember     = "مرکزی";
            cmbbPart.ValueMember       = "1";
            cmbLPart.DisplayMember     = "مرکزی";
            cmbLPart.ValueMember       = "1";
            cmbbvillage.DisplayMember  = "مرکزی";
            cmbbvillage.ValueMember    = "1";
            cmbLVillage.DisplayMember  = "مرکزی";
            cmbLVillage.ValueMember    = "1";


            //--------------------------------
        }
Esempio n. 3
0
        private void btnView_Click(object sender, EventArgs e)
        {
            bussinessclass bc      = new bussinessclass();
            DataSet        dscity  = new DataSet();
            DataSet        dscity1 = new DataSet();

            dscity              = bc.City_GetList();
            dscity1             = bc.City_GetList();
            txtid1.Text         = dgview.SelectedRows[0].Cells[0].Value.ToString();
            txttitle1.Text      = dgview.SelectedRows[0].Cells[1].Value.ToString();
            txtdescription.Text = dgview.SelectedRows[0].Cells[2].Value.ToString();
            cmbvehicle.Text     = dgview.SelectedRows[0].Cells[4].Value.ToString();
            txtprice.Text       = dgview.SelectedRows[0].Cells[5].Value.ToString();
            txtmaxnumber.Text   = dgview.SelectedRows[0].Cells[6].Value.ToString();
            string tbeginning = "";
            int    vbeginning;

            for
            (int i = 0; i < Convert.ToInt32(dscity.Tables[0].Rows.Count); i++)
            {
                vbeginning = Convert.ToInt32(dgview.SelectedRows[0].Cells[7].Value.ToString());
                if (vbeginning == Convert.ToInt32(dscity.Tables[0].Rows[i]["Code"]))
                {
                    tbeginning = dscity.Tables[0].Rows[i]["Name"].ToString();
                }
            }
            cmbbeginning.Text = tbeginning;


            string tdestination = "";
            int    vdestination;

            for
            (int i = 0; i < Convert.ToInt32(dscity1.Tables[0].Rows.Count); i++)
            {
                vdestination = Convert.ToInt32(dgview.SelectedRows[0].Cells[8].Value.ToString());
                if (vdestination == Convert.ToInt32(dscity1.Tables[0].Rows[i]["Code"]))
                {
                    tdestination = dscity1.Tables[0].Rows[i]["Name"].ToString();
                }
            }
            cmbdestination.Text = tdestination;

            txtdate.Text   = dgview.SelectedRows[0].Cells[9].Value.ToString();
            txttime.Text   = dgview.SelectedRows[0].Cells[10].Value.ToString();
            txtstatus.Text = dgview.SelectedRows[0].Cells[11].Value.ToString();
        }