public List <DiaDanh> DiaDanh_GetByTop(string Top, string Where, string Order) { List <DiaDanh> list = new List <DiaDanh>(); using (SqlCommand dbCmd = new SqlCommand("sp_DiaDanh_getByTop", openConnection())) { DiaDanh obj = new DiaDanh(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); dr.Close(); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.DiaDanhIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
private void lnkXoaDiaDanh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { //lay du lieu tu luoi DiaDanh objDiaDanh = new DiaDanh(); if (grvDiaDanh.RowCount > 0) { DataRow row = grvDiaDanh.GetDataRow(grvDiaDanh.FocusedRowHandle); objDiaDanh.DiaDanhID = int.Parse(row["PK_DiaDanh"].ToString()); objDiaDanh.TenDiaDanh = row["TenDiaDanh"].ToString(); objDiaDanh.DiaChi = row["DiaChi"].ToString(); objDiaDanh.DienThoai = row["DienThoai"].ToString(); objDiaDanh.GhiChu = row["MoTa"].ToString(); objDiaDanh.LoaiDiaDanhID = int.Parse(row["FK_LoaiDiaDanh"].ToString()); } else { return; } MessageBox.MessageBoxBA msg = new MessageBox.MessageBoxBA(); if (msg.Show("Bạn có đồng ý xóa địa danh này ?", "Thông báo", Taxi.MessageBox.MessageBoxButtonsBA.YesNoCancel, Taxi.MessageBox.MessageBoxIconBA.Question).ToString() == DialogResult.Yes.ToString()) { if (objDiaDanh.Delete()) { //Load lai grid LoadDSDiaDanh(g_LoaiDiaDanhID); new MessageBox.MessageBoxBA().Show("Xóa địa danh thành công"); } } }
public bool DiaDanh_Update(DiaDanh data) { bool check = false; try { using (SqlCommand dbCmd = new SqlCommand("sp_DiaDanh_Update", openConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@ID", data.ID)); dbCmd.Parameters.Add(new SqlParameter("@TenDiaDanh", data.TenDiaDanh)); dbCmd.Parameters.Add(new SqlParameter("@MoTa", data.MoTa)); int r = dbCmd.ExecuteNonQuery(); if (r > 0) { check = true; } } //Clear cache System.Web.HttpContext.Current.Cache.Remove("DiaDanh"); } catch { } return(check); }
private void lnkXoaDiaDanh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { //lay du lieu tu luoi gridDiaDanh.SelectionMode = Janus.Windows.GridEX.SelectionMode.SingleSelection; DiaDanh objDiaDanh = new DiaDanh(); if (gridDiaDanh.SelectedItems.Count > 0) { GridEXRow row = ((GridEXSelectedItem)gridDiaDanh.SelectedItems[0]).GetRow(); objDiaDanh.DiaDanhID = int.Parse(row.Cells["PK_DiaDanh"].Value.ToString()); objDiaDanh.TenDiaDanh = row.Cells["TenDiaDanh"].Value.ToString(); objDiaDanh.DiaChi = row.Cells["DiaChi"].Value.ToString(); objDiaDanh.DienThoai = row.Cells["DienThoai"].Value.ToString(); objDiaDanh.GhiChu = row.Cells["MoTa"].Value.ToString(); objDiaDanh.LoaiDiaDanhID = int.Parse(row.Cells["FK_LoaiDiaDanh"].Value.ToString()); } else { return; } MessageBox.MessageBox msg = new MessageBox.MessageBox(); if (msg.Show("Bạn có đồng ý xóa địa danh này ?", "Thông báo", Taxi.MessageBox.MessageBoxButtons.YesNoCancel, Taxi.MessageBox.MessageBoxIcon.Question).ToString() == DialogResult.Yes.ToString()) { if (objDiaDanh.Delete()) { //Load lai grid LoadDSDiaDanh(g_LoaiDiaDanhID); new MessageBox.MessageBox().Show("Xóa địa danh thành công"); } } }
private void lnkThemDiaDanh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { frmDiaDanh frm = new frmDiaDanh(); if (frm.ShowDialog(this) == DialogResult.OK) { DiaDanh objDiaDanh = new DiaDanh(); objDiaDanh = frm.GetDiaDanh(); if (objDiaDanh.TenDiaDanh.Length <= 0) { return; } if (objDiaDanh.DiaChi.Length <= 0) { return; } if (!objDiaDanh.Insert()) { new MessageBox.MessageBoxBA().Show("Lỗi thêm mới địa danh"); return; } else { //Load lai grid LoadDSDiaDanh(g_LoaiDiaDanhID); new MessageBox.MessageBoxBA().Show("Thêm mới địa danh thành công"); } } }
/// <summary> /// hàm thực hiện lấy dữ liệu autocomplete /// </summary> private void LoadDuLieuForAutoComplete() { if (g_ListDataAutoComplete == null) { g_ListDataAutoComplete = new AutoCompleteEntryCollection(); } string address = ""; string streetAbbr = ""; float kd = 0; float vd = 0; using (DataTable dt = new DiaDanh().GetRoadData_Autocomplete()) { if (dt != null && dt.Rows.Count > 0) { int i = 1; foreach (DataRow row in dt.Rows) { address = row["Street"].ToString(); streetAbbr = row["StreetAbbr"].ToString(); kd = float.Parse(row["KinhDo"].ToString()); vd = float.Parse(row["ViDo"].ToString()); g_ListDataAutoComplete.Add(new AutoCompleteEntry(address, kd, vd, streetAbbr)); i++; } } } }
private void SetDiaDanh(DiaDanh diadanh) { if (diadanh != null) { editName.Text = mDiaDanh.TenDiaDanh; editAddress.Text = mDiaDanh.DiaChi; editPhone.Text = mDiaDanh.DienThoai; editMoTa.Text = mDiaDanh.GhiChu; cboLoaiDiaDanh.SelectedValue = (int)mDiaDanh.LoaiDiaDanhID; } }
private void lnkSuaDiaDanh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { //lay du lieu tu luoi gridDiaDanh.SelectionMode = Janus.Windows.GridEX.SelectionMode.SingleSelection; DiaDanh objDiaDanh = new DiaDanh(); if (gridDiaDanh.SelectedItems.Count > 0) { GridEXRow row = ((GridEXSelectedItem)gridDiaDanh.SelectedItems[0]).GetRow(); objDiaDanh.DiaDanhID = int.Parse(row.Cells["PK_DiaDanh"].Value.ToString()); objDiaDanh.TenDiaDanh = row.Cells["TenDiaDanh"].Value.ToString(); objDiaDanh.DiaChi = row.Cells["DiaChi"].Value.ToString(); objDiaDanh.DienThoai = row.Cells["DienThoai"].Value.ToString(); objDiaDanh.GhiChu = row.Cells["MoTa"].Value.ToString(); objDiaDanh.LoaiDiaDanhID = int.Parse(row.Cells["FK_LoaiDiaDanh"].Value.ToString()); } else { return; } frmDiaDanh frm = new frmDiaDanh(objDiaDanh, false); if (frm.ShowDialog(this) == DialogResult.OK) { objDiaDanh = frm.GetDiaDanh(); if (objDiaDanh.TenDiaDanh.Length <= 0) { return; } if (objDiaDanh.DiaChi.Length <= 0) { return; } if (!objDiaDanh.Update()) { new MessageBox.MessageBoxBA().Show("Lỗi cập nhật địa danh"); return; } else { //Load lai grid LoadDSDiaDanh(g_LoaiDiaDanhID); new MessageBox.MessageBoxBA().Show("Cập nhật địa danh thành công"); } } }
/// <summary> /// Khoi tao mot doi tương DoiTac, o che do thêm mơi hay sửa đổi thông tin /// </summary> /// <param name="DoiTac"></param> /// <param name="boolAdd"></param> public frmDiaDanh(DiaDanh DiaDanh, bool boolAdd) { InitializeComponent(); mIsAdd = boolAdd; if (boolAdd) { this.Text = "Thêm mới địa danh"; } else { this.Text = "Sửa đổi thông tin địa danh"; } mDiaDanh = DiaDanh; }
public DiaDanh GetDiaDanh() { if (mDiaDanh == null) { mDiaDanh = new DiaDanh(); } mDiaDanh.TenDiaDanh = StringTools.TrimSpace(editName.Text); mDiaDanh.DiaChi = StringTools.TrimSpace(editAddress.Text); mDiaDanh.DienThoai = StringTools.TrimSpace(editPhone.Text); mDiaDanh.GhiChu = StringTools.TrimSpace(editMoTa.Text); mDiaDanh.LoaiDiaDanhID = int.Parse(cboLoaiDiaDanh.SelectedValue.ToString()); return(mDiaDanh); }
/// <summary> /// tim kiếm thông tin địa danh /// </summary> private void Search() { string strSearch = StringTools.TrimSpace(txtTimKiem.Text); if (strSearch.Length > 0) { if (rdoDiaChi.Checked) { grcDiaDanh.DataSource = DiaDanh.GetDSDiaDanh_ByDiaChi(strSearch); } else { grcDiaDanh.DataSource = DiaDanh.GetDSDiaDanh_ByTenDiaDanh(strSearch); } } else { LoadDSDiaDanh(); } }
/// <summary> /// tim kiếm thông tin địa danh /// </summary> private void Search() { string strSearch = StringTools.TrimSpace(txtTimKiem.Text); if (strSearch.Length > 0) { gridDiaDanh.DataMember = "ListOfDiaDanh"; if (rdoDiaChi.Checked) { gridDiaDanh.SetDataBinding(DiaDanh.GetDSDiaDanh_ByDiaChi(strSearch), "ListOfDoiTac"); } else { gridDiaDanh.SetDataBinding(DiaDanh.GetDSDiaDanh_ByTenDiaDanh(strSearch), "ListOfDoiTac"); } } else { LoadDSDiaDanh(); } }
public void LoadDSDiaDanh(int LoaiDiaDanhID) { grcDiaDanh.DataSource = DiaDanh.GetDSDiaDanh_ByLoaiDiaDanh(LoaiDiaDanhID); }
public bool DiaDanh_Update(DiaDanh data) { return(obj.DiaDanh_Update(data)); }
public bool DiaDanh_Insert(DiaDanh data) { return(obj.DiaDanh_Insert(data)); }
public void LoadDSDiaDanh() { gridDiaDanh.DataMember = "ListOfDiaDanh"; gridDiaDanh.SetDataBinding(DiaDanh.GetDSDiaDanh(), "ListOfDoiTac"); }
public void LoadDSDiaDanh(int LoaiDiaDanhID) { gridDiaDanh.DataMember = "ListOfDiaDanh"; gridDiaDanh.SetDataBinding(DiaDanh.GetDSDiaDanh_ByLoaiDiaDanh(LoaiDiaDanhID), "ListOfDoiTac"); }
public void LoadDSDiaDanh() { grcDiaDanh.DataSource = DiaDanh.GetDSDiaDanh(); }