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));
}
