public int DeleteDM_Entity_Type(DM_Entity_Type data)
{
lock (lockObject)
{
if (data == null)
{
return(DataTypeModel.RESULT_NG);
}
StringBuilder sql = new StringBuilder();
sql.Append(" DELETE FROM tb_dm_entity_type ");
sql.Append(" WHERE DM_Entity_TypeDBID = " + DatabaseUtility.Escape(data.DM_Entity_TypeDBID));
return(baseDAO.DoUpdate(sql.ToString()));
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
DM_Entity_Type data = mListViewData.SelectedObject as DM_Entity_Type;
if (data != null && data.DM_Entity_TypeDBID > 0)
{
if (SanitaMessageBox.Show("Bạn có chắc chắn muốn xóa không ?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
if (DM_Entity_TypePresenter.DeleteDM_Entity_Type(data) > 0)
{
DoRefresh();
}
}
}
}
private void mListViewData_MouseDoubleClick(object sender, MouseEventArgs e)
{
DM_Entity_Type data = mListViewData.SelectedObject as DM_Entity_Type;
if (data != null && data.DM_Entity_TypeDBID > 0)
{
using (FormEditDM_Entity_Type form = new FormEditDM_Entity_Type(data, mListData_Flat))
{
if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
mDM_Entity_Type = form.mDM_Entity_Type;
DoRefresh();
}
}
}
}
private void mListViewData_FormatRow(object sender, FormatRowEventArgs e)
{
DM_Entity_Type data = e.Model as DM_Entity_Type;
if (data != null)
{
if (data.DM_Entity_TypeDBID < 0)
{
e.Item.Font = new System.Drawing.Font(e.Item.Font, System.Drawing.FontStyle.Bold);
}
if (data.DM_Entity_TypeDisable == 1)
{
e.Item.Font = new System.Drawing.Font(e.Item.Font, System.Drawing.FontStyle.Strikeout);
e.Item.ForeColor = Color.Red;
}
}
}
private void Database_Load(object sender, EventArgs e)
{
mAutoMennu_DM_Intent_Type.SetAutocompleteItems(DM_Intent_Type.GetDefaultList(0).Select(p => new AutoData(p.DM_Intent_TypeName, p.DM_Intent_TypeID.ToString())).ToList());
mAutoMennu_DM_Intent_Type.ComboboxMode = true;
mAutoMennu_DM_Intent_Type.MaximumSize = new System.Drawing.Size(txtType.Width - 4, 300);
mAutoMennu_DM_Intent_Type.SetAutocompleteMenu(txtType);
txtType.KeyDown += txtType_KeyDown;
mAutoMennu_DM_Entity_Type.SetAutocompleteItems(DM_Entity_Type.GetDefaultList(0).Select(p => new AutoData(p.DM_Entity_TypeName, p.DM_Entity_TypeID.ToString())).ToList());
mAutoMennu_DM_Entity_Type.ComboboxMode = true;
mAutoMennu_DM_Entity_Type.MaximumSize = new System.Drawing.Size(txtEntity.Width - 4, 300);
mAutoMennu_DM_Entity_Type.SetAutocompleteMenu(txtEntity);
txtEntity.KeyDown += txtEntity_KeyDown;
txtName.Text = mIntent_Response.Data;
txtType.Text = DM_Intent_Type.GetDefault(mIntent_Response.DM_Intent_TypeID).DM_Intent_TypeName;
txtEntity.Text = DM_Entity_Type.GetDefault(mIntent_Response.DM_Entity_TypeID).DM_Entity_TypeName;
}
public FormEditDM_Entity_Type(DM_Entity_Type _mDM_Entity_Type, IList <DM_Entity_Type> _mListDM_Entity_Type)
{
InitializeComponent();
this.Translate();
this.UpdateUI();
base.DoInit();
//Create worker
mThread = new ExBackgroundWorker();
mThread.WorkerReportsProgress = true;
mThread.WorkerSupportsCancellation = true;
mThread.ProgressChanged += new ProgressChangedEventHandler(bwAsync_WorkerChanged);
mThread.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwAsync_WorkerCompleted);
mThread.DoWork += new DoWorkEventHandler(bwAsync_Worker);
mDM_Entity_Type = _mDM_Entity_Type ?? new DM_Entity_Type();
mListDM_Entity_Type = _mListDM_Entity_Type;
txtChuDe.Text = DM_Intent_Type.GetDefault(mDM_Entity_Type.DM_Intent_TypeID).DM_Intent_TypeName;
txtDoiTuong.Text = mDM_Entity_Type.DM_Entity_TypeName;
txtDisable.Checked = mDM_Entity_Type.DM_Entity_TypeDisable == 1;
}
public FormViewIntent_Response()
{
InitializeComponent();
this.Translate();
this.UpdateUI();
base.DoInit();
//Create worker
mThread = new ExBackgroundWorker();
mThread.WorkerReportsProgress = true;
mThread.WorkerSupportsCancellation = true;
mThread.ProgressChanged += new ProgressChangedEventHandler(bwAsync_WorkerChanged);
mThread.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwAsync_WorkerCompleted);
mThread.DoWork += new DoWorkEventHandler(bwAsync_Worker);
this.olvColumnLoai.AspectGetter = delegate(object x)
{
Intent_Response data = (Intent_Response)x;
if (data != null && data.Intent_ResponseID > 0)
{
return(DM_Intent_Type.GetDefault(data.DM_Intent_TypeID).DM_Intent_TypeName);
}
return("");
};
this.olvColumnDoiTuong.AspectGetter = delegate(object x)
{
Intent_Response data = (Intent_Response)x;
if (data != null && data.Intent_ResponseID > 0)
{
DM_Entity_Type checkdata = DM_Entity_Type.GetDefaultList(0).FirstOrDefault(p => p.DM_Intent_TypeID == data.DM_Intent_TypeID && p.DM_Entity_TypeID == data.DM_Entity_TypeID);
if (checkdata != null)
{
return(checkdata.DM_Entity_TypeName);
}
else
{
return("");
}
}
return("");
};
//Init container tree list view
this.mListViewData.CanExpandGetter = delegate(object x)
{
Intent_Response data = (Intent_Response)x;
if (data.mListSubData != null && data.mListSubData.Count > 0)
{
IList <Intent_Response> mListSubData = data.mListSubData;
if (mListSubData.Count > 0)
{
return(true);
}
}
return(false);
};
this.mListViewData.ChildrenGetter = delegate(object x)
{
Intent_Response data = (Intent_Response)x;
IList <Intent_Response> mListSubData = data.mListSubData;
return(mListSubData);
};
//Init container tree list view
this.ListViewNhomDichVu.CanExpandGetter = delegate(object x)
{
ThongTinDanhSachIntent_Response data = (ThongTinDanhSachIntent_Response)x;
if (data.mListSubData != null && data.mListSubData.Count > 0)
{
IList <ThongTinDanhSachIntent_Response> mListSubData = data.mListSubData;
return(data.mListSubData.Count > 0);
}
return(false);
};
this.ListViewNhomDichVu.ChildrenGetter = delegate(object x)
{
ThongTinDanhSachIntent_Response data = (ThongTinDanhSachIntent_Response)x;
return(data.mListSubData);
};
}
private void bwAsync_Worker(object sender, DoWorkEventArgs e)
{
ProcessingType type = (ProcessingType)e.Argument;
e.Result = type;
switch (type)
{
case ProcessingType.LoadData:
{
mListData_Flat = Intent_ResponsePresenter.GetIntent_Responses();
//Update dữ liệu
mListData = new List <Intent_Response>();
foreach (DM_Intent_Type nhom in DM_Intent_Type.GetDefaultList(0))
{
if (mListData_Flat.Any(p => p.DM_Intent_TypeID == nhom.DM_Intent_TypeID))
{
Intent_Response group_Intent_Response = new Intent_Response();
group_Intent_Response.DM_Intent_TypeID = nhom.DM_Intent_TypeID;
group_Intent_Response.Intent_ResponseID = -1;
group_Intent_Response.Data = nhom.DM_Intent_TypeName;
group_Intent_Response.mListSubData = new List <Intent_Response>();
mListData.Add(group_Intent_Response);
IList <DM_Entity_Type> ListDM_Entity_Type = DM_Entity_Type.GetDefaultList(0).Where(p => p.DM_Intent_TypeID == nhom.DM_Intent_TypeID).ToList();
if (ListDM_Entity_Type.Count == 0)
{
group_Intent_Response.mListSubData = mListData_Flat.Where(p => p.DM_Intent_TypeID == nhom.DM_Intent_TypeID).ToList();
group_Intent_Response.mListSubData = group_Intent_Response.mListSubData.Select(p => { p.mParent = group_Intent_Response; return(p); }).ToList();
}
else
{
foreach (DM_Entity_Type loai_dichvu in ListDM_Entity_Type)
{
if (mListData_Flat.Any(p => p.DM_Entity_TypeID == loai_dichvu.DM_Entity_TypeID && p.DM_Intent_TypeID == loai_dichvu.DM_Intent_TypeID))
{
Intent_Response type_service = new Intent_Response();
type_service.DM_Intent_TypeID = nhom.DM_Intent_TypeID;
type_service.DM_Entity_TypeID = loai_dichvu.DM_Entity_TypeID;
type_service.Intent_ResponseID = -2;
type_service.Data = loai_dichvu.DM_Entity_TypeName;
type_service.mListSubData = mListData_Flat.Where(p => p.DM_Entity_TypeID == loai_dichvu.DM_Entity_TypeID && p.DM_Intent_TypeID == loai_dichvu.DM_Intent_TypeID).ToList();
type_service.mListSubData = type_service.mListSubData.Select(p => { p.mParent = type_service; return(p); }).ToList();
if (type_service.mListSubData.Count > 0)
{
group_Intent_Response.mListSubData.Add(type_service);
}
}
}
}
}
}
//Update danh sách
{
mListThongTinDanhSachIntent_Response = new List <ThongTinDanhSachIntent_Response>();
mListThongTinDanhSachIntent_Response_Flat = new List <ThongTinDanhSachIntent_Response>();
ThongTinDanhSachIntent_Response.ThongTinDanhSachIntent_ResponseID_Index = 1;
//Add tất cả nhóm dịch vụ
ThongTinDanhSachIntent_Response root = new ThongTinDanhSachIntent_Response();
root.ThongTinDanhSachIntent_ResponseType = (int)ThongTinDanhSachIntent_Response.TYPE.ROOT;
root.mListData = mListData;
root.ThongTinDanhSachIntent_ResponseName = String.Format("Tất cả ({0})".Translate(), mListData_Flat.Count());
mListThongTinDanhSachIntent_Response.Add(root);
mListThongTinDanhSachIntent_Response_Flat.Add(root);
foreach (DM_Intent_Type nhom_dich_vu in DM_Intent_Type.GetDefaultList(1))
{
Intent_Response group_service = mListData.FirstOrDefault(p => p.DM_Intent_TypeID == nhom_dich_vu.DM_Intent_TypeID && p.Intent_ResponseID == -1);
if (group_service != null)
{
ThongTinDanhSachIntent_Response mData = new ThongTinDanhSachIntent_Response();
mData.ThongTinDanhSachIntent_ResponseType = (int)ThongTinDanhSachIntent_Response.TYPE.GROUP;
mData.DM_Intent_TypeID = nhom_dich_vu.DM_Intent_TypeID;
mData.mListSubData = new List <ThongTinDanhSachIntent_Response>();
mData.mListData = group_service.mListSubData;
mData.ThongTinDanhSachIntent_ResponseName = DM_Intent_Type.GetDefault(mData.DM_Intent_TypeID).DM_Intent_TypeName + " (" + mListData_Flat.Where(p => p.DM_Intent_TypeID == mData.DM_Intent_TypeID).Count() + ")";
mListThongTinDanhSachIntent_Response.Add(mData);
mListThongTinDanhSachIntent_Response_Flat.Add(mData);
//Add loại dịch vụ
{
IList <DM_Entity_Type> list_sub = DM_Entity_Type.GetDefaultList(0).Where(p => p.DM_Intent_TypeID == nhom_dich_vu.DM_Intent_TypeID).ToList();
list_sub = list_sub.OrderBy(p => p.DM_Intent_TypeID).ThenBy(p => p.DM_Entity_TypeID).ToList();
foreach (DM_Entity_Type sub_data in list_sub)
{
Intent_Response type_service = group_service.mListSubData.FirstOrDefault(p => p.DM_Entity_TypeID == sub_data.DM_Entity_TypeID && p.Intent_ResponseID == -2 && p.DM_Intent_TypeID == sub_data.DM_Intent_TypeID);
if (type_service != null)
{
ThongTinDanhSachIntent_Response mSubData = new ThongTinDanhSachIntent_Response();
mSubData.ThongTinDanhSachIntent_ResponseType = (int)ThongTinDanhSachIntent_Response.TYPE.SUB_GROUP;
mSubData.DM_Intent_TypeID = mData.DM_Intent_TypeID;
mSubData.DM_Entity_TypeID = sub_data.DM_Entity_TypeID;
mSubData.mListData = group_service.mListSubData.Where(p => p.DM_Entity_TypeID == sub_data.DM_Entity_TypeID && p.DM_Intent_TypeID == sub_data.DM_Intent_TypeID).ToList();
mSubData.ThongTinDanhSachIntent_ResponseName = DM_Entity_Type.GetDefault(mSubData.DM_Entity_TypeID).DM_Entity_TypeName + " (" + mListData_Flat.Where(p => p.DM_Entity_TypeID == mSubData.DM_Entity_TypeID && p.DM_Intent_TypeID == mSubData.DM_Intent_TypeID).Count() + ")";
if (mSubData.mListData.Count > 0)
{
mData.mListSubData.Add(mSubData);
mListThongTinDanhSachIntent_Response_Flat.Add(mSubData);
}
}
}
}
}
}
}
}
break;
default:
break;
}
}
public FormViewDM_Entity_Type()
{
InitializeComponent();
this.Translate();
this.UpdateUI();
base.DoInit();
//Create worker
mThread = new ExBackgroundWorker();
mThread.WorkerReportsProgress = true;
mThread.WorkerSupportsCancellation = true;
mThread.ProgressChanged += new ProgressChangedEventHandler(bwAsync_WorkerChanged);
mThread.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwAsync_WorkerCompleted);
mThread.DoWork += new DoWorkEventHandler(bwAsync_Worker);
this.olvColumnID.AspectGetter = delegate(object x)
{
DM_Entity_Type data = (DM_Entity_Type)x;
if (data != null && data.DM_Entity_TypeID > 0)
{
return(data.DM_Entity_TypeID);
}
return("");
};
//Init container tree list view
this.mListViewData.CanExpandGetter = delegate(object x)
{
DM_Entity_Type data = (DM_Entity_Type)x;
if (data.mListSubData != null && data.mListSubData.Count > 0)
{
IList <DM_Entity_Type> mListSubData = data.mListSubData;
if (mListSubData.Count > 0)
{
return(true);
}
}
return(false);
};
this.mListViewData.ChildrenGetter = delegate(object x)
{
DM_Entity_Type data = (DM_Entity_Type)x;
IList <DM_Entity_Type> mListSubData = data.mListSubData;
return(mListSubData);
};
mListViewData.PrimarySortOrder = SortOrder.Ascending;
//Init container tree list view
this.ListViewNhomDichVu.CanExpandGetter = delegate(object x)
{
ThongTinDanhSachDM_Entity_Type data = (ThongTinDanhSachDM_Entity_Type)x;
if (data.mListSubData != null && data.mListSubData.Count > 0)
{
IList <ThongTinDanhSachDM_Entity_Type> mListSubData = data.mListSubData;
return(data.mListSubData.Count > 0);
}
return(false);
};
this.ListViewNhomDichVu.ChildrenGetter = delegate(object x)
{
ThongTinDanhSachDM_Entity_Type data = (ThongTinDanhSachDM_Entity_Type)x;
return(data.mListSubData);
};
}
private void bwAsync_Worker(object sender, DoWorkEventArgs e)
{
ProcessingType type = (ProcessingType)e.Argument;
e.Result = type;
switch (type)
{
case ProcessingType.LoadData:
{
DM_Entity_Type.InitDefaultList(DM_Entity_TypePresenter.GetDM_Entity_Types(null, null));
mListData_Flat = DM_Entity_Type.GetDefaultList(1).OrderBy(p => p.DM_Entity_TypeID).ToList();
MyVar.mListDM_Entity_Type = DM_Entity_Type.GetDefaultList(0).OrderBy(p => p.DM_Entity_TypeID).ToList();
//Update dữ liệu
mListData = new List <DM_Entity_Type>();
foreach (DM_Intent_Type nhom_khoa in DM_Intent_Type.GetDefaultList(0))
{
if (mListData_Flat.Any(p => p.DM_Intent_TypeID == nhom_khoa.DM_Intent_TypeID))
{
DM_Entity_Type group_DM_Entity_Type = new DM_Entity_Type();
group_DM_Entity_Type.DM_Intent_TypeID = nhom_khoa.DM_Intent_TypeID;
group_DM_Entity_Type.DM_Entity_TypeDBID = -1;
group_DM_Entity_Type.DM_Entity_TypeName = nhom_khoa.DM_Intent_TypeName;
group_DM_Entity_Type.mListSubData = mListData_Flat.Where(p => p.DM_Intent_TypeID == nhom_khoa.DM_Intent_TypeID).ToList();
mListData.Add(group_DM_Entity_Type);
}
}
//Update danh sách
{
mListThongTinDanhSachDM_Entity_Type = new List <ThongTinDanhSachDM_Entity_Type>();
mListThongTinDanhSachDM_Entity_Type_Flat = new List <ThongTinDanhSachDM_Entity_Type>();
ThongTinDanhSachDM_Entity_Type.ThongTinDanhSachDM_Entity_TypeID_Index = 1;
//Add tất cả khoa
ThongTinDanhSachDM_Entity_Type root = new ThongTinDanhSachDM_Entity_Type();
root.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.ROOT;
root.mListData = mListData;
root.ThongTinDanhSachDM_Entity_TypeName = "Tất Cả Đối Tượng (" + mListData_Flat.Where(p => p.DM_Entity_TypeID > 0).Count() + ")";
mListThongTinDanhSachDM_Entity_Type.Add(root);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(root);
}
foreach (DM_DM_Entity_Type_Group nhom_dich_vu in DM_DM_Entity_Type_Group.GetDefaultList(0))
{
ThongTinDanhSachDM_Entity_Type mData = new ThongTinDanhSachDM_Entity_Type();
mData.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.GROUP;
mData.DM_DM_Entity_Type_GroupID = nhom_dich_vu.DM_DM_Entity_Type_GroupID;
mData.mListSubData = new List <ThongTinDanhSachDM_Entity_Type>();
mData.mListData = mListData;
mData.ThongTinDanhSachDM_Entity_TypeName = DM_DM_Entity_Type_Group.GetDefault(mData.DM_DM_Entity_Type_GroupID).DM_DM_Entity_Type_GroupName;
//Add loại khoa
{
IList <DM_DM_Entity_Type_SubGroup> list_sub = DM_DM_Entity_Type_SubGroup.GetDefaultList_Group(0, mData.DM_DM_Entity_Type_GroupID);
foreach (DM_DM_Entity_Type_SubGroup sub_data in list_sub)
{
ThongTinDanhSachDM_Entity_Type mSubData = new ThongTinDanhSachDM_Entity_Type();
mSubData.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.SUB_GROUP;
mSubData.DM_DM_Entity_Type_GroupID = mData.DM_DM_Entity_Type_GroupID;
mSubData.DM_DM_Entity_Type_SubGroupID = sub_data.DM_DM_Entity_Type_SubGroupID;
mSubData.mListData = new List <DM_Entity_Type>();
mSubData.ThongTinDanhSachDM_Entity_TypeName = DM_DM_Entity_Type_SubGroup.GetDefault(mSubData.DM_DM_Entity_Type_SubGroupID).DM_DM_Entity_Type_SubGroupName;
//Loai
if (sub_data.DM_DM_Entity_Type_GroupID == DM_DM_Entity_Type_Group.INTENT)
{
int loai_khoa = sub_data.DM_DM_Entity_Type_SubGroupID - DM_DM_Entity_Type_SubGroup.INTENT_INIT;
mSubData.mListData = mListData_Flat.Where(p => p.DM_Intent_TypeID == loai_khoa).ToList();
}
//Check
if (mSubData.mListData.Count > 0)
{
mSubData.ThongTinDanhSachDM_Entity_TypeName += " (" + mSubData.mListData.Count + ")";
mData.mListSubData.Add(mSubData);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(mSubData);
}
}
}
//Check
if (mData.mListData.Count > 0)
{
mListThongTinDanhSachDM_Entity_Type.Add(mData);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(mData);
}
}
}
break;
default:
break;
}
}
public int InsertDM_Entity_Type(IDbConnection connection, IDbTransaction trans, DM_Entity_Type data)
{
lock (lockObject)
{
if (data == null)
{
return(DataTypeModel.RESULT_NG);
}
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO tb_dm_entity_type (");
sql.Append(" DM_Entity_TypeID,");
sql.Append(" DM_Intent_TypeID,");
sql.Append(" DM_Entity_TypeName,");
sql.Append(" DM_Entity_TypeHardcode,");
sql.Append(" DM_Entity_TypeDisable)");
sql.Append(" VALUES( ");
sql.Append(" " + data.DM_Entity_TypeID.Escape()).Append(", ");
sql.Append(" " + data.DM_Intent_TypeID.Escape()).Append(", ");
sql.Append(" " + data.DM_Entity_TypeName.Escape()).Append(", ");
sql.Append(" " + data.DM_Entity_TypeHardcode.Escape()).Append(", ");
sql.Append(" " + data.DM_Entity_TypeDisable.Escape()).Append(") ");
int newId = baseDAO.DoInsert(connection, trans, sql.ToString());
data.DM_Entity_TypeDBID = newId;
if (newId > 0)
{
return(newId);
}
else
{
return(DataTypeModel.RESULT_NG);
}
}
}
public int UpdateDM_Entity_Type(IDbConnection connection, IDbTransaction trans, DM_Entity_Type data)
{
lock (lockObject)
{
if (data == null)
{
return(DataTypeModel.RESULT_NG);
}
StringBuilder sql = new StringBuilder();
sql.Append(" UPDATE tb_dm_entity_type ");
sql.Append(" SET ");
sql.Append(" DM_Entity_TypeID = " + data.DM_Entity_TypeID.Escape()).Append(", ");
sql.Append(" DM_Intent_TypeID = " + data.DM_Intent_TypeID.Escape()).Append(", ");
sql.Append(" DM_Entity_TypeName = " + data.DM_Entity_TypeName.Escape()).Append(", ");
sql.Append(" DM_Entity_TypeHardcode = " + data.DM_Entity_TypeHardcode.Escape()).Append(", ");
sql.Append(" DM_Entity_TypeDisable = " + data.DM_Entity_TypeDisable.Escape());
sql.Append(" WHERE DM_Entity_TypeDBID = " + data.DM_Entity_TypeDBID);
return(baseDAO.DoUpdate(connection, trans, sql.ToString()));
}
}
public static int DeleteDM_Entity_Type(DM_Entity_Type data)
{
return(DM_Entity_TypeDB.mInstance.DeleteDM_Entity_Type(data));
}
public static int InsertDM_Entity_Type(DM_Entity_Type data)
{
return(DM_Entity_TypeDB.mInstance.InsertDM_Entity_Type(null, null, data));
}
public static void UpdateDM_Entity_Type(DM_Entity_Type data)
{
DM_Entity_TypeDB.mInstance.UpdateDM_Entity_Type(null, null, data);
}
