public ModifyShipper(IDBOperation dbOperation, string shipper_id, string shipperflag, SysShipperQuery ship_query) { InitializeComponent(); this.dbOperation = dbOperation; this.shipperId = shipper_id; this._id.Text = shipperId; this.ship = ship_query; this.shipperFlag = shipperflag; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("select shippername,phone,region,town,village from t_shipper " + "where shipperid = '{0}' and shipperflag = '{1}'", shipperId, shipperFlag)).Tables[0]; if (table.Rows.Count != 0) { this._name.Text = table.Rows[0][0].ToString(); this._phone.Text = table.Rows[0][1].ToString(); this._region.Text = table.Rows[0][2].ToString(); this._town.Text = table.Rows[0][3].ToString(); this._village.Text = table.Rows[0][4].ToString(); } }
public ModifyShipper(IDBOperation dbOperation, string shipper_id,string shipperflag, SysShipperQuery ship_query) { InitializeComponent(); this.dbOperation = dbOperation; this.shipperId = shipper_id; this._id.Text = shipperId; this.ship = ship_query; this.shipperFlag = shipperflag; DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("select shippername,phone,region,town,village from t_shipper " + "where shipperid = '{0}' and shipperflag = '{1}'", shipperId, shipperFlag)).Tables[0]; if(table.Rows.Count != 0) { this._name.Text = table.Rows[0][0].ToString(); this._phone.Text = table.Rows[0][1].ToString(); this._region.Text = table.Rows[0][2].ToString(); this._town.Text = table.Rows[0][3].ToString(); this._village.Text = table.Rows[0][4].ToString(); } }