public SeachphieuMKT(Viewtable Fromviewable, string tablename, string valuesave)
{
// tkhead là tìm theo head - - tk là tìm theo detai
InitializeComponent();
this.Fromviewable = Fromviewable;
this.tablename = tablename;
this.valuesave = valuesave;
List <View.MKTselectStoreandRegion.ComboboxItem> CombomCollection2 = new List <View.MKTselectStoreandRegion.ComboboxItem>();
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
this.dc = dc;
///
// string username = Utils.getusername();
// string rightkho = Model.Username.getmaquyenkho();
View.MKTselectStoreandRegion.ComboboxItem cb1 = new View.MKTselectStoreandRegion.ComboboxItem();
cb1.Value = "";
cb1.Text = "All Regions";// + " || Example: " + item2.Example;
CombomCollection2.Add(cb1);
var rs3 = from pp in dc.tbl_MKT_Regions
// where pp.Region == rightkho
select pp;
foreach (var item2 in rs3)
{
View.MKTselectStoreandRegion.ComboboxItem cb = new View.MKTselectStoreandRegion.ComboboxItem();
cb.Value = item2.Region.Trim();
cb.Text = item2.Region.Trim() + ": " + item2.Note.Trim().ToUpper();// + " || Example: " + item2.Example;
CombomCollection2.Add(cb);
}
cbselect2.DataSource = CombomCollection2;
cbstatusphieu.SelectedIndex = 0;
// this.ststusphieu = cbstatusphieu.SelectedValue.ToString();
this.region = "";// (cbselect2.SelectedItem as View.MKTselectStoreandRegion.ComboboxItem).Value.ToString();
this.statusphieu = "";
}
public MKTFromdatetodateRegion()
{
InitializeComponent();
List <View.MKTselectStoreandRegion.ComboboxItem> CombomCollection2 = new List <View.MKTselectStoreandRegion.ComboboxItem>();
string connection_string = Utils.getConnectionstr();
LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
///
// string username = Utils.getusername();
// string rightkho = Model.Username.getmaquyenkho();
var rs3 = from pp in dc.tbl_MKT_Regions
// where pp.Region == rightkho
select pp;
foreach (var item2 in rs3)
{
View.MKTselectStoreandRegion.ComboboxItem cb = new View.MKTselectStoreandRegion.ComboboxItem();
cb.Value = item2.Region.Trim();
cb.Text = item2.Region.Trim() + ": " + item2.Note.Trim().ToUpper();// + " || Example: " + item2.Example;
CombomCollection2.Add(cb);
}
cbselect2.DataSource = CombomCollection2;
fromdatepicker.Value = DateTime.Today;
todatepicker.Value = DateTime.Today;
this.fromdate = fromdatepicker.Value;
this.todate = todatepicker.Value;
cbstatusphieu.SelectedIndex = 0;
// this.ststusphieu = cbstatusphieu.SelectedValue.ToString();
this.region = "";// (cbselect2.SelectedItem as View.MKTselectStoreandRegion.ComboboxItem).Value.ToString();
chon = false;
}
