private void btnget_Click(object sender, EventArgs e) { if (txtcode.Text.Length == 0) { return; } try { dt.Clear(); } catch (Exception e1) { } dataGridView1.Rows.Clear(); db DB = new db(""); dt = DB.getRow("SELECT * FROM tbl_data WHERE sID = " + txtcode.Text); if (dt == null) { return; } foreach (DataRow dr in dt.Rows) { string price; try { double db = Convert.ToDouble(dr["sPrice"].ToString()); price = db.ToString("N0") + " تومان"; } catch (Exception e1) { price = dr["sPrice"].ToString() + " تومان"; } try { dataGridView1.Rows.Add(dr["sType"].ToString(), dr["sBargain"].ToString(), dr["sOwnerName"].ToString(), dr["sMobile"].ToString(), dr["sPhone"].ToString(), dr["sDateFa"].ToString(), dr["sBuildingYear"].ToString() + " سال", dr["sFoundation"].ToString(), price); } catch (Exception e2) { } } }
private void btnfilter_Click(object sender, EventArgs e) { string query; query = "SELECT * FROM tbl_data WHERE "; if (ck1.Checked || ck2.Checked || ck3.Checked || ck4.Checked || ck5.Checked || ck6.Checked) { string in_where = " sType IN ("; var listOfStrings = new List <string>(); if (ck1.Checked) { listOfStrings.Add("'آپارتمان'"); } if (ck2.Checked) { listOfStrings.Add("'کلنگی'"); } if (ck3.Checked) { listOfStrings.Add("'مغازه'"); } if (ck4.Checked) { listOfStrings.Add("'ویلا'"); } if (ck5.Checked) { listOfStrings.Add("'پارکینگ'"); } if (ck6.Checked) { listOfStrings.Add("'انباری'"); } in_where += String.Join(",", listOfStrings.ToArray()); query += in_where + ") AND "; } if (ckt1.Checked || ckt2.Checked || ckt3.Checked) { string in_where = " sBargain IN ("; var listOfStrings2 = new List <string>(); if (ckt1.Checked) { listOfStrings2.Add("'فروشی'"); } if (ckt2.Checked) { listOfStrings2.Add("'اجاره'"); } if (ckt3.Checked) { listOfStrings2.Add("'رهن'"); } in_where += String.Join(",", listOfStrings2.ToArray()); query += in_where + ") AND "; } if (txtpricefrom.Text.Length != 0 && txtpriceto.Text.Length != 0) { query += "sPrice BETWEEN '" + txtpricefrom.Text + "' AND '" + txtpriceto.Text + "' AND "; } if (txtkhab.SelectedIndex > -1) { query += "sKhab = '" + txtkhab.SelectedItem + "' AND "; } if (txtejarehfrom.Text.Length != 0 && txtejarehto.Text.Length != 0) { query += "sRent BETWEEN '" + txtejarehfrom.Text + "' AND '" + txtejarehto.Text + "' AND "; } if (txtrahnfrom.Text.Length != 0 && txtrahnto.Text.Length != 0) { query += "sMortgage BETWEEN '" + txtrahnfrom.Text + "' AND '" + txtrahnto.Text + "' AND "; } if (txtfoundationfrom.Text.Length != 0 && txtfoundationto.Text.Length != 0) { query += "sFoundation BETWEEN '" + txtfoundationfrom.Text + "' AND '" + txtfoundationto.Text + "' AND "; } if (txtnof.SelectedIndex != -1) { query += "sFloorPosition = '" + (txtnof.SelectedIndex + 1).ToString() + "' AND "; } if (txtnou.SelectedIndex != -1) { query += "sNumberOfUnit = '" + (txtnou.SelectedIndex + 1).ToString() + "' AND "; } if (txtyearbuilding.SelectedIndex != -1) { query += "sBuildingYear = '" + (txtyearbuilding.SelectedIndex + 1).ToString() + "' AND "; } if (ckasansor.Checked) { query += "sAsansor = 'True' AND "; } if (ckparking.Checked) { query += "sParking = 'True' AND "; } if (ckanbari.Checked) { query += "sAnbari = 'True' AND "; } if (ckvam.Checked) { query += "sVam = 'True' AND "; } query += " 1=1"; db DB = new db(""); dt.Clear(); dt = DB.getRow(query); if (dt.Rows.Count == 0) { dataGridView1.Rows.Clear(); MessageBox.Show("هیچ موردی برای فیلتر تعین شده پیدا نشد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } dataGridView1.Rows.Clear(); foreach (DataRow dr in dt.Rows) { string price; try { double db = Convert.ToDouble(dr["sPrice"].ToString()); price = db.ToString("N0") + " تومان"; } catch (Exception e1) { price = dr["sPrice"].ToString() + " تومان"; } dataGridView1.Rows.Add(dr["sType"].ToString(), dr["sBargain"].ToString(), dr["sOwnerName"].ToString(), dr["sMobile"].ToString(), dr["sPhone"].ToString(), dr["sDateFa"].ToString(), price); } dataGridView1.ClearSelection(); }
private void btninsert_Click(object sender, EventArgs e) { if (txtname.Text.Length == 0) { MessageBox.Show("لطفا نام مالک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtmobile.Text.Length == 0) { MessageBox.Show("لطفا موبایل مالک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtaddress.Text.Length == 0) { MessageBox.Show("لطفا آدرس ملک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string bargain; bargain = "فروشی"; if (rbt1.Checked) { bargain = "فروشی"; } else if (rbt2.Checked) { bargain = "اجاره"; } else if (rbt3.Checked) { bargain = "رهن"; } string stype; if (rb1.Checked) { stype = "آپارتمان"; } else if (rb2.Checked) { stype = "کلنگی"; } else if (rb3.Checked) { stype = "مغازه"; } else if (rb4.Checked) { stype = "ویلا"; } else if (rb5.Checked) { stype = "پارکینگ"; } else if (rb6.Checked) { stype = "انباری"; } else { stype = "آپارتمان"; } string date = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day; string query; query = String.Format("UPDATE tbl_data SET sType = '{0}',sOwnerName = '{1}',sMobile = '{2}',sPhone = '{3}',sAddress = '{4}',sNumberOfFloor = '{5}',sNumberOfUnit = '{6}',sBuildingYear = '{7}',sPrice = '{8}',sFloorPosition = '{9}',sArea = '{10}',sFoundation = '{11}',sKhab = '{12}',sKooler = '{13}',sGaz = '{14}',sTelephone = '{15}',sParking = '{16}',sAnbari = '{17}',sAsansor = '{18}',sTeras = '{19}',sNema = '{20}',sKaf = '{21}',sAshpazkhooneh = '{22}',sVam = '{23}',sDesc = '{24}',sBargain = '{25}',sRent = '{26}',sMortgage = '{27}' WHERE sID = '" + dr["sID"].ToString() + "'", stype, txtname.Text, txtmobile.Text, txtphone.Text, txtaddress.Text, txtnof.SelectedIndex + 1, txtnou.SelectedIndex + 1, txtyearbuilding.SelectedIndex + 1, txtprice.Text.Replace(",", ""), txtfloorposition.SelectedIndex + 1, txtarea.Text, txtfoundation.Text, txtkhab.SelectedIndex + 1, ckkooler.Checked, ckgaz.Checked, ckphone.Checked, ckparking.Checked, ckanbari.Checked, ckasansor.Checked, ckteras.Checked, txtnama.Text, txtkaf.Text, txtashpazkhooneh.Text, ckvam.Checked, txtdesc.Text, bargain, txtejareh.Text.Replace(",", ""), txtvadieh.Text.Replace(",", "")); db DB = new db(""); DB.RunQuery(query); MessageBox.Show("اطلاعات با موفقیت بروز شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information); }