private String model1() // when user fill rahn_low rahn_high ejare_low ejare_high { String sql = ""; TextRange _text = new TextRange(comments.Document.ContentStart, comments.Document.ContentEnd); String cmt = _text.Text; cmt = cmt.Remove(cmt.Length - 2); if (WndConfig.getConfig().rahn_complete&& ejare_Low.Text.Trim().Length == 0 && ejare_High.Text.Trim().Length == 0 && (rahn_Low.Text.Trim().Length != 0 || rahn_High.Text.Trim().Length != 0)) // rahn e complete { sql = "EXEC SearchManzelSRahnComplete N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + zirbanaa_Low.Text + "',N'" + zirbanaa_High.Text + "',N'" + tabaghaat_Low.Text + "',N'" + tabaghaat_High.Text + "',N'" + vahed_Low.Text + "',N'" + vahed_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + cmt + "'"; } else { sql = "EXEC SearchManzelSSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + zirbanaa_Low.Text + "',N'" + zirbanaa_High.Text + "',N'" + tabaghaat_Low.Text + "',N'" + tabaghaat_High.Text + "',N'" + vahed_Low.Text + "',N'" + vahed_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_High.Text) + "',N'" + cmt + "'"; } return(sql); }
private void insert_button_Click(object sender, RoutedEventArgs e) { if (!isRed) { if (textBox20.Text.Trim() == "") { isRed = true; textBox20.Background = Brushes.Pink; } if (textBox21.Text.Trim() == "") { isRed = true; textBox21.Background = Brushes.Pink; } if (textBox23.Text.Trim() == "") { isRed = true; textBox23.Background = Brushes.Pink; } } else { TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String sql = "EXEC InsertMaghazeF '" + Lbl_Date.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + textBox19.Text + "',N'" + textBox20.Text + "',N'" + textBox21.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox22.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox23.Text) + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + "," + checkBox15.IsChecked + "," + checkBox16.IsChecked + ",N'" + _RText.Text + "',N'" + txt_Moarefino.Text + "'"; DB.execSql(sql); MessageBox.Show("رکورد جدید با موفقیت ثبت گردید", "ثبت", MessageBoxButton.OK, MessageBoxImage.Information); if (AgainCheckBox.IsChecked == false) { Insert.MaghazeF w = new Insert.MaghazeF(); this.Close(); if (w.newId != null && w.newId.Length > 0) { w.Show(); } } else { initLabels(); } } catch (Exception) { MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void Button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; errorOccurred = false; try { String sql = "EXEC SearchBaghVillaFSimple N'" + address_Txt.Text + "',N'" + area_Low.Text + "',N'" + area_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(price_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(price_High.Text) + "'"; DataTable dt = DB.execSqlReturnDataTable(sql); if (Show3D_checkBox.IsChecked == true) { Result3D res3d = new Result3D(); res3d.dt = dt; res3d.Show(); } else { ResultWindow res = new ResultWindow(); res.which = Codes.BaghVillaForooshi; res.dt = dt.Copy(); if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } for (int i = 1; i < cols.Length; i++) { if (i == 2 || i == 24) { continue; } if ((area_Low.Text.Trim().Length != 0 || area_High.Text.Trim().Length != 0) && i == 3) { continue; } if (owner.Text.Trim().Length != 0 && i == 20) { continue; } dt.Columns.Remove(cols[i]); } res.gridView.DataSource = dt; res.Show(); } } catch (Exception) { errorOccurred = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
private String model1() // when user fill rahn_low rahn_high ejare_low ejare_high { String sql = "EXEC SearchApartmanMaskooniSSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + bedrooms_Low.Text + "',N'" + bedrooms_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_High.Text) + "'"; return(sql); }
void price_Tick(object sender, EventArgs e) { MyPriceTextBox.doMask(rahnl, rahn_Low); MyPriceTextBox.doMask(rahnh, rahn_High); MyPriceTextBox.doMask(ejarel, ejare_Low); MyPriceTextBox.doMask(ejareh, ejare_High); MyPriceTextBox.doMask(rahnoejarel, rahnoejare_Low); MyPriceTextBox.doMask(rahnoejareh, rahnoejare_High); }
private void insertIt() { TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String sql = "EXEC InsertManzelF '" + Lbl_Date.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox19.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox20.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox21.Text) + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + ",N'" + _RText.Text + "',N'" + txt_Moarefino.Text + "'"; String fid = DB.execSqlReturnScalar(sql).ToString(); DataTable dt = (DataTable)gridView.DataSource; for (int i = 0; i < dt.Rows.Count; i++) { String sq = "EXEC InsertMajmooeF " + fid; /*for (int j = 0; j < dt.Rows[i].ItemArray.Length; j++) * { * sq += ","+dt.Rows[i].ItemArray[j].ToString(); * }*/ sq += ",N'" + dt.Rows[i].ItemArray[0].ToString() + "'"; sq += ",N'" + dt.Rows[i].ItemArray[1].ToString() + "'"; sq += "," + dt.Rows[i].ItemArray[2].ToString(); sq += "," + dt.Rows[i].ItemArray[3].ToString(); sq += ",N'" + dt.Rows[i].ItemArray[4].ToString() + "'"; sq += ",N'" + dt.Rows[i].ItemArray[5].ToString() + "'"; DB.execSql(sq, 0); } MessageBox.Show("رکورد جدید با موفقیت ثبت گردید", "ثبت", MessageBoxButton.OK, MessageBoxImage.Information); if (AgainCheckBox.IsChecked == false) { Insert.HouseF w = new Insert.HouseF(); this.Close(); if (w.newId != null && w.newId.Length > 0) { w.Show(); } } else { initLabels(); } } catch (Exception) { MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void before_button_Click(object sender, RoutedEventArgs e) { if (index - 1 < 0) { return; } removeLbl.Visibility = Visibility.Hidden; Object[] obj = dt.Rows[--index].ItemArray; this.ID_Lbl.Content = Codes.MaghazeEstijari + " - " + obj[0].ToString(); this.date_Lbl.Content = obj[1].ToString(); this.textBox1.Text = obj[2].ToString(); this.textBox2.Text = obj[3].ToString(); this.textBox3.Text = obj[4].ToString(); this.textBox4.Text = obj[5].ToString(); this.textBox5.Text = obj[6].ToString(); this.textBox6.Text = obj[7].ToString(); this.textBox7.Text = obj[8].ToString(); this.textBox8.Text = obj[9].ToString(); this.textBox9.Text = obj[10].ToString(); this.textBox10.Text = obj[11].ToString(); this.textBox11.Text = obj[12].ToString(); this.textBox12.Text = obj[13].ToString(); this.textBox13.Text = obj[14].ToString(); this.textBox14.Text = obj[15].ToString(); this.textBox15.Text = obj[16].ToString(); this.textBox16.Text = obj[17].ToString(); this.textBox17.Text = obj[18].ToString(); this.textBox18.Text = obj[19].ToString(); this.textBox19.Text = obj[20].ToString(); this.textBox20.Text = obj[21].ToString(); this.textBox21.Text = MyPriceTextBox.doMaskOnce(obj[22].ToString()); this.textBox22.Text = MyPriceTextBox.doMaskOnce(obj[23].ToString()); this.textBox23.Text = obj[24].ToString(); this.checkBox1.IsChecked = (bool)obj[25]; this.checkBox2.IsChecked = (bool)obj[26]; this.checkBox3.IsChecked = (bool)obj[27]; this.checkBox4.IsChecked = (bool)obj[28]; this.checkBox5.IsChecked = (bool)obj[29]; this.checkBox6.IsChecked = (bool)obj[30]; this.checkBox7.IsChecked = (bool)obj[31]; this.checkBox8.IsChecked = (bool)obj[32]; this.checkBox9.IsChecked = (bool)obj[33]; this.checkBox10.IsChecked = (bool)obj[34]; this.checkBox11.IsChecked = (bool)obj[35]; this.checkBox12.IsChecked = (bool)obj[36]; this.checkBox13.IsChecked = (bool)obj[37]; this.checkBox14.IsChecked = (bool)obj[38]; this.checkBox15.IsChecked = (bool)obj[39]; this.checkBox16.IsChecked = (bool)obj[40]; TextRange _RText = new TextRange(this.richTextBox1.Document.ContentStart, this.richTextBox1.Document.ContentEnd); _RText.Text = obj[41].ToString(); this.txt_Moarefino.Text = obj[42].ToString(); }
private String model1() // when user fill rahn_low rahn_high ejare_low ejare_high { String sql = "EXEC SearchManzelSSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + zirbanaa_Low.Text + "',N'" + zirbanaa_High.Text + "',N'" + tabaghaat_Low.Text + "',N'" + tabaghaat_High.Text + "',N'" + vahed_Low.Text + "',N'" + vahed_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_High.Text) + "'"; return(sql); }
private void insertIt() { TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String sql = "EXEC InsertBaghVillaF '" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + textBox19.Text + "',N'" + textBox20.Text + "',N'" + textBox21.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox22.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox23.Text) + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + "," + checkBox15.IsChecked + "," + checkBox16.IsChecked + "," + checkBox17.IsChecked + "," + checkBox18.IsChecked + "," + checkBox19.IsChecked + "," + checkBox20.IsChecked + "," + checkBox21.IsChecked + "," + checkBox22.IsChecked + "," + checkBox23.IsChecked + "," + checkBox24.IsChecked + "," + checkBox25.IsChecked + "," + checkBox26.IsChecked + "," + checkBox27.IsChecked + "," + checkBox28.IsChecked + "," + checkBox29.IsChecked + "," + checkBox30.IsChecked + ",N'" + _RText.Text + "',N'" + textBox24.Text + "'"; DB.execSql(sql, 0); MessageBox.Show("رکورد جدید با موفقیت ثبت گردید", "ثبت", MessageBoxButton.OK, MessageBoxImage.Information); if (AgainCheckBox.IsChecked == false) { Insert.BaghVillaF w = new Insert.BaghVillaF(); this.Close(); if (w.newId != null && w.newId.Length > 0) { w.Show(); } } else { initLabels(); } } catch (Exception) { MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Window_KeyUp(object sender, KeyEventArgs e) { if (!changeMode) { if (e.Key == Key.Right || e.Key == Key.Up) { next_button_Click(null, null); } else if (e.Key == Key.Left || e.Key == Key.Down) { before_button_Click(null, null); } else if (e.Key == Key.Escape) { Close(); } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } changeCombo.Visibility = Visibility.Visible; changeCombo.Focus(); changeMode = true; } } else // now we are in changeMode { if (e.Key == Key.Escape) { goOutFromChangeMode(); if (editing) { makeNonEditableAll(); editButton.Visibility = Visibility.Hidden; editing = false; price.Stop(); } } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } if (editing) { editButton_Click(null, null); return; } if (changeCombo.SelectedIndex == 2) // cancel { goOutFromChangeMode(); } else if (changeCombo.SelectedIndex == 1) // remove { try { String str = (String)ID_Lbl.Content; String mode = ""; int ind = 0; while (str[ind] != '-') { mode += str[ind++]; } mode.TrimEnd(); String sql = "EXEC RemoveByID " + str.Substring(ind + 1).TrimStart() + "," + mode; DB.execSql(sql); TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); String sqlForArchive = "EXEC InsertApartmanMaskooniF '" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + textBox19.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox20.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox21.Text) + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + "," + checkBox15.IsChecked + "," + checkBox16.IsChecked + "," + checkBox17.IsChecked + "," + checkBox18.IsChecked + "," + checkBox19.IsChecked + "," + checkBox20.IsChecked + "," + checkBox21.IsChecked + "," + checkBox22.IsChecked + "," + checkBox23.IsChecked + "," + checkBox24.IsChecked + "," + checkBox25.IsChecked + "," + checkBox26.IsChecked + "," + checkBox27.IsChecked + ",N'" + _RText.Text + "',N'" + textBox22.Text + "'"; DB.execSqlInArchive(sqlForArchive); dt.Rows.RemoveAt(index); msgShow = true; MessageBox.Show("ملک مورد نظر با موفقیت حذف گردید", "حذف", MessageBoxButton.OK, MessageBoxImage.Information); goOutFromChangeMode(); tw.Close(); removeLbl.Content = "این ملک حذف گردیده است و برای آخرین بار در این فرم آن را ملاحظه می فرمایید"; removeLbl.Visibility = Visibility.Visible; } catch (Exception) { msgShow = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } } else // edit { textBox1.Focus(); changeCombo.Visibility = Visibility.Hidden; editButton.Visibility = Visibility.Visible; editing = true; makeEditableAll(); price.Start(); } } if (editing) { if (e.Key == Key.Up) { if (textBox2.IsFocused || textBox3.IsFocused || textBox4.IsFocused || textBox5.IsFocused || textBox6.IsFocused || textBox7.IsFocused) { textBox1.Focus(); } else if (textBox8.IsFocused) { textBox2.Focus(); } else if (textBox9.IsFocused) { textBox8.Focus(); } else if (textBox10.IsFocused) { textBox9.Focus(); } else if (textBox11.IsFocused) { textBox5.Focus(); } else if (textBox12.IsFocused) { textBox10.Focus(); } else if (textBox13.IsFocused) { textBox12.Focus(); } else if (textBox14.IsFocused) { textBox11.Focus(); } else if (textBox15.IsFocused) { textBox14.Focus(); } else if (textBox16.IsFocused) { textBox13.Focus(); } else if (textBox17.IsFocused) { textBox16.Focus(); } else if (textBox18.IsFocused) { textBox17.Focus(); } else if (textBox20.IsFocused) { textBox18.Focus(); } else if (textBox21.IsFocused) { textBox19.Focus(); } else if (richTextBox1.IsFocused) { textBox20.Focus(); } else if (textBox22.IsFocused) { checkBox15.Focus(); } } else if (e.Key == Key.Down) { if (textBox1.IsFocused) { textBox2.Focus(); } else if (textBox2.IsFocused || textBox3.IsFocused) { textBox8.Focus(); } else if (textBox4.IsFocused || textBox5.IsFocused) { textBox11.Focus(); } else if (textBox6.IsFocused) { checkBox1.Focus(); } else if (textBox7.IsFocused) { checkBox9.Focus(); } else if (textBox8.IsFocused) { textBox9.Focus(); } else if (textBox9.IsFocused) { textBox10.Focus(); } else if (textBox10.IsFocused) { textBox12.Focus(); } else if (textBox12.IsFocused) { textBox13.Focus(); } else if (textBox13.IsFocused || textBox15.IsFocused) { textBox16.Focus(); } else if (textBox11.IsFocused) { textBox14.Focus(); } else if (textBox14.IsFocused) { textBox15.Focus(); } else if (textBox16.IsFocused) { textBox17.Focus(); } else if (textBox17.IsFocused) { textBox18.Focus(); } else if (textBox18.IsFocused) { textBox20.Focus(); } else if (textBox19.IsFocused) { textBox21.Focus(); } else if (textBox20.IsFocused || textBox21.IsFocused) { richTextBox1.Focus(); } } else if (e.Key == Key.Left) { if (textBox2.IsFocused) { textBox3.Focus(); } else if (textBox3.IsFocused) { textBox4.Focus(); } else if (textBox4.IsFocused) { textBox5.Focus(); } else if (textBox5.IsFocused) { textBox6.Focus(); } else if (textBox6.IsFocused) { textBox7.Focus(); } else if (textBox8.IsFocused) { textBox11.Focus(); } else if (textBox9.IsFocused || textBox10.IsFocused) { textBox14.Focus(); } else if (textBox12.IsFocused || textBox13.IsFocused) { textBox15.Focus(); } else if (textBox18.IsFocused) { textBox19.Focus(); } else if (textBox20.IsFocused) { textBox21.Focus(); } else if (richTextBox1.IsFocused) { textBox22.Focus(); } else if (textBox11.IsFocused || textBox14.IsFocused || textBox15.IsFocused || textBox16.IsFocused || textBox17.IsFocused || textBox19.IsFocused || textBox21.IsFocused) { checkBox1.Focus(); } } else if (e.Key == Key.Right) { if (textBox3.IsFocused) { textBox2.Focus(); } else if (textBox4.IsFocused) { textBox3.Focus(); } else if (textBox5.IsFocused) { textBox4.Focus(); } else if (textBox6.IsFocused) { textBox5.Focus(); } else if (textBox7.IsFocused) { textBox6.Focus(); } else if (textBox11.IsFocused) { textBox8.Focus(); } else if (textBox14.IsFocused) { textBox9.Focus(); } else if (textBox15.IsFocused) { textBox12.Focus(); } else if (textBox19.IsFocused) { textBox18.Focus(); } else if (textBox21.IsFocused) { textBox20.Focus(); } } } } }
private void next_button_Click(object sender, RoutedEventArgs e) { if (index + 1 >= dt.Rows.Count) { return; } removeLbl.Visibility = Visibility.Hidden; Object[] obj = dt.Rows[++index].ItemArray; this.ID_Lbl.Content = Codes.ApartmanMaskooniForooshi.ToString() + " - " + obj[0].ToString(); this.date_Lbl.Content = obj[1].ToString(); this.textBox1.Text = obj[2].ToString(); this.textBox2.Text = obj[3].ToString(); this.textBox3.Text = obj[4].ToString(); this.textBox4.Text = obj[5].ToString(); this.textBox5.Text = obj[6].ToString(); this.textBox6.Text = obj[7].ToString(); this.textBox7.Text = obj[8].ToString(); this.textBox8.Text = obj[9].ToString(); this.textBox9.Text = obj[10].ToString(); this.textBox10.Text = obj[11].ToString(); this.textBox11.Text = obj[12].ToString(); this.textBox12.Text = obj[13].ToString(); this.textBox13.Text = obj[14].ToString(); this.textBox14.Text = obj[15].ToString(); this.textBox15.Text = obj[16].ToString(); this.textBox16.Text = obj[17].ToString(); this.textBox17.Text = obj[18].ToString(); this.textBox18.Text = obj[19].ToString(); this.textBox19.Text = obj[20].ToString(); this.textBox20.Text = MyPriceTextBox.doMaskOnce(obj[21].ToString()); this.textBox21.Text = MyPriceTextBox.doMaskOnce(obj[22].ToString()); this.checkBox1.IsChecked = (bool)obj[23]; this.checkBox2.IsChecked = (bool)obj[24]; this.checkBox3.IsChecked = (bool)obj[25]; this.checkBox4.IsChecked = (bool)obj[26]; this.checkBox5.IsChecked = (bool)obj[27]; this.checkBox6.IsChecked = (bool)obj[28]; this.checkBox7.IsChecked = (bool)obj[29]; this.checkBox8.IsChecked = (bool)obj[30]; this.checkBox9.IsChecked = (bool)obj[31]; this.checkBox10.IsChecked = (bool)obj[32]; this.checkBox11.IsChecked = (bool)obj[33]; this.checkBox12.IsChecked = (bool)obj[34]; this.checkBox13.IsChecked = (bool)obj[35]; this.checkBox14.IsChecked = (bool)obj[36]; this.checkBox15.IsChecked = (bool)obj[37]; this.checkBox16.IsChecked = (bool)obj[38]; this.checkBox17.IsChecked = (bool)obj[39]; this.checkBox18.IsChecked = (bool)obj[40]; this.checkBox19.IsChecked = (bool)obj[41]; this.checkBox20.IsChecked = (bool)obj[42]; this.checkBox21.IsChecked = (bool)obj[43]; this.checkBox22.IsChecked = (bool)obj[44]; this.checkBox23.IsChecked = (bool)obj[45]; this.checkBox24.IsChecked = (bool)obj[46]; this.checkBox25.IsChecked = (bool)obj[47]; this.checkBox26.IsChecked = (bool)obj[48]; this.checkBox27.IsChecked = (bool)obj[49]; TextRange _RText = new TextRange(this.richTextBox1.Document.ContentStart, this.richTextBox1.Document.ContentEnd); _RText.Text = obj[50].ToString(); this.textBox22.Text = obj[51].ToString(); }
private void search_button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; errorOccurred = false; TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String tr = _RText.Text.TrimEnd(); tr = tr.TrimStart(); if (tr == "\r\n") { tr = ""; } String date = (MaskedDate.Text[0] == '_') ? "" : MaskedDate.Text; String[] s = { "'" + ID_Txt.Text + "'", "N'" + date + "'", "N'" + textBox1.Text + "'", "N'" + textBox2.Text + "'", "N'" + textBox3.Text + "'", "N'" + textBox4.Text + "'", "N'" + textBox5.Text + "'", "N'" + textBox6.Text + "'", "N'" + textBox7.Text + "'", "N'" + textBox8.Text + "'", "N'" + textBox9.Text + "'", "N'" + textBox10.Text + "'", "N'" + textBox11.Text + "'", "N'" + textBox12.Text + "'", "N'" + textBox13.Text + "'", "N'" + textBox14.Text + "'", "N'" + textBox15.Text + "'", "N'" + textBox16.Text + "'", "N'" + textBox17.Text + "'", "N'" + textBox18.Text + "'", "N'" + MyPriceTextBox.getStringFromMasked(textBox19.Text) + "'", "N'" + MyPriceTextBox.getStringFromMasked(textBox20.Text) + "'", "N'" + textBox21.Text + "'", checkBox1.IsChecked.ToString(), checkBox2.IsChecked.ToString(), checkBox3.IsChecked.ToString() , checkBox4.IsChecked.ToString(), checkBox5.IsChecked.ToString(), checkBox6.IsChecked.ToString() , checkBox7.IsChecked.ToString(), checkBox8.IsChecked.ToString(), checkBox9.IsChecked.ToString() , checkBox10.IsChecked.ToString(), checkBox11.IsChecked.ToString(), checkBox12.IsChecked.ToString() , checkBox13.IsChecked.ToString(), checkBox14.IsChecked.ToString(), checkBox15.IsChecked.ToString() , checkBox16.IsChecked.ToString(), checkBox17.IsChecked.ToString(), checkBox18.IsChecked.ToString() , checkBox19.IsChecked.ToString(), checkBox20.IsChecked.ToString(), checkBox21.IsChecked.ToString() , checkBox22.IsChecked.ToString(), checkBox23.IsChecked.ToString(), checkBox24.IsChecked.ToString() , checkBox25.IsChecked.ToString(), checkBox26.IsChecked.ToString(), checkBox27.IsChecked.ToString() , "N'" + _RText.Text + "'", "N'" + textBox22.Text + "'" }; SearchSQL sq = new SearchSQL(s, "SearchApartmanMaskooniS"); DataTable dt = sq.getResult(DBComboBox.SelectedIndex); if (Show3D_checkBox.IsChecked == true) { Result3D res3d = new Result3D(); res3d.dt = dt; res3d.Show(); } else { ResultWindow res = new ResultWindow(); res.session = session; res.which = Codes.ApartmanMaskooniEstijari; if (dt != null) { res.dt = dt.Copy(); if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } if (MaskedDate.Text == "____/__/__") { dt.Columns.Remove(cols[1]); } if (textBox2.Text.Trim().Length == 0) { dt.Columns.Remove(cols[3]); } if (textBox3.Text.Trim().Length == 0) { dt.Columns.Remove(cols[4]); } if (textBox4.Text.Trim().Length == 0) { dt.Columns.Remove(cols[5]); } if (textBox5.Text.Trim().Length == 0) { dt.Columns.Remove(cols[6]); } if (textBox6.Text.Trim().Length == 0) { dt.Columns.Remove(cols[7]); } if (textBox7.Text.Trim().Length == 0) { dt.Columns.Remove(cols[8]); } if (textBox8.Text.Trim().Length == 0) { dt.Columns.Remove(cols[9]); } if (textBox9.Text.Trim().Length == 0) { dt.Columns.Remove(cols[10]); } if (textBox10.Text.Trim().Length == 0) { dt.Columns.Remove(cols[11]); } if (textBox11.Text.Trim().Length == 0) { dt.Columns.Remove(cols[12]); } if (textBox12.Text.Trim().Length == 0) { dt.Columns.Remove(cols[13]); } if (textBox13.Text.Trim().Length == 0) { dt.Columns.Remove(cols[14]); } if (textBox14.Text.Trim().Length == 0) { dt.Columns.Remove(cols[15]); } if (textBox15.Text.Trim().Length == 0) { dt.Columns.Remove(cols[16]); } if (textBox16.Text.Trim().Length == 0) { dt.Columns.Remove(cols[17]); } if (textBox17.Text.Trim().Length == 0) { dt.Columns.Remove(cols[18]); } if (textBox18.Text.Trim().Length == 0) { dt.Columns.Remove(cols[19]); } if (textBox21.Text.Trim().Length == 0) { dt.Columns.Remove(cols[22]); } if (checkBox1.IsChecked == false) { dt.Columns.Remove(cols[23]); } if (checkBox2.IsChecked == false) { dt.Columns.Remove(cols[24]); } if (checkBox3.IsChecked == false) { dt.Columns.Remove(cols[25]); } if (checkBox4.IsChecked == false) { dt.Columns.Remove(cols[26]); } if (checkBox5.IsChecked == false) { dt.Columns.Remove(cols[27]); } if (checkBox6.IsChecked == false) { dt.Columns.Remove(cols[28]); } if (checkBox7.IsChecked == false) { dt.Columns.Remove(cols[29]); } if (checkBox8.IsChecked == false) { dt.Columns.Remove(cols[30]); } if (checkBox9.IsChecked == false) { dt.Columns.Remove(cols[31]); } if (checkBox10.IsChecked == false) { dt.Columns.Remove(cols[32]); } if (checkBox11.IsChecked == false) { dt.Columns.Remove(cols[33]); } if (checkBox12.IsChecked == false) { dt.Columns.Remove(cols[34]); } if (checkBox13.IsChecked == false) { dt.Columns.Remove(cols[35]); } if (checkBox14.IsChecked == false) { dt.Columns.Remove(cols[36]); } if (checkBox15.IsChecked == false) { dt.Columns.Remove(cols[37]); } if (checkBox16.IsChecked == false) { dt.Columns.Remove(cols[38]); } if (checkBox17.IsChecked == false) { dt.Columns.Remove(cols[39]); } if (checkBox18.IsChecked == false) { dt.Columns.Remove(cols[40]); } if (checkBox19.IsChecked == false) { dt.Columns.Remove(cols[41]); } if (checkBox20.IsChecked == false) { dt.Columns.Remove(cols[42]); } if (checkBox21.IsChecked == false) { dt.Columns.Remove(cols[43]); } if (checkBox22.IsChecked == false) { dt.Columns.Remove(cols[44]); } if (checkBox23.IsChecked == false) { dt.Columns.Remove(cols[45]); } if (checkBox24.IsChecked == false) { dt.Columns.Remove(cols[46]); } if (checkBox25.IsChecked == false) { dt.Columns.Remove(cols[47]); } if (checkBox26.IsChecked == false) { dt.Columns.Remove(cols[48]); } if (checkBox27.IsChecked == false) { dt.Columns.Remove(cols[49]); } if (_RText.Text == "\r\n") { dt.Columns.Remove(cols[50]); } if (textBox22.Text.Length == 0) { dt.Columns.Remove(cols[51]); } } res.gridView.DataSource = dt; res.dbIndex = DBComboBox.SelectedIndex; res.Show(); } } catch (Exception) { errorOccurred = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
void price_Tick(object sender, EventArgs e) { MyPriceTextBox.doMask(rahn, textBox19); MyPriceTextBox.doMask(ejare, textBox20); }
void price_Tick(object sender, EventArgs e) { MyPriceTextBox.doMask(pricel, price_Low); MyPriceTextBox.doMask(priceh, price_High); }
private void Window_KeyUp(object sender, KeyEventArgs e) { if (!changeMode) { if (e.Key == Key.Right || e.Key == Key.Up) { next_button_Click(null, null); } else if (e.Key == Key.Left || e.Key == Key.Down) { before_button_Click(null, null); } else if (e.Key == Key.Escape) { Close(); } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } changeCombo.Visibility = Visibility.Visible; changeCombo.Focus(); changeMode = true; } } else // now we are in changeMode { if (e.Key == Key.Escape) { goOutFromChangeMode(); if (editing) { makeNonEditableAll(); editButton.Visibility = Visibility.Hidden; editing = false; price.Stop(); } } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } if (editing) { editButton_Click(null, null); return; } if (changeCombo.SelectedIndex == 2) // cancel { goOutFromChangeMode(); } else if (changeCombo.SelectedIndex == 1) // remove { if (dbIndex != 0) { msgShow = true; MessageBox.Show("اطلاعات آرشیو به منظور حفظ رکوردها حذف نمی گردند.", "خطای حذف داده های آرشیو", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (!session.allowDelete) { goOutFromChangeMode(); MessageBox.Show("شما اجازه دسترسی به این قسمت را ندارید", "عدم اجازه دسترسی", MessageBoxButton.OK, MessageBoxImage.Warning); return; } try { String str = (String)ID_Lbl.Content; String mode = ""; int ind = 0; while (str[ind] != '-') { mode += str[ind++]; } mode.TrimEnd(); String sql = "EXEC RemoveByID " + str.Substring(ind + 1).TrimStart() + "," + mode; DB.execSql(sql, 0); TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); String sqlForArchive = "EXEC InsertApartmanEdariS '" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + textBox19.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox20.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox21.Text) + "',N'" + textBox22.Text + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + "," + checkBox15.IsChecked + ",N'" + _RText.Text + "',N'" + textBox23.Text + "'"; DB.execSqlInArchive(sqlForArchive); dt.Rows.RemoveAt(index); msgShow = true; MessageBox.Show("ملک مورد نظر با موفقیت حذف گردید", "حذف", MessageBoxButton.OK, MessageBoxImage.Information); goOutFromChangeMode(); tw.Close(); removeLbl.Content = "این ملک حذف گردیده است و برای آخرین بار در این فرم آن را ملاحظه می فرمایید"; removeLbl.Visibility = Visibility.Visible; } catch (Exception) { msgShow = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } } else // edit { if (!session.allowEdit) { goOutFromChangeMode(); MessageBox.Show("شما اجازه دسترسی به این قسمت را ندارید", "عدم اجازه دسترسی", MessageBoxButton.OK, MessageBoxImage.Warning); return; } textBox1.Focus(); changeCombo.Visibility = Visibility.Hidden; editButton.Visibility = Visibility.Visible; editing = true; makeEditableAll(); price.Start(); } } if (editing) { if (e.Key == Key.Up) { if (textBox2.IsFocused || textBox3.IsFocused || textBox4.IsFocused || textBox5.IsFocused || textBox6.IsFocused || textBox7.IsFocused) { textBox1.Focus(); } else if (textBox8.IsFocused) { textBox2.Focus(); } else if (textBox9.IsFocused) { textBox8.Focus(); } else if (textBox10.IsFocused) { textBox9.Focus(); } else if (textBox11.IsFocused) { textBox5.Focus(); } else if (textBox12.IsFocused) { textBox10.Focus(); } else if (textBox13.IsFocused) { textBox11.Focus(); } else if (textBox14.IsFocused) { textBox13.Focus(); } else if (textBox15.IsFocused) { textBox14.Focus(); } else if (textBox16.IsFocused) { textBox15.Focus(); } else if (textBox17.IsFocused) { textBox16.Focus(); } else if (textBox18.IsFocused || textBox19.IsFocused) { textBox17.Focus(); } else if (textBox20.IsFocused) { textBox18.Focus(); } else if (textBox21.IsFocused) { textBox19.Focus(); } else if (textBox22.IsFocused) { textBox20.Focus(); } else if (richTextBox1.IsFocused) { textBox22.Focus(); } else if (textBox23.IsFocused) { checkBox15.Focus(); } } else if (e.Key == Key.Down) { if (textBox1.IsFocused) { textBox2.Focus(); } else if (textBox2.IsFocused || textBox3.IsFocused) { textBox8.Focus(); } else if (textBox4.IsFocused || textBox5.IsFocused) { textBox11.Focus(); } else if (textBox6.IsFocused) { checkBox1.Focus(); } else if (textBox7.IsFocused) { checkBox9.Focus(); } else if (textBox8.IsFocused) { textBox9.Focus(); } else if (textBox9.IsFocused) { textBox10.Focus(); } else if (textBox10.IsFocused) { textBox12.Focus(); } else if (textBox12.IsFocused || textBox15.IsFocused) { textBox16.Focus(); } else if (textBox11.IsFocused) { textBox13.Focus(); } else if (textBox13.IsFocused) { textBox14.Focus(); } else if (textBox14.IsFocused) { textBox15.Focus(); } else if (textBox16.IsFocused) { textBox17.Focus(); } else if (textBox17.IsFocused) { textBox18.Focus(); } else if (textBox18.IsFocused) { textBox20.Focus(); } else if (textBox19.IsFocused) { textBox21.Focus(); } else if (textBox20.IsFocused || textBox21.IsFocused) { textBox22.Focus(); } else if (textBox22.IsFocused || textBox23.IsFocused) { richTextBox1.Focus(); } } else if (e.Key == Key.Left) { if (textBox2.IsFocused) { textBox3.Focus(); } else if (textBox3.IsFocused) { textBox4.Focus(); } else if (textBox4.IsFocused) { textBox5.Focus(); } else if (textBox5.IsFocused) { textBox6.Focus(); } else if (textBox6.IsFocused) { textBox7.Focus(); } else if (textBox8.IsFocused) { textBox11.Focus(); } else if (textBox9.IsFocused) { textBox13.Focus(); } else if (textBox10.IsFocused) { textBox14.Focus(); } else if (textBox12.IsFocused) { textBox15.Focus(); } else if (textBox18.IsFocused) { textBox19.Focus(); } //else if (textBox20.IsFocused) textBox21.Focus(); else if (textBox22.IsFocused) { textBox23.Focus(); } else if (richTextBox1.IsFocused) { textBox23.Focus(); } else if (textBox11.IsFocused || textBox13.IsFocused || textBox14.IsFocused || textBox15.IsFocused || textBox16.IsFocused || textBox17.IsFocused || textBox19.IsFocused || textBox21.IsFocused) { checkBox1.Focus(); } } else if (e.Key == Key.Right) { if (textBox3.IsFocused) { textBox2.Focus(); } else if (textBox4.IsFocused) { textBox3.Focus(); } else if (textBox5.IsFocused) { textBox4.Focus(); } else if (textBox6.IsFocused) { textBox5.Focus(); } else if (textBox7.IsFocused) { textBox6.Focus(); } else if (textBox11.IsFocused) { textBox8.Focus(); } else if (textBox13.IsFocused) { textBox9.Focus(); } else if (textBox14.IsFocused) { textBox10.Focus(); } else if (textBox15.IsFocused) { textBox12.Focus(); } else if (textBox19.IsFocused) { textBox18.Focus(); } //else if (textBox21.IsFocused) textBox20.Focus(); else if (textBox23.IsFocused) { textBox22.Focus(); } } else if (e.Key == Key.Escape) { TextRange _text = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); if (_text.Text.Trim() == "" && textBox1.Text.Trim() == "" && textBox2.Text.Trim() == "" && textBox3.Text.Trim() == "" && textBox4.Text.Trim() == "" && textBox5.Text.Trim() == "" && textBox6.Text.Trim() == "" && textBox7.Text.Trim() == "" && textBox8.Text.Trim() == "" && textBox9.Text.Trim() == "" && textBox10.Text.Trim() == "" && textBox11.Text.Trim() == "" && textBox12.Text.Trim() == "" && textBox13.Text.Trim() == "" && textBox14.Text.Trim() == "" && textBox15.Text.Trim() == "" && textBox16.Text.Trim() == "" && textBox17.Text.Trim() == "" && textBox18.Text.Trim() == "" && textBox19.Text.Trim() == "" && textBox20.Text.Trim() == "" && textBox21.Text.Trim() == "" && textBox22.Text.Trim() == "" && textBox23.Text.Trim() == "") { Close(); return; } MessageBoxResult res = MessageBox.Show("آیا می خواهید صفحه ی ثبت را ببندید ؟", "ثبت", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { Close(); } } } } }
private void search_button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; try { String sql = "EXEC SearchApartmanMaskooniFSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + bedrooms_Low.Text + "',N'" + bedrooms_High.Text + "',N'" + vahedha_Low.Text + "',N'" + vahedha_High.Text + "',N'" + sakht_Low.Text + "',N'" + sakht_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(price_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(price_High.Text) + "'"; DataTable dt = DB.execSqlReturnDataTable(sql); if (Show3D_checkBox.IsChecked == true) { Result3D res3d = new Result3D(); res3d.dt = dt; res3d.Show(); } else { ResultWindow res = new ResultWindow(); res.dt = dt.Copy(); res.which = Codes.ApartmanMaskooniForooshi; if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } for (int i = 1; i < cols.Length; i++) { if (i == 2 || i == 21) { continue; } if ((metraj_Low.Text.Trim().Length != 0 || metraj_High.Text.Trim().Length != 0) && i == 3) { continue; } if ((bedrooms_Low.Text.Trim().Length != 0 || bedrooms_High.Text.Trim().Length != 0) && i == 5) { continue; } if ((vahedha_Low.Text.Trim().Length != 0 || vahedha_High.Text.Trim().Length != 0) && i == 10) { continue; } if ((sakht_Low.Text.Trim().Length != 0 || sakht_High.Text.Trim().Length != 0) && i == 8) { continue; } if (owner.Text.Trim().Length != 0 && i == 19) { continue; } if ((price_Low.Text.Trim().Length != 0 || price_High.Text.Trim().Length != 0) && i == 22) { continue; } dt.Columns.Remove(cols[i]); } res.gridView.DataSource = dt; res.Show(); } } catch (Exception) { MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Window_KeyUp(object sender, KeyEventArgs e) { if (!changeMode) { if (e.Key == Key.Right || e.Key == Key.Up) { next_button_Click(null, null); } else if (e.Key == Key.Left || e.Key == Key.Down) { before_button_Click(null, null); } else if (e.Key == Key.Escape) { Close(); } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } changeCombo.Visibility = Visibility.Visible; changeCombo.Focus(); changeMode = true; } } else // now we are in changeMode { if (e.Key == Key.Escape) { goOutFromChangeMode(); if (editing) { makeNonEditableAll(); editButton.Visibility = Visibility.Hidden; editing = false; price.Stop(); } } else if (e.Key == Key.Enter) { if (msgShow) { msgShow = false; return; } if (editing) { editButton_Click(null, null); return; } if (changeCombo.SelectedIndex == 2) // cancel { goOutFromChangeMode(); } else if (changeCombo.SelectedIndex == 1) // remove { if (dbIndex != 0) { msgShow = true; MessageBox.Show("اطلاعات آرشیو به منظور حفظ رکوردها حذف نمی گردند.", "خطای حذف داده های آرشیو", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (!session.allowDelete) { goOutFromChangeMode(); MessageBox.Show("شما اجازه دسترسی به این قسمت را ندارید", "عدم اجازه دسترسی", MessageBoxButton.OK, MessageBoxImage.Warning); return; } try { String str = (String)ID_Lbl.Content; String mode = ""; int ind = 0; while (str[ind] != '-') { mode += str[ind++]; } mode.TrimEnd(); String sql = "EXEC RemoveByID " + str.Substring(ind + 1).TrimStart() + "," + mode; DB.execSql(sql, 0); TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); String sqlForArchive = "EXEC InsertManzelS '" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox16.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox17.Text) + "',N'" + textBox18.Text + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + ",N'" + _RText.Text + "',N'" + txt_Moarefino.Text + "'"; String sid = DB.execSqlReturnScalarInArchive(sqlForArchive).ToString(); DataTable dt2 = (DataTable)gridView.DataSource; for (int i = 0; i < dt2.Rows.Count; i++) { String sq = "EXEC InsertMajmooeS " + sid; /*for (int j = 0; j < dt2.Rows[i].ItemArray.Length; j++) * { * sq += ","+dt2.Rows[i].ItemArray[j].ToString(); * }*/ sq += ",N'" + dt2.Rows[i].ItemArray[0].ToString() + "'"; sq += ",N'" + dt2.Rows[i].ItemArray[1].ToString() + "'"; sq += "," + dt2.Rows[i].ItemArray[2].ToString(); sq += "," + dt2.Rows[i].ItemArray[3].ToString(); sq += ",N'" + dt2.Rows[i].ItemArray[4].ToString() + "'"; sq += ",N'" + dt2.Rows[i].ItemArray[5].ToString() + "'"; DB.execSqlInArchive(sq); } dt.Rows.RemoveAt(index); msgShow = true; MessageBox.Show("ملک مورد نظر با موفقیت حذف گردید", "حذف", MessageBoxButton.OK, MessageBoxImage.Information); goOutFromChangeMode(); tw.Close(); removeLbl.Content = "این ملک حذف گردیده است و برای آخرین بار در این فرم آن را ملاحظه می فرمایید"; removeLbl.Visibility = Visibility.Visible; } catch (Exception) { msgShow = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } } else // edit { if (!session.allowEdit) { goOutFromChangeMode(); MessageBox.Show("شما اجازه دسترسی به این قسمت را ندارید", "عدم اجازه دسترسی", MessageBoxButton.OK, MessageBoxImage.Warning); return; } textBox1.Focus(); changeCombo.Visibility = Visibility.Hidden; editButton.Visibility = Visibility.Visible; editing = true; makeEditableAll(); price.Start(); } } if (editing) { if (e.Key == Key.Up) { if (textBox2.IsFocused || textBox3.IsFocused || textBox4.IsFocused || textBox5.IsFocused || textBox6.IsFocused) { textBox1.Focus(); } else if (textBox8.IsFocused) { textBox2.Focus(); } else if (textBox9.IsFocused) { textBox3.Focus(); } else if (textBox10.IsFocused) { textBox4.Focus(); } else if (textBox11.IsFocused) { textBox5.Focus(); } else if (textBox7.IsFocused) { textBox6.Focus(); } else if (textBox12.IsFocused) { textBox10.Focus(); } else if (textBox13.IsFocused) { textBox8.Focus(); } else if (textBox14.IsFocused || textBox15.IsFocused) { textBox18.Focus(); } else if (textBox18.IsFocused) { gridView.Focus(); } else if (textBox16.IsFocused) { textBox14.Focus(); } else if (textBox17.IsFocused) { textBox15.Focus(); } else if (richTextBox1.IsFocused) { textBox16.Focus(); } else if (txt_Moarefino.IsFocused) { checkBox14.Focus(); } } else if (e.Key == Key.Down) { if (textBox1.IsFocused) { textBox2.Focus(); } else if (textBox2.IsFocused) { textBox8.Focus(); } else if (textBox3.IsFocused) { textBox9.Focus(); } else if (textBox4.IsFocused) { textBox10.Focus(); } else if (textBox5.IsFocused) { textBox11.Focus(); } else if (textBox6.IsFocused) { textBox7.Focus(); } else if (textBox7.IsFocused || textBox11.IsFocused || textBox10.IsFocused) { textBox12.Focus(); } else if (textBox8.IsFocused || textBox9.IsFocused) { textBox13.Focus(); } else if (textBox12.IsFocused || textBox13.IsFocused) { gridView.Focus(); } else if (textBox14.IsFocused) { textBox16.Focus(); } else if (textBox15.IsFocused) { textBox17.Focus(); } else if (textBox18.IsFocused) { textBox14.Focus(); } else if (textBox16.IsFocused || textBox17.IsFocused) { richTextBox1.Focus(); } } else if (e.Key == Key.Left) { if (textBox2.IsFocused) { textBox3.Focus(); } else if (textBox3.IsFocused) { textBox4.Focus(); } else if (textBox4.IsFocused) { textBox5.Focus(); } else if (textBox5.IsFocused) { textBox6.Focus(); } else if (textBox8.IsFocused) { textBox9.Focus(); } else if (textBox9.IsFocused) { textBox10.Focus(); } else if (textBox10.IsFocused) { textBox11.Focus(); } else if (textBox11.IsFocused) { textBox7.Focus(); } else if (textBox13.IsFocused) { textBox12.Focus(); } else if (textBox14.IsFocused && !gridView.Focused) { textBox15.Focus(); } //else if (textBox16.IsFocused) textBox17.Focus(); else if (richTextBox1.IsFocused) { txt_Moarefino.Focus(); } else if (textBox15.IsFocused || textBox18.IsFocused) { checkBox1.Focus(); } } else if (e.Key == Key.Right) { if (textBox3.IsFocused) { textBox2.Focus(); } else if (textBox4.IsFocused) { textBox3.Focus(); } else if (textBox5.IsFocused) { textBox4.Focus(); } else if (textBox6.IsFocused) { textBox5.Focus(); } else if (textBox9.IsFocused) { textBox8.Focus(); } else if (textBox10.IsFocused) { textBox9.Focus(); } else if (textBox11.IsFocused) { textBox10.Focus(); } else if (textBox7.IsFocused) { textBox11.Focus(); } else if (textBox12.IsFocused) { textBox13.Focus(); } else if (textBox15.IsFocused && !gridView.Focused) { textBox14.Focus(); } //else if (textBox17.IsFocused) textBox16.Focus(); else if (txt_Moarefino.IsFocused) { richTextBox1.Focus(); } } else if (e.Key == Key.RightCtrl || e.Key == Key.LeftCtrl) { textBox18.Focus(); } } } }
private void search_button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; errorOccurred = false; try { String sql; if (rahn_High.Text.Trim().Length == 0 && rahn_Low.Text.Trim().Length == 0 && ejare_High.Text.Trim().Length == 0 && ejare_Low.Text.Trim().Length == 0) { if (rahnoejare_Low.Text.Trim().Length == 0 && rahnoejare_High.Text.Trim().Length == 0) { sql = model1(); } else { String low = MyPriceTextBox.getStringFromMasked(rahnoejare_Low.Text); String high = MyPriceTextBox.getStringFromMasked(rahnoejare_High.Text); if (low.Trim().Length == 0 || high.Trim().Length == 0) { MessageBox.Show("لطفا در این حالت که می خواهید از فیلد رهن و اجاره استفاده بنمایید هر دو طرف آن را پر بفرمایید", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); return; } sql = model2(low, high); } } else { sql = model1(); } DataTable dt = DB.execSqlReturnDataTable(sql); if (Show3D_checkBox.IsChecked == true) { Result3D res3d = new Result3D(); res3d.dt = dt; res3d.Show(); } else { ResultWindow res = new ResultWindow(); res.which = Codes.HouseEstijari; res.dt = dt.Copy(); if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } for (int i = 1; i < cols.Length; i++) { if (i == 2 || i == 17 || i == 18) { continue; } if ((metraj_Low.Text.Trim().Length != 0 || metraj_High.Text.Trim().Length != 0) && i == 7) { continue; } if ((zirbanaa_Low.Text.Trim().Length != 0 || zirbanaa_High.Text.Trim().Length != 0) && i == 6) { continue; } if ((tabaghaat_Low.Text.Trim().Length != 0 || tabaghaat_High.Text.Trim().Length != 0) && i == 9) { continue; } if ((vahed_Low.Text.Trim().Length != 0 || vahed_High.Text.Trim().Length != 0) && i == 10) { continue; } if (owner.Text.Trim().Length != 0 && i == 15) { continue; } dt.Columns.Remove(cols[i]); } res.gridView.DataSource = dt; res.Show(); } } catch (Exception) { errorOccurred = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
void price_Tick(object sender, EventArgs e) { MyPriceTextBox.doMask(pricemeter, textBox20); MyPriceTextBox.doMask(pricetotal, textBox21); }
private void search_button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; errorOccurred = false; TextRange _text = new TextRange(comments.Document.ContentStart, comments.Document.ContentEnd); String cmt = _text.Text; cmt = cmt.Remove(cmt.Length - 2); try { String sql = "EXEC SearchApartmanEdariFSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" + metraj_High.Text + "',N'" + bedrooms_Low.Text + "',N'" + bedrooms_High.Text + "',N'" + owner.Text + "',N'" + sanad.Text + "',N'" + MyPriceTextBox.getStringFromMasked(price_Low.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(price_High.Text) + "',N'" + cmt + "'"; if (Show3D_checkBox.IsChecked == true) // 3d result { Result3D res = new Result3D(); DataTable dt = DB.execSqlReturnDataTable(sql, DBComboBox.SelectedIndex); res.dt = dt; res.Show(); } else // usual result { ResultWindow res = new ResultWindow(); res.session = session; DataTable dt = DB.execSqlReturnDataTable(sql, DBComboBox.SelectedIndex); res.dt = dt.Copy(); res.which = Codes.ApartmanEdariForooshi; res.Show(); if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } for (int i = 1; i < cols.Length; i++) { if (i == 2 || i == 24) { continue; } if ((metraj_Low.Text.Trim().Length != 0 || metraj_High.Text.Trim().Length != 0) && i == 3) { continue; } if ((bedrooms_Low.Text.Trim().Length != 0 || bedrooms_High.Text.Trim().Length != 0) && i == 5) { continue; } if (owner.Text.Trim().Length != 0 && i == 21) { continue; } if (sanad.Text.Trim().Length != 0 && i == 17) { continue; } dt.Columns.Remove(cols[i]); } res.gridView.DataSource = dt; res.dbIndex = DBComboBox.SelectedIndex; res.Show(); } } catch (Exception) { errorOccurred = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void editButton_Click(object sender, RoutedEventArgs e) { makeNonEditableAll(); String id = ((String)ID_Lbl.Content); int ind = id.IndexOf('-'); id = id.Substring(ind + 1); TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String sql = "EXEC EditManzelS " + id + ",'" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox16.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox17.Text) + "',N'" + textBox18.Text + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + ",N'" + _RText.Text + "',N'" + txt_Moarefino.Text + "'"; DB.execSql(sql, dbIndex); String str = (String)ID_Lbl.Content; String mode = ""; ind = 0; while (str[ind] != '-') { mode += str[ind++]; } mode.TrimEnd(); String remsql = "EXEC RemoveMajmooeBySID " + id; DB.execSql(remsql, 0); DataTable dt2 = (DataTable)gridView.DataSource; for (int i = 0; i < dt2.Rows.Count; i++) { String sq = "EXEC InsertMajmooeS " + id; /*for (int j = 0; j < dt2.Rows[i].ItemArray.Length; j++) * { * sq += ","+dt2.Rows[i].ItemArray[j].ToString(); * }*/ sq += ",N'" + dt2.Rows[i].ItemArray[0].ToString() + "'"; sq += ",N'" + dt2.Rows[i].ItemArray[1].ToString() + "'"; sq += "," + dt2.Rows[i].ItemArray[2].ToString(); sq += "," + dt2.Rows[i].ItemArray[3].ToString(); sq += ",N'" + dt2.Rows[i].ItemArray[4].ToString() + "'"; sq += ",N'" + dt2.Rows[i].ItemArray[5].ToString() + "'"; DB.execSql(sq, 0); } msgShow = true; MessageBox.Show("رکورد با موفقیت ویرایش گردید", "ویرایش", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception) { msgShow = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); return; } tw.Close(); editButton.Visibility = Visibility.Hidden; goOutFromChangeMode(); DataRow dr = dt.NewRow(); dr.BeginEdit(); dr[0] = id; dr[1] = date_Lbl.Content; dr[2] = textBox1.Text; dr[3] = textBox2.Text; dr[4] = textBox3.Text; dr[5] = textBox4.Text; dr[6] = textBox5.Text; dr[7] = textBox6.Text; dr[8] = textBox7.Text; dr[9] = textBox8.Text; dr[10] = textBox9.Text; dr[11] = textBox10.Text; dr[12] = textBox11.Text; dr[13] = textBox12.Text; dr[14] = textBox13.Text; dr[15] = textBox14.Text; dr[16] = textBox15.Text; dr[17] = MyPriceTextBox.getStringFromMasked(textBox16.Text); dr[18] = MyPriceTextBox.getStringFromMasked(textBox17.Text); dr[19] = textBox18.Text; dr[20] = checkBox1.IsChecked; dr[21] = checkBox2.IsChecked; dr[22] = checkBox3.IsChecked; dr[23] = checkBox4.IsChecked; dr[24] = checkBox5.IsChecked; dr[25] = checkBox6.IsChecked; dr[26] = checkBox7.IsChecked; dr[27] = checkBox8.IsChecked; dr[28] = checkBox9.IsChecked; dr[29] = checkBox10.IsChecked; dr[30] = checkBox11.IsChecked; dr[31] = checkBox12.IsChecked; dr[32] = checkBox13.IsChecked; dr[33] = checkBox14.IsChecked; dr[34] = _RText.Text; dr[35] = txt_Moarefino.Text; dr.EndEdit(); dt.Rows.RemoveAt(index); dt.Rows.InsertAt(dr, index); editing = false; price.Stop(); }
private void editButton_Click(object sender, RoutedEventArgs e) { makeNonEditableAll(); String id = ((String)ID_Lbl.Content); int ind = id.IndexOf('-'); id = id.Substring(ind + 1); TextRange _RText = new TextRange(richTextBox1.Document.ContentStart, richTextBox1.Document.ContentEnd); try { String sql = "EXEC EditApartmanMaskooniF " + id + ",'" + date_Lbl.Content + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + textBox18.Text + "',N'" + textBox19.Text + "',N'" + MyPriceTextBox.getStringFromMasked(textBox20.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(textBox21.Text) + "'," + checkBox1.IsChecked + "," + checkBox2.IsChecked + "," + checkBox3.IsChecked + "," + checkBox4.IsChecked + "," + checkBox5.IsChecked + "," + checkBox6.IsChecked + "," + checkBox7.IsChecked + "," + checkBox8.IsChecked + "," + checkBox9.IsChecked + "," + checkBox10.IsChecked + "," + checkBox11.IsChecked + "," + checkBox12.IsChecked + "," + checkBox13.IsChecked + "," + checkBox14.IsChecked + "," + checkBox15.IsChecked + "," + checkBox16.IsChecked + "," + checkBox17.IsChecked + "," + checkBox18.IsChecked + "," + checkBox19.IsChecked + "," + checkBox20.IsChecked + "," + checkBox21.IsChecked + "," + checkBox22.IsChecked + "," + checkBox23.IsChecked + "," + checkBox24.IsChecked + "," + checkBox25.IsChecked + "," + checkBox26.IsChecked + "," + checkBox27.IsChecked + ",N'" + _RText.Text + "',N'" + textBox22.Text + "'"; DB.execSql(sql); msgShow = true; MessageBox.Show("رکورد با موفقیت ویرایش گردید", "ویرایش", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception) { msgShow = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); return; } tw.Close(); editButton.Visibility = Visibility.Hidden; goOutFromChangeMode(); DataRow dr = dt.NewRow(); dr.BeginEdit(); dr[0] = id; dr[1] = date_Lbl.Content; dr[2] = textBox1.Text; dr[3] = textBox2.Text; dr[4] = textBox3.Text; dr[5] = textBox4.Text; dr[6] = textBox5.Text; dr[7] = textBox6.Text; dr[8] = textBox7.Text; dr[9] = textBox8.Text; dr[10] = textBox9.Text; dr[11] = textBox10.Text; dr[12] = textBox11.Text; dr[13] = textBox12.Text; dr[14] = textBox13.Text; dr[15] = textBox14.Text; dr[16] = textBox15.Text; dr[17] = textBox16.Text; dr[18] = textBox17.Text; dr[19] = textBox18.Text; dr[20] = textBox19.Text; dr[21] = MyPriceTextBox.getStringFromMasked(textBox20.Text); dr[22] = MyPriceTextBox.getStringFromMasked(textBox21.Text); dr[23] = checkBox1.IsChecked; dr[24] = checkBox2.IsChecked; dr[25] = checkBox3.IsChecked; dr[26] = checkBox4.IsChecked; dr[27] = checkBox5.IsChecked; dr[28] = checkBox6.IsChecked; dr[29] = checkBox7.IsChecked; dr[30] = checkBox8.IsChecked; dr[31] = checkBox9.IsChecked; dr[32] = checkBox10.IsChecked; dr[33] = checkBox11.IsChecked; dr[34] = checkBox12.IsChecked; dr[35] = checkBox13.IsChecked; dr[36] = checkBox14.IsChecked; dr[37] = checkBox15.IsChecked; dr[38] = checkBox16.IsChecked; dr[39] = checkBox17.IsChecked; dr[40] = checkBox18.IsChecked; dr[41] = checkBox19.IsChecked; dr[42] = checkBox20.IsChecked; dr[43] = checkBox21.IsChecked; dr[44] = checkBox22.IsChecked; dr[45] = checkBox23.IsChecked; dr[46] = checkBox24.IsChecked; dr[47] = checkBox25.IsChecked; dr[48] = checkBox26.IsChecked; dr[49] = checkBox27.IsChecked; dr[50] = _RText.Text; dr[51] = textBox22.Text; dr.EndEdit(); dt.Rows.RemoveAt(index); dt.Rows.InsertAt(dr, index); editing = false; price.Stop(); }
private void search_button_Click(object sender, RoutedEventArgs e) { this.Topmost = false; errorOccurred = false; TextRange _text = new TextRange(comments.Document.ContentStart, comments.Document.ContentEnd); String cmt = _text.Text; cmt = cmt.Remove(cmt.Length - 2); try { String sql; if (rahn_High.Text.Trim().Length == 0 && rahn_Low.Text.Trim().Length == 0 && ejare_High.Text.Trim().Length == 0 && ejare_Low.Text.Trim().Length == 0) { if (rahnoejare_Low.Text.Trim().Length == 0 && rahnoejare_High.Text.Trim().Length == 0) { sql = model1(); } else { String low = MyPriceTextBox.getStringFromMasked(rahnoejare_Low.Text); String high = MyPriceTextBox.getStringFromMasked(rahnoejare_High.Text); if (low.Trim().Length == 0 || high.Trim().Length == 0) { MessageBox.Show("لطفا در این حالت که می خواهید از فیلد رهن و اجاره استفاده بنمایید هر دو طرف آن را پر بفرمایید", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); return; } sql = model2(low, high); } } else { sql = model1(); } DataTable dt = DB.execSqlReturnDataTable(sql, DBComboBox.SelectedIndex); if (Show3D_checkBox.IsChecked == true) { Result3D res3d = new Result3D(); res3d.dt = dt; res3d.Show(); } else { ResultWindow res = new ResultWindow(); res.session = session; res.which = Codes.MaghazeEstijari; res.dt = dt.Copy(); if (cols == null) { cols = new string[dt.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dt.Columns[i].ColumnName; } } for (int i = 1; i < cols.Length; i++) { if (i == 2 || i == 22 || i == 23) { continue; } if ((metraj_Low.Text.Trim().Length != 0 || metraj_High.Text.Trim().Length != 0) && i == 3) { continue; } if (owner.Text.Trim().Length != 0 && i == 20) { continue; } dt.Columns.Remove(cols[i]); } res.gridView.DataSource = dt; res.dbIndex = DBComboBox.SelectedIndex; res.Show(); } } catch (Exception) { errorOccurred = true; MessageBox.Show("خطا در اتصال و یا اجرای درخواست از پایگاه داده ها", "خطا", MessageBoxButton.OK, MessageBoxImage.Error); } }