public void OnAChange(Object sender, EventArgs e) { DataSet a = new DataSet(); DataAdapter c; datacontrol b = (datacontrol)Session["database"]; Driver d = (Driver)Session["driver"]; if (StateList.SelectedItem.Text == "当前合同") { c = b.getContract(); } else if (StateList.SelectedItem.Text == "有效合同") { c = b.getOkContract(); } else if (StateList.SelectedItem.Text == "所有合同") { c = b.getAllContract(); } else { c = null; } try { c.Fill(a); Contractgride.DataSource = a; Contractgride.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('没有当前合同');</script>"); } }
public void OnSreach(Object sender, EventArgs e) { DataAdapter c; String Year; myStrat = int.Parse(this.startYear.Text); Year = this.endYear.Text; useYear = int.Parse(Year); //数据库绑定 DataSet b = new DataSet(); datacontrol a = (datacontrol)Session["database"]; c = a.avaliableCar(myStrat, useYear); try { c.Fill(b); this.carGrid.DataSource = b; this.carGrid.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('没有合适车辆');</script>"); } }
public void Page_Load(Object sender, EventArgs e) { datacontrol a = (datacontrol)Session["database"]; Driver b = (Driver)Session["driver"]; System.Data.Common.DataAdapter d = a.getUseCar(b.driverid); System.Data.DataSet c = new System.Data.DataSet(); d.Fill(c); Datagride.DataSource = c; Datagride.DataBind(); }
private void CreateAddedPrivList(datacontrol dataControl) { if (dataControl != null) { List <string> ExistList = dataControl.privilegeList; foreach (var item in ExistList) { AddedPrivilegeList.Add(item); } } }
public void OnAdd(object sender, EventArgs e) { string theCarid = this.carid.Text; int theCarYear = int.Parse(this.carYear.Text); bool theAvaliable = Convert.ToBoolean(this.avaliable.Text); bool theInsurance = Convert.ToBoolean(this.avaliable.Text); bool theYearCheck = Convert.ToBoolean(this.avaliable.Text); datacontrol a = (datacontrol)Session["database"]; a.insert(theCarid, theCarYear, theAvaliable, theInsurance, theYearCheck); Response.Write("<script>alert('添加完成');</script>"); }
public void OnSelect(object sender, EventArgs e) { String Year; myStrat = int.Parse(this.startYear.Text); Year = this.endYear.Text; useYear = int.Parse(Year); datacontrol a = (datacontrol)Session["database"]; GridViewRow row = carGrid.SelectedRow; String driverid = ((Driver)Session["driver"]).driverid; a.insert(row.Cells[1].Text, driverid, myStrat, useYear, false, true); }
public void OnLoginButtonClicked(Object sender, EventArgs e) { if (Login != null) { Driver a = new datacontrol("D:\\asd.data").getDriver(Name); if (a != null && a.password == Pas) { Session["driver"] = a; Login(this, true); Response.Write("<script>alert('sucessful');location.href='diaName.aspx';</script>"); } else { Login(this, false); } } }
static void Main(String[] argv) { datacontrol a = new datacontrol("D:\\asd"); a.insert("H12345", 2013, true, true, true); a.insert("C12345", 2013, true, true, true); a.insert("J12345", 2013, false, true, true); a.insert("G12345", 2011, true, true, true); a.insert("M123", "123", true, "Amy", "19950125", "1234"); a.insert("M456", "456", false, "Tom", "19941212", "5678"); a.insert("M789", "789", false, "kitty", "19941212", "0789"); a.insert("H12345", "M123", 20101020, 20151020, true, true); a.insert("G12345", "M456", 20121020, 20151020, false, true); a.insert("H12345", "M123", 20151020, 20171020, false, true); a.insert("G12345", "M789", 20151020, 20171020, true, true); a.insert("J12345", "H12345", 20121010, 20151010, true, true); }
public void Page_Load(Object sender, EventArgs e) { datacontrol a = (datacontrol)Session["database"]; System.Data.Common.DataAdapter d = a.getAContract(); System.Data.DataSet c = new System.Data.DataSet(); try { d.Fill(c); AlGride.DataSource = c; AlGride.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('没有待同意合同');</script>"); } }
public static void Main(string[] argvs) { datacontrol a=new datacontrol("asd.data"); a.insert("H12345",2013,true,true,true); a.insert("C12345",2013,true,true,true); a.insert("J12345",2013,false,true,true); a.insert("G12345",2011,true,true,true); a.insert("M123","123",true,"Amy","19950125","1234"); a.insert("M456","456",false,"Tom","19941212","5678"); a.insert("M789","789",false,"kitty","19941212","0789"); a.insert("H12345","M123",20101020,20151020,true,true); a.insert("G12345","M456",20121020,20151020,false,true); a.insert("H12345","M123",20151020,20171020,false,true); a.insert("G12345","M789",20151020,20171020,true,true); a.avaliableCar(2020); a.insert("J12345","H12345",20121010,20151010,true,true); Console.Read(); }
public void Page_Load(Object sender, EventArgs e) { DataSet a = new DataSet(); DataAdapter c; datacontrol b = (datacontrol)Session["database"]; c = b.getAllDriver(); try { c.Fill(a); jsygride.DataSource = a; jsygride.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('ûÓмÝʻԱ');</script>"); } }
public AddDataControlWizard(string privilegePath, datacontrol dataControl, List <string> privilegeList, List <appdefprivilege> appdefprivList) { InitializeComponent(); this.privilegePath = privilegePath; PlatformPrivilegeListCreator(); CreateSupportPrivList(privilegeList, appdefprivList, dataControl); CreateAddedPrivList(dataControl); this.providerIDTxtBox.Text = dataControl.providerid; if (dataControl.type.Equals("Sql")) { this.SQLRadio.IsChecked = true; } else if (dataControl.type.Equals("Map")) { this.MapRadio.IsChecked = true; } if (dataControl.access.Contains("Read")) { this.ReadCheckBox.IsChecked = true; } if (dataControl.access.Contains("Write")) { this.WriteCheckBox.IsChecked = true; } if (dataControl.trusted == null) { this.TrustedCheckbox.IsChecked = false; } else { if (dataControl.trusted.Contains("true")) { this.TrustedCheckbox.IsChecked = true; } } Button_Enable_Checker(); DataContext = this; }
public void OnLoginButtonClicked(Object sender, EventArgs e) { if (Chose.SelectedIndex == 0) { Driver a; if (Login != null) { if (Session["database"] == null) { Session["database"] = new datacontrol("D:\\asd.data"); } a = ((datacontrol)Session["database"]).getDriver(Name); if (a != null && a.password == Pas) { Session["driver"] = a; Response.Write("<script>alert('sucessful');location.href='lsyztcz.aspx';</script>"); } else { Login(this); } } } else if (Chose.SelectedIndex == 1) { String password; if (Session["database"] == null) { Session["database"] = new datacontrol("D:\\asd.data"); } String a; a = ((datacontrol)Session["database"]).getAdminPassword(Name); if (a != null && a == Pas) { Response.Write("<script>alert('sucessful');location.href='lyztcz.aspx';</script>"); } else { Login(this); } } }
public static void Main(string[] argvs) { datacontrol a = new datacontrol("asd.data"); a.insert("H12345", 2013, true, true, true); a.insert("C12345", 2013, true, true, true); a.insert("J12345", 2013, false, true, true); a.insert("G12345", 2011, true, true, true); a.insert("M123", "123", true, "Amy", "19950125", "1234"); a.insert("M456", "456", false, "Tom", "19941212", "5678"); a.insert("M789", "789", false, "kitty", "19941212", "0789"); a.insert("H12345", "M123", 20101020, 20151020, true, true); a.insert("G12345", "M456", 20121020, 20151020, false, true); a.insert("H12345", "M123", 20151020, 20171020, false, true); a.insert("G12345", "M789", 20151020, 20171020, true, true); a.avaliableCar(2020); a.insert("J12345", "H12345", 20121010, 20151010, true, true); Console.Read(); }
public void OnSreach(object sender, EventArgs e) { DataAdapter c; //数据库绑定 DataSet b = new DataSet(); datacontrol a = (datacontrol)Session["database"]; c = a.getUsefulCar(); try { c.Fill(b); this.acarGrid.DataSource = b; this.acarGrid.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('没有可用车辆');</script>"); } }
public void OnSelect(object sender, EventArgs e) { GridViewRow row = AlGride.SelectedRow; int start = int.Parse(row.Cells[3].Text); int end = int.Parse(row.Cells[4].Text); String driverid = row.Cells[2].Text; String carid = row.Cells[1].Text; datacontrol b = (datacontrol)Session["database"]; if (b.isCarContract(carid, start, end)) { Response.Write("<script>alert('car not free!');</script>"); return; } if (b.isDriverContract(driverid, start, end)) { Response.Write("<script>alert('driver not free!');</script>"); return; } b.updateContractIsagree(carid, driverid, start, true); }
protected void OnAddContract(object sender, EventArgs e) { Driver a = (Driver)Session["driver"]; datacontrol b = (datacontrol)Session["database"]; String id = carid.Text; int start = int.Parse(startText.Text); int end = int.Parse(endText.Text); if (!b.isCarContract(id, start, end)) { System.Windows.Forms.MessageBox.Show("car not free"); return; } if (!b.isDriverContract(a.driverid, start, end)) { System.Windows.Forms.MessageBox.Show("driver not free"); return; } else { System.Windows.Forms.MessageBox.Show("success"); } b.insert(carid.Text, a.driverid, start, end, false, true); }
private void CreateSupportPrivList(List <string> privilegeList, List <appdefprivilege> appdefprivList, datacontrol dataControl = null) { foreach (var item in PrivilegeItems) { SupportPrivilegeList.Add(item.privilegeName); } foreach (var item in appdefprivList) { SupportPrivilegeList.Add(item.Value); } if (dataControl != null) { List <string> ExistList = dataControl.privilegeList; foreach (var item in ExistList) { SupportPrivilegeList.Remove(item); } } }