private void Button_enter_allow_Click(object sender, EventArgs e)
{
DateTime timenow=DateTime.Now;
//新建一个model，数据通过这个model进行传递
Model_FreedomCars newcar = new Model_FreedomCars(
Convert.ToInt32(this.textBox_placeid.Text),
this.textBox_carnumbers.Text,
this.textBox_mastername.Text,
this.textBox_tel.Text,
timenow
);
BLL_FreedomCars.EnterNewFreeCar(newcar);
Model_Records newrecord = new Model_Records(
this.textBox_mastername.Text,
this.textBox_carnumbers.Text,
this.textBox_tel.Text,
Convert.ToInt32(this.textBox_placeid.Text),
timenow
);
BLL_Records.AddNewRecord(newrecord);
this.Close();
// records = new BLL_Records(
// this.textBox_mastername.Text,
// this.textBox_tel.Text,
// Convert.ToInt32(this.textBox_placeid.Text),
// this.textBox_carnumbers.Text
// );
//records.SaveRecords();
}
//判断是否存在这辆车
public static bool ReturnCarExist(Model_FreedomCars car)
{
if (dal_freecar.ReturnCarExitst(car).Tables[0].Rows.Count>0)
{
return true;
}
else
{
return false;
}
}
private void Button_NextStep_Click(object sender, EventArgs e)
{
if (this.textBox_placeid.Text==""||this.textBox_carnumbers.Text==""||this.textBox_mastername.Text==""||this.textBox_contactway.Text=="")
{
MessageBox.Show("输入项不能为空");
}
else
{
freecar = new Model_FreedomCars(Convert.ToInt32(this.textBox_placeid.Text),
this.textBox_carnumbers.Text,
this.textBox_mastername.Text,
this.textBox_contactway.Text);
if (BLL_FreedomCars.ReturnCarExist(freecar) == true)
{
this.Button_NextStep.Visible = false;
this.Button_NextStep.Enabled = false;
this.Button_Allow_Leave.Visible = true;
this.Button_Allow_Leave.Enabled = true;
record = BLL_Records.ReturnRecordByNumbersAndName(
this.textBox_carnumbers.Text,
this.textBox_mastername.Text
);
record.SetOuttime(DateTime.Now);
record.SetMoney(10);
this.label_entertime.Text = record.ReturnEntertime();
this.label_leavetime.Text = record.ReturnOutertime();
this.label_timecost.Text = record.ReturnAllStayTime();
this.label_moneycost.Text = record.ReturnMoney();
this.costlist.Visible = true;
}
else
{
MessageBox.Show("输入信息有误，请重新输入！");
this.textBox_carnumbers.Text = "";
this.textBox_contactway.Text = "";
this.textBox_mastername.Text = "";
this.textBox_placeid.Text = "";
}
}
}
//插入操作
public void InsertNewCar(Model_FreedomCars newcar)
{
string sql = string.Format("INSERT INTO "
+ "freedomcar (placeid,carnumbers,name,contactway,entertime) "
+ " VALUES('{0}','{1}','{2}','{3}','{4}')"
, newcar.ReturnPlaceid(),
newcar.ReturnCarNumbers(),
newcar.ReturnMasterName(),
newcar.ReturnContactWay(),
newcar.ReturnEnetertime().ToString());
conn.DBcmd(sql);
}
//删除操作
public void DeleteOneCar(Model_FreedomCars leavecar)
{
string sql = "delete from freedomcar where carnumbers='"+ leavecar.ReturnCarNumbers()+"'";
conn.DBcmd(sql);
}
//修改操作
public void UpdateInformation(Model_FreedomCars car)
{
string sql = "UPDATE freedomcar " +
" SET placeid='" + car.ReturnPlaceid()
+ "',carnumbers='" + car.ReturnCarNumbers()
+ "',name='" + car.ReturnMasterName()
+ "',contactway='"+car.ReturnContactWay()+"'"+
" WHERE carnumbers='" + car.ReturnCarNumbers()+ "'";
conn.DBcmd(sql);
}
//通过车位号返回一个model对象
public Model_FreedomCars ReturnFreecarModelByPlaceid(string placeid)
{
Model_FreedomCars freecar;
string sql = "select * from freedomcar where placeid='" + placeid + "'";
DataSet dataset = conn.DBQuery(sql);
DataTable datatable = dataset.Tables[0];
if (datatable.Rows.Count > 0)
{
DataRow row = datatable.Rows[0];
freecar = new Model_FreedomCars(
Convert.ToInt32(row["placeid"].ToString()),
row["carnumbers"].ToString(),
row["name"].ToString(),
row["contactway"].ToString(),
Convert.ToDateTime(row["entertime"]));
}
else
{
freecar = null;
}
return freecar;
}
public DataSet ReturnCarExitst(Model_FreedomCars car)
{
string sql = string.Format("select * from freedomcar where carnumbers='{0}'" +
"and placeid='{1}' and name='{2}'"
, car.ReturnCarNumbers(), car.ReturnPlaceid(), car.ReturnMasterName());
return conn.DBQuery(sql);
}
//修改一辆车的信息
public static void UpdateInformation(Model_FreedomCars car)
{
dal_freecar.UpdateInformation(car);
}
//一辆自由车离开
public static void LeaveOneFreeCar(Model_FreedomCars leavecar)
{
dal_freecar.DeleteOneCar(leavecar);
}
//一辆自由车进入
public static void EnterNewFreeCar(Model_FreedomCars newcar)
{
dal_freecar.InsertNewCar(newcar);
}
