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