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