private void button1_Click_1(object sender, EventArgs e) { //try //{ Int64 sood = Int64.Parse(lblprice.Text) - Int64.Parse(lblhazine.Text); string DateDay = lblsabtday.Text; string Year = lblsabtyear.Text; string Month = lblsabtmonth.Text; string Day = lblsabtday.Text; string MajlesDate = cmbyear.Text + "/" + cmbmonth.Text + "/" + cmbday.Text; int status; status = 1; string type = "0"; string halat = "1"; DBManagment objdbclass = new DBManagment(); string majles = "0"; string takhfif; if (txtProtakhfif.Text == "") { takhfif = "0"; } else { takhfif = txtProtakhfif.TextValue.ToString(); } objdbclass.Inserttable("Insert Into Sefaresh (Sefareshid,Name,Number,Price,SumPrice,Sood,SabtDate,SabtYear,SabtMonth,SabtDay,MajlesDate,MajlesYear,MajlesMonth,MajlesDay,Des,Type,Takhfif,halat,OneSood,status) Values (N'" + Int64.Parse(lblsefareshid.Text) + "', N'" + lblname.Text + "' ,'" + Int64.Parse(txttedad.Text) + "','" + Int64.Parse(lblprice.Text) + "','" + Int64.Parse(lblprice.Text) * Int64.Parse(txttedad.Text) + "','" + sood * Int64.Parse(txttedad.Text) + "','" + DateDay + "','" + Year + "','" + Month + "','" + Day + "', '" + MajlesDate + "' , '" + cmbyear.Text + "','" + cmbmonth.Text + "','" + cmbday.Text + "','" + txtdes.Text + "','" + type + "','" + Int64.Parse(takhfif) + "','" + Int16.Parse(halat) + "','" + sood + "','" + status + "')"); // Loadgridview2(); search("Select id,Name,Number,Price,SumPrice,OneSood from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "'"); Int64 sum = Int64.Parse(lblprice.Text) * Int32.Parse(txttedad.Text); // textBox1.Text = (Int64.Parse(textBox1.Text) + sum).ToString(); // MessageBox.Show(" ثبت با موفقیت انجام شد"); // search("Select id,Name,Number,Price,SumPrice,OneSood from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "'"); // select("Select * from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "'"); sumprice(" Select SUM(SumPrice)as SUM,SUM(Sood) as sood from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "' "); //} //catch //{ // MessageBox.Show(" عملیات ثبت امکان پذیر نمی باشد"); //} }
private void button1_Click_1(object sender, EventArgs e) { DBManagment objDBClass = new DBManagment(); string selectCmd = string.Format("Select * from Factor where Factorid='" + Int64.Parse(txtfactorid.Text) + "' and Name=N'" + lblname.Text + "'"); string hasrows = objDBClass.SelectHasRows(selectCmd); if (hasrows == "ok") { MessageBox.Show("این غذا را ثبت کرده اید لطفا از جدول پایینی تعداد آنرا اضافه کنید", "توجه"); } else { bool successfullCreateAccount = true; try { Int64 sood = Int64.Parse(lblprice.Text) - Int64.Parse(lblhazine.Text); string DateDay = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(0, 10); string Year = FarsiLibrary.Utils.PersianDate.Now.Year.ToString(); string Month = FarsiLibrary.Utils.PersianDate.Now.Month.ToString(); string Day = FarsiLibrary.Utils.PersianDate.Now.Day.ToString(); DBManagment objdbclass = new DBManagment(); string adi = "1"; objdbclass.Inserttable("Insert Into Factor (Factorid,Name,Number,Price,SumPrice,Sood,Date,Year,Month,Day,Type,Takhfif,status) Values (N'" + Int64.Parse(txtfactorid.Text) + "', N'" + lblname.Text + "' ,'" + Int64.Parse(lbltedad.Text) + "','" + Int64.Parse(lblprice.Text) + "','" + Int64.Parse(lblprice.Text) * Int64.Parse(lbltedad.Text) + "','" + sood * Int64.Parse(lbltedad.Text) + "','" + DateDay + "','" + Year + "','" + Month + "','" + Day + "','" + adi + "','" + Int64.Parse("0") + "','" + Int64.Parse("0") + "')"); loadgridview2(); Int64 sum = Int64.Parse(lblprice.Text) * Int32.Parse(lbltedad.Text); txtProNet1.Text = (Int64.Parse(txtProNet1.TextValue.ToString()) + sum).ToString(); string takhfif = txtProtakhfif.TextValue.ToString(); txtProNet2.Text = (Int64.Parse(txtProNet1.TextValue.ToString()) - Int64.Parse(takhfif)).ToString(); } catch { successfullCreateAccount = false; MessageBox.Show("ثبت غذا امکانپذیر نمی باشد", "توجه"); } } }
private void button1_Click(object sender, EventArgs e) { try { DBManagment objdbclass = new DBManagment(); objdbclass.Inserttable("Insert Into person (address,tell,mobile,name) Values (N'" + textBox3.Text + "', '" + Int32.Parse(textBox1.Text) + "' ,'" + Int64.Parse(textBox2.Text) + "',N'" + textBox4.Text + "')"); MessageBox.Show(" ثبت با موفقیت انجام شد"); SqlConnection objcon = new SqlConnection("Data Source=Localhost;Initial Catalog=FoodDB; Integrated Security=True"); SqlDataAdapter objadapter = new SqlDataAdapter("Select top 1 id from person order by id Desc ", objcon); DataSet objset = new DataSet(); objadapter.Fill(objset, "person"); DataRow objdatarow1 = objset.Tables["person"].Rows[0]; label4.Text = objdatarow1["id"].ToString(); } catch { MessageBox.Show(" عملیات ثبت امکان پذیر نمی باشد"); } }
private void button1_Click(object sender, EventArgs e) { try { Int64 sood = Int64.Parse(lblprice.Text) - Int64.Parse(lblhazine.Text); string DateDay = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(0, 10); string Year = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(0, 4); string Month = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(5, 2); string Day = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(8, 2); DBManagment objdbclass = new DBManagment(); string majles = "0"; int status = int.Parse("0"); objdbclass.Inserttable("Insert Into Sefaresh (Sefareshid,Name,Number,Price,SumPrice,Sood,SabtDate,SabtYear,SabtMonth,SabtDay,OneSood,status) Values (N'" + Int64.Parse(lbfactorid.Text) + "', N'" + lblname.Text + "' ,'" + Int64.Parse(txttedad.Text) + "','" + Int64.Parse(lblprice.Text) + "','" + Int64.Parse(lblprice.Text) * Int64.Parse(txttedad.Text) + "','" + sood * Int64.Parse(txttedad.Text) + "','" + DateDay + "','" + Year + "','" + Month + "','" + Day + "','" + sood + "','" + status + "')"); Loadgridview2(); Int64 sum = Int64.Parse(lblprice.Text) * Int32.Parse(txttedad.Text); txtProNet1.Text = (Int64.Parse(txtProNet1.TextValue.ToString()) + sum).ToString(); } catch { MessageBox.Show("افزودن این غذا امکانپذیر نمی باشد", "توجه"); } }
private void btnsabt_Click(object sender, EventArgs e) { try { Int64 mablagh = Int64.Parse(txtPromablagh.TextValue.ToString()); Int64 mablaghbedehi = Int64.Parse(txtprodiv.TextValue.ToString()); if (mablagh <= mablaghbedehi) { string DateDay = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(0, 10); string Year = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(0, 4); string Month = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(5, 2); string Day = FarsiLibrary.Utils.PersianDate.Now.ToString().Substring(8, 2); DBManagment objdbclass = new DBManagment(); objdbclass.Inserttable("Insert Into SefareshMoney (Sefareshid,MoneyDate,MoneyYear,MoneyMonth,MoneyDay,Money) Values (N'" + Int64.Parse(txtsefareshid0.Text) + "', '" + DateDay + "' ,'" + Year + "','" + Month + "','" + Day + "','" + Int64.Parse(txtPromablagh.TextValue.ToString()) + "')"); MessageBox.Show("ثبت با موفقیت انجام شد"); search("select Sefareshid,MoneyDate,Money from SefareshMoney where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "' "); bedehkar(); sumprice(" Select SUM(SumPrice)as SUM from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "' "); takhfif(" Select Takhfif from Sefaresh where Sefareshid='" + Int64.Parse(txtsefareshid0.Text) + "' "); bedehkar(); } else { MessageBox.Show("مبلغ واریزی از بدهی بیشتر است"); } } catch { MessageBox.Show("ثبت امکان پذیر نیست"); } }