C# (CSharp) InsertSQL.addNewSowingJob示例

示例#1

        public void add()
        {
            //checkAsignJobandAdd();
            SowingJob s1 = new SowingJob();

            s1.Description = tbDescription.Text;
            string idStr = cbCrop.Text.Split('.')[0];

            s1.Crop_id       = int.Parse(idStr);
            s1.Quantity_prop = Int32.Parse(nUDQty.Text);
            string idStr1 = cbFarm.Text.Split('.')[0];

            s1.Farm_id   = int.Parse(idStr1);
            s1.Used_area = textBox1.Text;
            string idStr2 = cbVehicle.Text.Split('.')[0];

            s1.Vehicle_id = int.Parse(idStr2);
            string idStr3 = cbEmployee.Text.Split('.')[0];

            s1.Employee_id = int.Parse(idStr3);
            s1.Date_start  = this.dtpDate.Value;
            s1.Date_end    = this.dtpDateEnd.Value;
            //s1.Employee_id = Int32.Parse(cbEmployee.Text);

            InsertSQL add       = new InsertSQL();
            int       addrecord = add.addNewSowingJob(s1);

            MessageBox.Show("Success!!");

            this.Close();
        }