private void FormBoxStorage_Load(object sender, EventArgs e)
{
InsertSQL bs = new InsertSQL();
//productLists = order1.GetPorductList();
if (state == "Edit")
{
InsertSQL boxStorage = new InsertSQL();
//productLists = order1.GetPorductList();
if (state == "Edit")
{
bs11.Add_date = Convert.ToDateTime(dateTimePicker1.Text);
textBox1.Text = bs11.StoringJob_id.ToString();
textBox2.Text = bs11.Product_id.ToString();
textBox3.Text = bs11.Box_id.ToString();
textBox4.Text = bs11.NettWeight.ToString();
textBox5.Text = bs11.Storeroom_id.ToString();
dateTimePicker1.Value = bs11.Add_date;
dateTimePicker2.Value = bs11.Best_before;
dateTimePicker3.Value = bs11.Out_date;
textBox6.Text = bs11.Order_id.ToString();
}
}
}
private void addHarvestingJob()
{
HarvestingJob hj = new HarvestingJob();
hj.Description = textBox1.Text;
hj.SowingJob_id = Convert.ToInt32(cbSoj.Text);
string idStr = cbFarm.Text.Split('.')[0];
hj.Farm_id = int.Parse(idStr);
string idStr1 = cbCrop.Text.Split('.')[0];
hj.Crop_id = int.Parse(idStr1);
string idStr2 = cbVehicle.Text.Split('.')[0];
hj.Vehicle_id = int.Parse(idStr2);
hj.Est_quantity = int.Parse(numericUpDown1.Text);
hj.Harvested_quantity = int.Parse(numericUpDown2.Text);
string idStr3 = cbEmployee.Text.Split('.')[0];
hj.Employee_id = int.Parse(idStr3);
hj.Date_start = Convert.ToDateTime(dtpStart1.Value);
hj.Date_end = Convert.ToDateTime(dtpEnd.Value);
InsertSQL hdl = new InsertSQL();
hdl.addNewHarvestingJob(hj);
MessageBox.Show("Success!!");
this.Close();
}
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();
}
private void addPesticideJob()
{
PesticideJob pj = new PesticideJob();
pj.Description = textBox1.Text;
string idStr = cbPesticide.Text.Split('.')[0];
pj.Pesticide_id = int.Parse(idStr);
pj.Quantity_kg = int.Parse(textBox3.Text);
string idStr1 = cbSoj.Text.Split('.')[0];
pj.SowingJob_id = int.Parse(idStr1);
string idStr2 = cbFarm.Text.Split('.')[0];
pj.Farm_id = int.Parse(idStr2);
string idStr3 = cbVehicle.Text.Split('.')[0];
pj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbCrop.Text.Split('.')[0];
pj.Crop_id = int.Parse(idStr4);
string idStr5 = cbEmployee.Text.Split('.')[0];
pj.Employee_id = int.Parse(idStr5);
pj.Date_start = Convert.ToDateTime(dtpStart.Text);
pj.Date_end = Convert.ToDateTime(dtpEnd.Text);
InsertSQL add = new InsertSQL();
int addrecord = add.addNewPesticideJob(pj);
MessageBox.Show("Success!!");
this.Close();
}
private void addFertiliser()
{
FertilisingJob fj = new FertilisingJob();
fj.Description = textBox1.Text;
string idStr = cbFertiliser.Text.Split('.')[0];
fj.Fertiliser_id = int.Parse(idStr);
fj.Quantity_kg = int.Parse(textBox3.Text);
string idStr1 = cbSoj.Text.Split('.')[0];
fj.SowingJob_id = int.Parse(idStr1);
string idStr2 = cbFarm.Text.Split('.')[0];
fj.Farm_id = int.Parse(idStr2);
string idStr3 = cbVehicle.Text.Split('.')[0];
fj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbCrop.Text.Split('.')[0];
fj.Crop_id = int.Parse(idStr4);
string idStr5 = cbEmployee.Text.Split('.')[0];
fj.Employee_id = int.Parse(idStr5);
fj.Date_start = this.dtpStart.Value;
fj.Date_end = this.dtpEnd.Value;
InsertSQL add = new InsertSQL();
int addrecord = add.addNewFertilisingJob(fj);
MessageBox.Show("Success!!");
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtProductName.Text))
{
MessageBox.Show("请输入商品名称");
}
if (string.IsNullOrEmpty(txtInPrice.Text))
{
MessageBox.Show("请输入进货价格");
}
if (string.IsNullOrEmpty(txtProductCode.Text))
{
MessageBox.Show("请输入商品编号");
}
//插入
if (_opearType == "添加")
{
var sql = InsertSQL.InsertProduct(txtProductName.Text, txtInPrice.Text, txtOutPrice.Text,
txtProductCode.Text, txtProductNum.Text, txtRemark.Text, _clientId, _pictureId);
MessageBox.Show(InsertData.InsertIntoData(sql) ? "添加商品成功" : "添加商品失败");
}
//更新
if (_opearType == "修改")
{
var updatesql = UpdateSQL.UpdateProduct(txtProductName.Text, txtInPrice.Text, txtOutPrice.Text,
txtProductCode.Text, txtProductNum.Text, txtRemark.Text, _clientId, _pictureId, _productId);
MessageBox.Show(UpdateData.UpdateInfo(updatesql) ? "更新商品成功" : "更新商品失败");
}
Close();
}
private void addStoringJob()
{
StoringJob sj = new StoringJob();
sj.Description = textBox1.Text;
string idStr = cbHarvest.Text.Split('.')[0];
sj.Harvest_id = int.Parse(idStr);
string idStr1 = cbCrop.Text.Split('.')[0];
sj.Crop_id = int.Parse(idStr1);
string idStr2 = cbBox.Text.Split('.')[0];
sj.Box_id = int.Parse(idStr2);
sj.Quantity = int.Parse(textBox5.Text);
string idStr3 = cbVehicle.Text.Split('.')[0];
sj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbEmployee.Text.Split('.')[0];
sj.Employee_id = int.Parse(idStr4);
sj.Date_start = Convert.ToDateTime(dtpStart.Text);
sj.Date_end = Convert.ToDateTime(dtpEnd.Text);
InsertSQL addHnd = new InsertSQL();
int addrecord = addHnd.addNewStoringJob(sj);
MessageBox.Show(addrecord + " Your record is added");
this.Close();
}
private void FormStoringJob_Load(object sender, EventArgs e)
{
InsertSQL StoringJob = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = sj1.Description;
cbHarvest.Text = sj1.Harvest_id.ToString();
cbCrop.Text = sj1.Crop_id.ToString();
cbBox.Text = sj1.Box_id.ToString();
textBox5.Text = sj1.Quantity.ToString();
cbVehicle.Text = sj1.Vehicle_id.ToString();
cbEmployee.Text = sj1.Employee_id.ToString();
dtpStart.Value = sj1.Date_start;
dtpEnd.Value = sj1.Date_end;
TestSQL ts = new TestSQL();
cropLists = ts.GetCropList();
employeeList = ts.GetEmployeeList();
vehicleList = ts.GetVehicleList();
boxList = ts.GetBoxList();
harvestLists = ts.GetHarvestingJobList();
SowingJob sj11 = new SowingJob();
foreach (HarvestingJob harvest in harvestLists)
{
string showText = harvest.Id + ". " + harvest.Description;
cbCrop.Items.Add(showText);
}
foreach (Box box in boxList)
{
string showText = box.Id + ". " + box.Name;
cbCrop.Items.Add(showText);
}
foreach (Crop crop1 in cropLists)
{
string showText = crop1.Id + ". " + crop1.Name;
cbCrop.Items.Add(showText);
}
foreach (Vehicle vehicle in vehicleList)
{
string showText = vehicle.Id + ". " + vehicle.Name;
cbVehicle.Items.Add(showText);
}
foreach (Employee employee in employeeList)
{
if (employee.Admin == false)
{
string showText = employee.Id + ". " + employee.Username;
cbEmployee.Items.Add(showText);
}
}
}
}
private void FormPesticide_Load(object sender, EventArgs e)
{
InsertSQL pesticide = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = p11.Name;
textBox2.Text = p11.Quantity_kg.ToString();
textBox3.Text = p11.Remark;
}
}
private void FormFertiliser_Load(object sender, EventArgs e)
{
InsertSQL crop = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = f11.Name;
textBox2.Text = f11.Quantity_kg.ToString();
textBox3.Text = f11.Remark;
}
}
//private bool checkInput()
//{
//int checkint;
//if (!int.TryParse(areaText.Text, out checkint))
//{
// return false;
//}
//if (!int.TryParse(utiliseAreaText.Text, out checkint))
//{
// return false;
//}
//return true;
//}
private void FormFarm_Load(object sender, EventArgs e)
{
InsertSQL farm = new InsertSQL();
if (state == "Edit")
{
descriptionText.Text = farmfarm.Description;
areaText.Text = farmfarm.Area.ToString();
utiliseAreaText.Text = farmfarm.Utilize_area.ToString();
}
}
private void FormStoreroom_Load(object sender, EventArgs e)
{
InsertSQL storeroom = new InsertSQL();
if (state == "Edit")
{
descriptionText.Text = sr1.Description;
storeNumericUpDown.Text = sr1.StoringQty.ToString();
tempText.Text = sr1.Temperature.ToString();
}
}
private void SQLHelp_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
ssc = new SQLStringCheck();
dbf = new DataBaseField();
insql = new InsertSQL();
updatesql = new UpdateSQL();
ocon = new ObjectConstructor();
IntiData();
}
private void FormCropcs_Load(object sender, EventArgs e)
{
InsertSQL crop = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = cr.Name;
textBox2.Text = cr.Type;
textBox3.Text = cr.Quantity_plot.ToString();
textBox4.Text = cr.Remark.ToString();
}
}
private void FormCustomer_Load(object sender, EventArgs e)
{
InsertSQL customer1 = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = cust.Name;
textBox2.Text = cust.Email;
textBox3.Text = cust.Phone;
textBox4.Text = cust.Remark;
}
}
private void FormProduct_Load(object sender, EventArgs e)
{
InsertSQL product = new InsertSQL();
if (state == "Edit")
{
nameText.Text = prodd.Name;
typeText.Text = prodd.Type;
quantityNumericUpDown.Text = prodd.Quantity_box.ToString();
weightText.Text = prodd.Weight.ToString();
boxIdText.Text = prodd.Box_id.ToString();
}
}
private void FormVehicle_Load(object sender, EventArgs e)
{
InsertSQL vehicle = new InsertSQL();
if (state == "Edit")
{
nameText.Text = v11.Name;
serialNumText.Text = v11.Serial_number;
buyDateTimePicker.Text = v11.Buy_date.ToString();
serviceDateTimePicker.Text = v11.Last_service_date.ToString();
remarkText.Text = v11.Remark.ToString();
}
}
private void addPesticide()
{
Pesticide p1 = new Pesticide();
p1.Name = textBox1.Text;
p1.Quantity_kg = Int32.Parse(textBox2.Text);
p1.Remark = textBox3.Text;
InsertSQL add = new InsertSQL();
int changerecord = add.addNewPesticide(p1);
MessageBox.Show(changerecord + " Your record is added");
}
private void addFertiliser()
{
Fertiliser f1 = new Fertiliser();
f1.Name = textBox1.Text;
f1.Quantity_kg = Convert.ToInt32(textBox2.Text);
f1.Remark = textBox3.Text;
InsertSQL add = new InsertSQL();
int addrecord = add.addNewFertiliser(f1);
MessageBox.Show("Seccuess!!");
this.Close();
}
public void addFarm()
{
Farm f1 = new Farm();
f1.Description = descriptionText.Text;
f1.Area = Convert.ToInt32(areaText.Text);
f1.Utilize_area = Convert.ToInt32(utiliseAreaText.Text);
InsertSQL add = new InsertSQL();
int addrecord = add.addNewFarm(f1);
MessageBox.Show("Successful");
this.Close();
}
public void addCrop()
{
Crop crop = new Crop();
crop.Name = textBox1.Text;
crop.Type = textBox2.Text;
crop.Quantity_plot = Convert.ToInt32(textBox3.Text);
crop.Remark = textBox4.Text;
InsertSQL add = new InsertSQL();
int editrecord = add.addNewCrop(crop);
MessageBox.Show(" Your seccusful");
this.Close();
}
public void addVehicle()
{
Vehicle vech = new Vehicle();
vech.Name = nameText.Text;
vech.Serial_number = serialNumText.Text;
vech.Buy_date = this.buyDateTimePicker.Value;
vech.Last_service_date = this.serviceDateTimePicker.Value;
vech.Remark = remarkText.Text;
InsertSQL vechHnd = new InsertSQL();
int addrecord = vechHnd.addNewVehicle(vech);
MessageBox.Show(addrecord + "Your record is added");
}
private void FormBox_Load(object sender, EventArgs e)
{
InsertSQL box = new InsertSQL();
if (state == "Edit")
{
textBox1.Text = bb1.Name;
textBox2.Text = bb1.Width.ToString();
textBox3.Text = bb1.Height.ToString();
textBox4.Text = bb1.Length.ToString();
textBox5.Text = bb1.Max_weight.ToString();
textBox6.Text = bb1.Quantity.ToString();
textBox7.Text = bb1.Status;
}
}
private void addCustomer()
{
Customer c1 = new Customer();
c1.Name = textBox1.Text;
c1.Email = textBox2.Text;
c1.Phone = textBox3.Text;
c1.Remark = textBox4.Text;
InsertSQL add = new InsertSQL();
int editrecord = add.addNewCustomer(c1);
MessageBox.Show(" Your seccusful");
this.Close();
}
private void add()
{
Product prod = new Product();
prod.Name = nameText.Text;
prod.Type = typeText.Text;
prod.Quantity_box = Convert.ToInt32(quantityNumericUpDown.Value);
prod.Weight = decimal.Parse(weightText.Text);
prod.Box_id = Int32.Parse(boxIdText.Text);
InsertSQL prodHnd = new InsertSQL();
int addrecord = prodHnd.addNewProduct(prod);
MessageBox.Show("Your record is added");
this.Close();
}
public static bool AddResourceRecord(int blogId, string resourceId, ResourceType type, bool continuted = false)
{
try
{
IInsertDataSourceFace query = new InsertSQL(TableName.ResourceRecord);
query.DataBaseAlias = Const.LogConnection;
query.AddFieldValue("BlogId", blogId);
query.AddFieldValue("ResourceId", resourceId.Trim());
query.AddFieldValue("ResourceType", (int)type);
query.AddFieldValue("Continued", continuted);
return(query.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
Logger.Error(ex);
return(false);
}
}
private void addBox()
{
Box box = new Box();
box.Name = textBox1.Text;
box.Width = Convert.ToDouble(textBox2.Text);
box.Height = Convert.ToDouble(textBox3.Text);
box.Length = Convert.ToDouble(textBox4.Text);
box.Max_weight = Convert.ToDouble(textBox5.Text);
box.Quantity = Convert.ToInt32(textBox6.Text);
box.Status = textBox7.Text;
InsertSQL addHnd = new InsertSQL();
int addrecord = addHnd.addNewBox(box);
MessageBox.Show("Success!!");
this.Close();
}
private void FormEmployee_Load(object sender, EventArgs e)
{
InsertSQL farm = new InsertSQL();
if (state == "Edit")
{
firstNameText.Text = emp1.First_name;
lastNameText.Text = emp1.Last_name;
usernameText.Text = emp1.Username;
passwordText.Text = emp1.Password;
dobText.Text = emp1.Dob.ToString();
mobileText.Text = emp1.Mobile;
emailText.Text = emp1.Email;
adminText.Text = emp1.Admin.ToString();
statusText.Text = emp1.Status;
remarkText.Text = emp1.Remark;
}
}
public static bool InitialFetchRecord(ResourceType type)
{
try
{
IInsertDataSourceFace query = new InsertSQL(TableName.FetchRecord);
query.DataBaseAlias = Const.LogConnection;
query.AddFieldValue("ResourceType", (int)type);
query.AddFieldValue("FetchCount", 0);
query.AddFieldValue("RequestCount", 0);
query.AddFieldValue("TimeStamp", DateTime.Now);
return(query.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
Logger.Error(ex);
return(false);
}
}
public static bool Add(ImageUrl image)
{
try
{
IInsertDataSourceFace query = new InsertSQL(TableName.ImageUrl);
query.DataBaseAlias = Const.LogConnection;
query.AddFieldValue("BlogId", image.BlogId);
query.AddFieldValue("Url", image.Url);
query.AddFieldValue("TimeStamp", DateTime.Now);
query.AddFieldValue("YunUrl", image.YunUrl);
query.AddFieldValue("ImageStatus", image.ImageStatus);
return(query.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
Logger.Error(ex);
return(false);
}
}
