public Model_Records ReturnRecordsByMasterName(string searchtxt) { Model_Records record; string sql = "select * from records where name='" + searchtxt + "'"; DataSet dataset = conn.DBQuery(sql); DataTable datatable = dataset.Tables[0]; if (datatable.Rows.Count > 0) { DataRow row = datatable.Rows[0]; record = new Model_Records( Convert.ToInt32(row["id"].ToString()), row["name"].ToString(), row["carnumbers"].ToString(), row["contactway"].ToString(), Convert.ToInt32(row["placeid"].ToString()), Convert.ToDateTime(row["entertime"]), Convert.ToDateTime(row["outtime"]), Convert.ToDouble(row["money"]) ); } else { record = null; } return(record); }
//通过姓名和车牌号返回record,帮助判断数据库中是否存在这条记录 public Model_Records ReturnRecordByNumbersAndName(string carnumbers, string name) { Model_Records record; string sql = "select * from records where name='" + name + "' and carnumbers='" + carnumbers + "'"; DataSet dataset = conn.DBQuery(sql); DataTable datatable = dataset.Tables[0]; if (datatable.Rows.Count > 0) { DataRow row = datatable.Rows[0]; record = new Model_Records( row["name"].ToString(), row["carnumbers"].ToString(), row["contactway"].ToString(), Convert.ToInt32(row["placeid"].ToString()), Convert.ToDateTime(row["entertime"]) ); } else { record = null; } return(record); }
//修改操作,需要考虑 public void UpdateInformation(Model_Records record) { string sql = "UPDATE records " + " SET outtime='" + record.ReturnOutertime() + "',money='" + record.ReturnMoney() + "'" + " WHERE carnumbers='" + record.ReturnCarNumbers() + "'"; conn.DBcmd(sql); }
public void InsertRecord(Model_Records record) { string sql = string.Format("INSERT INTO " + "records (id,placeid,name,carnumbers,contactway,entertime) " + " VALUES('{0}','{1}','{2}','{3}','{4}','{5}')" , record.ReturnId(), record.ReturnPlaceid(), record.ReturnMasterName(), record.ReturnCarNumbers(), record.ReturnMasterContactWay(), record.ReturnEntertime().ToString()); conn.DBcmd(sql); }
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 = ""; } } }
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 void UpdateInformation(Model_Records record) { dal_record.UpdateInformation(record); }
//完成一条记录,保存在记录表中 public static void FinishOneRecord(Model_Records finishedrecord) { dal_record.FinishOneRecord(finishedrecord); }
//新建一条记录,等待支付 public static void AddNewRecord(Model_Records newrecord) { dal_record.InsertRecord(newrecord); }