public DM_DVQLY DM_DVQLY_SelectAll_byMaDVi(string Ma_DVi) { DM_DVQLY dm_dvqly = new DM_DVQLY(); DbDataReader reader = null; DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_MA_DVIQLY, Ma_DVi, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[DM_DVQLY_SelectAll_byMaDVi]", para.ToArray()); if (reader.HasRows && reader.Read()) { DM_DVQLYDataAccess.SetDM_DVQLYInfo(reader, ref dm_dvqly); } return(dm_dvqly); } catch (Exception ex) { throw new Exception(String.Format("DM_DVQLYDataAccess.DM_DVQLY_SelectAll_byMaDVi: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public void UpdateDM_DVQLY(DM_DVQLY dm_dvqly) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_dvqly.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_MA_DVIQLY, dm_dvqly.MA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_TEN_DVIQLY, dm_dvqly.TEN_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_ParentId, dm_dvqly.ParentId, false)); para.Add(_DbHelper.CreateParameter(FIELD_TENVIETTAT, dm_dvqly.TenVietTat, false)); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_DVQLY_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("DM_DVQLYDataAccess.Update: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDM_DVQLY(DM_DVQLY dm_dvqly) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_MA_DVIQLY, dm_dvqly.MA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_TEN_DVIQLY, dm_dvqly.TEN_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_ParentId, dm_dvqly.ParentId, false)); para.Add(_DbHelper.CreateParameter(FIELD_TENVIETTAT, dm_dvqly.TenVietTat, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_DVQLY_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DM_DVQLYDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
private static void SetDM_DVQLYInfo(DbDataReader reader, ref DM_DVQLY dm_dvqly) { dm_dvqly.IDMA_DVIQLY = int.Parse("0" + reader[FIELD_IDMA_DVIQLY]); dm_dvqly.TEN_DVIQLY = "" + reader[FIELD_TEN_DVIQLY]; dm_dvqly.MA_DVIQLY = "" + reader[FIELD_MA_DVIQLY]; dm_dvqly.ParentId = int.Parse("0" + reader[FIELD_ParentId]); dm_dvqly.NAME_DVIQLY = "" + reader[FIELD_NAME_DVIQLY]; dm_dvqly.TenVietTat = "" + reader["TenVietTat"]; }
private static void SetBindingListDM_DVQLYInfo(ref DbDataReader reader, ref BindingList <DM_DVQLY> dm_dvqlys) { DM_DVQLY dm_dvqly = null; while (reader.Read()) { dm_dvqly = new DM_DVQLY(); DM_DVQLYDataAccess.SetDM_DVQLYInfo(reader, ref dm_dvqly); dm_dvqlys.Add(dm_dvqly); } }
protected void TreeListOrganization_NodeDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { var key = (int)e.Keys[0]; var trl = new DM_DVQLY { IDMA_DVIQLY = key }; _DM_DVQLY.DeleteDM_DVQLY(trl); } catch (Exception) { throw new Exception("Dữ liệu này không thể xóa!"); } _DataBind(); e.Cancel = true; }
protected void btnCapNhat_Click(object sender, EventArgs e) { btnBack.Visible = false; btnAdd.Visible = true; btnEdit.Visible = true; btnCapNhat.Enabled = false; lblCurrentEdit.Visible = false; TreeListOrganization.Columns["btnDelete"].Visible = true; TreeListOrganization.SettingsBehavior.AllowFocusedNode = true; DM_DVQLY objOrganization = new DM_DVQLY(); objOrganization.MA_DVIQLY = txtNameOrganization.Text; objOrganization.TEN_DVIQLY = txtTenDV.Text; objOrganization.TenVietTat = txtTenVietTat.Text; var parentNode = TreeListOrganization.FocusedNode; if (cmbChoseParent.Value == null) { objOrganization.ParentId = 0; } else if (cmbChoseParent.Value != "-1") { objOrganization.ParentId = int.Parse(cmbChoseParent.Value + ""); } if (Session["Organization"] != null) { DM_DVQLY sysOrganization = (DM_DVQLY)Session["Organization"]; //objOrganization.ParentID = sysOrganization.ParentId; objOrganization.IDMA_DVIQLY = sysOrganization.IDMA_DVIQLY; if (cmbChoseParent.Value == null) { objOrganization.ParentId = 0; } else if (cmbChoseParent.Value != "-1") { objOrganization.ParentId = int.Parse(cmbChoseParent.Value + ""); } if (sysOrganization.MA_DVIQLY != txtNameOrganization.Text) { if (!CheckOrganization(txtNameOrganization.Text)) { lblError.Text = "Tên đơn vị này đã tồn tại.Mời bạn nhập tên khác !!"; SetVisiableControl(false); btnCapNhat.Enabled = true; return; } } _DM_DVQLY.UpdateDM_DVQLY(objOrganization); Session["Organization"] = null; //WriteLog("Update " + txtName.Text, Action.Update); } else { if (CheckOrganization(txtNameOrganization.Text)) { //objOrganization.ParentID = int.Parse(TreeListOrganization.FocusedNode.Key); _DM_DVQLY.InsertDM_DVQLY(objOrganization); //WriteLog("Insert " + txtName.Text, Action.Create); } else { lblError.Text = "Tên đơn vị này đã tồn tại.Mời bạn nhập tên khác !!"; SetVisiableControl(false); btnCapNhat.Enabled = true; return; } } _DataBind(); }
public void DeleteDM_DVQLY(DM_DVQLY dm_dvqlys) { _dm_dvqlyDataAccess.DeleteDM_DVQLY(dm_dvqlys); }
public void UpdateDM_DVQLY(DM_DVQLY dm_dvqly) { _dm_dvqlyDataAccess.UpdateDM_DVQLY(dm_dvqly); }
public int InsertDM_DVQLY(DM_DVQLY dm_dvqly) { return(_dm_dvqlyDataAccess.InsertDM_DVQLY(dm_dvqly)); }