Ejemplo n.º 1
0
 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);
 }
Ejemplo n.º 2
0
        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 = "";
                }

            }
        }