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 += Control_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 += Control_KeyDown; mAutoMennu_DM_Intent_Type_Current.SetAutocompleteItems(DM_Intent_Type.GetDefaultList(0).Select(p => new AutoData(p.DM_Intent_TypeName, p.DM_Intent_TypeID.ToString())).ToList()); mAutoMennu_DM_Intent_Type_Current.ComboboxMode = true; mAutoMennu_DM_Intent_Type_Current.MaximumSize = new System.Drawing.Size(txtType_Current.Width - 4, 300); mAutoMennu_DM_Intent_Type_Current.SetAutocompleteMenu(txtType_Current); txtType_Current.KeyDown += Control_KeyDown; mAutoMennu_DM_Entity_Type_Current.SetAutocompleteItems(DM_Entity_Type.GetDefaultList(0).Select(p => new AutoData(p.DM_Entity_TypeName, p.DM_Entity_TypeID.ToString())).ToList()); mAutoMennu_DM_Entity_Type_Current.ComboboxMode = true; mAutoMennu_DM_Entity_Type_Current.MaximumSize = new System.Drawing.Size(txtEntity_Current.Width - 4, 300); mAutoMennu_DM_Entity_Type_Current.SetAutocompleteMenu(txtEntity_Current); txtEntity_Current.KeyDown += Control_KeyDown; txtName.Text = mIntent_Request.Data; txtType.Text = DM_Intent_Type.GetDefault(mIntent_Request.DM_Intent_TypeID).DM_Intent_TypeName; txtEntity.Text = DM_Entity_Type.GetDefault(mIntent_Request.DM_Entity_TypeID).DM_Entity_TypeName; txtType_Current.Text = DM_Intent_Type.GetDefault(mIntent_Request.Current_DM_Intent_TypeID).DM_Intent_TypeName; txtEntity_Current.Text = DM_Entity_Type.GetDefault(mIntent_Request.Current_DM_Entity_TypeID).DM_Entity_TypeName; }
private void btnXoa_Click(object sender, EventArgs e) { DM_Intent_Type data = mListViewData.SelectedObject as DM_Intent_Type; if (data != null && data.DM_Intent_TypeID > 0) { if (SanitaMessageBox.Show("Bạn có chắc chắn muốn xóa loại chủ đề này không ?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { //Check xem có Entity nào ko IList <DM_Entity_Type> listcheck = DM_Entity_Type.GetDefaultList(0).Where(p => p.DM_Entity_TypeID == data.DM_Intent_TypeID).ToList(); if (listcheck.Count == 0) { if (DM_Intent_TypePresenter.DeleteDM_Intent_Type(data) > 0) { DoRefresh(); } } else { SanitaMessageBox.Show("Loại chủ đề đã tồn tại đối tượng !", "Thông Báo".Translate()); return; } } } }
private void btnSave_Click(object sender, EventArgs e) { mIntent.IntentName = txtName.Text; mIntent.DM_Intent_TypeID = DM_Intent_Type.GetID(txtType.SelectedItem); bwAsync_Start(ProcessingType.SaveData); }
public FormEditIntent(Intent _mIntent, IList <Intent> _mListIntent) { 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); mIntent = _mIntent ?? new Intent(); mListIntent = _mListIntent; txtType.DataSource = DM_Intent_Type.GetDefaultList(0); txtType.DisplayMember = "DM_Intent_TypeName"; txtType.SelectedIndex = -1; txtName.Text = mIntent.IntentName; txtType.SelectedItem = DM_Intent_Type.GetDefault(txtType.DataSource, mIntent.DM_Intent_TypeID); }
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(txtChuDe.Width - 4, 300); mAutoMennu_DM_Intent_Type.SetAutocompleteMenu(txtChuDe); txtChuDe.KeyDown += txtChuDe_KeyDown; }
private void btnSave_Click(object sender, EventArgs e) { mIntent_Response.Data = txtName.Text; mIntent_Response.DM_Intent_TypeID = DM_Intent_Type.GetID(txtType.Text.Trim()); mIntent_Response.DM_Entity_TypeID = DM_Entity_Type.GetID(txtEntity.Text.Trim(), mIntent_Response.DM_Intent_TypeID); bwAsync_Start(ProcessingType.SaveData); }
private void bwAsync_DoWork(object sender, DoWorkEventArgs e) { Stopwatch mStopWatch = new Stopwatch(); mStopWatch.Start(); SanitaLogEx.d(TAG, "Start database cache..."); PostMessage("Start database cache ..."); IsCacheCompleted = false; try { //Update timer SystemInfo.NOW = SoftUpdatePresenter.GetCurrentTime(null, null); //Kiểm tra và nâng cấp cấu trúc database Splasher.Status = "Check and update database..."; SoftUpdatePresenter.DoUpdateDatabaseSQL(); using (IDbConnection connection = SoftUpdatePresenter.GetConnection()) { //Open connection connection.Open(); //Begin transtation using (IDbTransaction trans = connection.BeginTransaction()) { Splasher.Status = "Đang xử lý : Danh sách danh mục...".Translate(); DM_Intent_Type.InitDefaultList(DM_Intent_TypePresenter.GetDM_Intent_Types(connection, trans)); MyVar.mListDM_Intent_Type = DM_Intent_Type.GetDefaultList(0).OrderBy(p => p.DM_Intent_TypeID).ToList(); DM_Entity_Type.InitDefaultList(DM_Entity_TypePresenter.GetDM_Entity_Types(connection, trans)); MyVar.mListDM_Entity_Type = DM_Entity_Type.GetDefaultList(0).OrderBy(p => p.DM_Entity_TypeID).ToList(); MyVar.mListUser = UserPresenter.GetUsers(connection, trans); MyVar.mListHome = HomePresenter.GetHomes(connection, trans); MyVar.mListRoom = RoomPresenter.GetRooms(connection, trans); MyVar.mListDevice = DevicePresenter.GetDevices(connection, trans); //----------------------------------------------------------------------------- //Commit transtation trans.Commit(); //Close connection connection.Close(); } } SanitaLogEx.d(TAG, "End database cache..."); } catch (Exception ex) { SanitaLogEx.e(TAG, "bwAsync_DoWork error !", ex); } IsCacheCompleted = true; }
private void txtType_TextChanged(object sender, EventArgs e) { int DM_Intent_TypeID = DM_Intent_Type.GetID(txtType.Text.Trim()); if (DM_Intent_TypeID > 0) { mAutoMennu_DM_Entity_Type.SetAutocompleteItems(DM_Entity_Type.GetDefaultList(0).Where(p => p.DM_Intent_TypeID == DM_Intent_TypeID).Select(p => new AutoData(p.DM_Entity_TypeName, p.DM_Entity_TypeID.ToString())).ToList()); mAutoMennu_DM_Entity_Type.SetAutocompleteMenu(txtEntity); } }
private DM_Intent_Type MakeDM_Intent_Type(DataRow row) { DM_Intent_Type record = new DM_Intent_Type(); if (row != null) { record.SetProperty(row); } return(record); }
private void mListViewData_FormatRow(object sender, FormatRowEventArgs e) { DM_Intent_Type data = e.Model as DM_Intent_Type; if (data != null) { if (data.DM_Intent_TypeDisable == 1) { e.Item.Font = new System.Drawing.Font(e.Item.Font, System.Drawing.FontStyle.Strikeout); e.Item.ForeColor = Color.Red; } } }
public int DeleteDM_Intent_Type(DM_Intent_Type data) { lock (lockObject) { if (data == null) { return(DataTypeModel.RESULT_NG); } StringBuilder sql = new StringBuilder(); sql.Append(" DELETE FROM tb_dm_intent_type "); sql.Append(" WHERE DM_Intent_TypeDBID = " + DatabaseUtility.Escape(data.DM_Intent_TypeDBID)); return(baseDAO.DoUpdate(sql.ToString())); } }
private void bwAsync_Worker(object sender, DoWorkEventArgs e) { ProcessingType type = (ProcessingType)e.Argument; e.Result = type; switch (type) { case ProcessingType.LoadData: { mListIntent = IntentPresenter.GetIntents(); int index = 1; foreach (Intent data in mListIntent) { data.STT = index; index++; } } break; case ProcessingType.CapNhat: { foreach (DM_Intent_Type data in DM_Intent_Type.GetDefaultList(0)) { Intent mIntent = mListIntent.FirstOrDefault(p => p.DM_Intent_TypeID == data.DM_Intent_TypeID); if (mIntent == null) { mIntent = new Intent(); mIntent.DM_Intent_TypeID = data.DM_Intent_TypeID; mIntent.IntentName = data.DM_Intent_TypeName; IntentPresenter.InsertIntent(mIntent); } else { if (mIntent.IntentName != data.DM_Intent_TypeName) { mIntent.IntentName = data.DM_Intent_TypeName; IntentPresenter.UpdateIntent(mIntent); } } } } break; default: break; } }
private void mListViewData_MouseDoubleClick(object sender, MouseEventArgs e) { DM_Intent_Type data = mListViewData.SelectedObject as DM_Intent_Type; if (data != null && data.DM_Intent_TypeDBID > 0) { using (FormEditDM_Intent_Type form = new FormEditDM_Intent_Type(data, mListDM_Intent_Type)) { if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DoRefresh(); } } } }
private void btnSave_Click(object sender, EventArgs e) { //Validate if (String.IsNullOrEmpty(txtDoiTuong.Text.Trim())) { SanitaMessageBox.Show("Chưa nhập đối tượng !", "Thông Báo".Translate()); txtDoiTuong.Focus(); return; } mDM_Entity_Type.DM_Intent_TypeID = DM_Intent_Type.GetID(txtChuDe.Text.Trim()); mDM_Entity_Type.DM_Entity_TypeName = txtDoiTuong.Text; mDM_Entity_Type.DM_Entity_TypeDisable = txtDisable.Checked ? 1 : 0; bwAsync_Start(ProcessingType.SaveData); }
private void bwAsync_Worker(object sender, DoWorkEventArgs e) { ProcessingType type = (ProcessingType)e.Argument; e.Result = type; switch (type) { case ProcessingType.LoadData: { DM_Intent_Type.InitDefaultList(DM_Intent_TypePresenter.GetDM_Intent_Types(null, null)); mListDM_Intent_Type = DM_Intent_Type.GetDefaultList(1).OrderBy(p => p.DM_Intent_TypeID).ToList(); MyVar.mListDM_Intent_Type = DM_Intent_Type.GetDefaultList(0).OrderBy(p => p.DM_Intent_TypeID).ToList(); } break; default: break; } }
public FormEditDM_Intent_Type(DM_Intent_Type _mDM_Intent_Type, IList <DM_Intent_Type> _mListDM_Intent_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_Intent_Type = _mDM_Intent_Type ?? new DM_Intent_Type(); mListDM_Intent_Type = _mListDM_Intent_Type; txtLoaiChuDe.Text = mDM_Intent_Type.DM_Intent_TypeName; txtDisable.Checked = mDM_Intent_Type.DM_Intent_TypeDisable == 1; }
public FormViewIntent_Request() { 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_Request data = (Intent_Request)x; if (data != null && data.Intent_RequestID > 0) { return(DM_Intent_Type.GetDefault(data.DM_Intent_TypeID).DM_Intent_TypeName); } return(""); }; this.olvColumnDoiTuong.AspectGetter = delegate(object x) { Intent_Request data = (Intent_Request)x; if (data != null && data.Intent_RequestID > 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_Request data = (Intent_Request)x; if (data.mListSubData != null && data.mListSubData.Count > 0) { IList <Intent_Request> mListSubData = data.mListSubData; if (mListSubData.Count > 0) { return(true); } } return(false); }; this.mListViewData.ChildrenGetter = delegate(object x) { Intent_Request data = (Intent_Request)x; IList <Intent_Request> mListSubData = data.mListSubData; return(mListSubData); }; mListViewData.PrimarySortOrder = SortOrder.Ascending; mListViewData.PrimarySortColumn = olvColumnID; //Init container tree list view this.ListViewNhomDichVu.CanExpandGetter = delegate(object x) { ThongTinDanhSachIntent_Request data = (ThongTinDanhSachIntent_Request)x; if (data.mListSubData != null && data.mListSubData.Count > 0) { IList <ThongTinDanhSachIntent_Request> mListSubData = data.mListSubData; return(data.mListSubData.Count > 0); } return(false); }; this.ListViewNhomDichVu.ChildrenGetter = delegate(object x) { ThongTinDanhSachIntent_Request data = (ThongTinDanhSachIntent_Request)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 UpdateDM_Intent_Type(IDbConnection connection, IDbTransaction trans, DM_Intent_Type data) { lock (lockObject) { if (data == null) { return(DataTypeModel.RESULT_NG); } StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE tb_dm_intent_type "); sql.Append(" SET "); sql.Append(" DM_Intent_TypeID = " + data.DM_Intent_TypeID.Escape()).Append(", "); sql.Append(" DM_Intent_TypeName = " + data.DM_Intent_TypeName.Escape()).Append(", "); sql.Append(" DM_Intent_TypeHardcode = " + data.DM_Intent_TypeHardcode.Escape()).Append(", "); sql.Append(" DM_Intent_TypeDisable = " + data.DM_Intent_TypeDisable.Escape()); sql.Append(" WHERE DM_Intent_TypeDBID = " + data.DM_Intent_TypeDBID); return(baseDAO.DoUpdate(connection, trans, sql.ToString())); } }
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 static int DeleteDM_Intent_Type(DM_Intent_Type data) { return(DM_Intent_TypeDB.mInstance.DeleteDM_Intent_Type(data)); }
private void bwAsync_Worker(object sender, DoWorkEventArgs e) { ProcessingType type = (ProcessingType)e.Argument; e.Result = type; switch (type) { case ProcessingType.LoadData: { mListData_Flat = IntentPresenter.GetIntents(); //Update dữ liệu mListData = new List <Intent>(); 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 group_Intent = new Intent(); group_Intent.DM_Intent_TypeID = nhom.DM_Intent_TypeID; group_Intent.IntentID = -1; group_Intent.IntentName = nhom.DM_Intent_TypeName; group_Intent.mListSubData = mListData_Flat.Where(p => p.DM_Intent_TypeID == nhom.DM_Intent_TypeID).ToList(); mListData.Add(group_Intent); } } //Update danh sách tất cả các khoa { mListThongTinDanhSachIntent = new List <ThongTinDanhSachIntent>(); mListThongTinDanhSachIntent_Flat = new List <ThongTinDanhSachIntent>(); ThongTinDanhSachIntent.ThongTinDanhSachIntentID_Index = 1; //Add tất cả khoa ThongTinDanhSachIntent root = new ThongTinDanhSachIntent(); root.ThongTinDanhSachIntentType = (int)ThongTinDanhSachIntent.TYPE.ROOT; root.mListData = mListData; root.ThongTinDanhSachIntentName = "Tất Cả Ý Muốn (" + mListData_Flat.Where(p => p.IntentID > 0).Count() + ")"; mListThongTinDanhSachIntent.Add(root); mListThongTinDanhSachIntent_Flat.Add(root); } foreach (DM_Intent_Group nhom_dich_vu in DM_Intent_Group.GetDefaultList(0)) { ThongTinDanhSachIntent mData = new ThongTinDanhSachIntent(); mData.ThongTinDanhSachIntentType = (int)ThongTinDanhSachIntent.TYPE.GROUP; mData.DM_Intent_GroupID = nhom_dich_vu.DM_Intent_GroupID; mData.mListSubData = new List <ThongTinDanhSachIntent>(); mData.mListData = mListData; mData.ThongTinDanhSachIntentName = DM_Intent_Group.GetDefault(mData.DM_Intent_GroupID).DM_Intent_GroupName; //Add loại khoa { IList <DM_Intent_SubGroup> list_sub = DM_Intent_SubGroup.GetDefaultList_Group(0, mData.DM_Intent_GroupID); foreach (DM_Intent_SubGroup sub_data in list_sub) { ThongTinDanhSachIntent mSubData = new ThongTinDanhSachIntent(); mSubData.ThongTinDanhSachIntentType = (int)ThongTinDanhSachIntent.TYPE.SUB_GROUP; mSubData.DM_Intent_GroupID = mData.DM_Intent_GroupID; mSubData.DM_Intent_SubGroupID = sub_data.DM_Intent_SubGroupID; mSubData.mListData = new List <Intent>(); mSubData.ThongTinDanhSachIntentName = DM_Intent_SubGroup.GetDefault(mSubData.DM_Intent_SubGroupID).DM_Intent_SubGroupName; //Loai if (sub_data.DM_Intent_GroupID == DM_Intent_Group.LOAI) { int loai_khoa = sub_data.DM_Intent_SubGroupID - DM_Intent_SubGroup.LOAI_INIT; mSubData.mListData = mListData_Flat.Where(p => p.DM_Intent_TypeID == loai_khoa).ToList(); } //Check if (mSubData.mListData.Count > 0) { mSubData.ThongTinDanhSachIntentName += " (" + mSubData.mListData.Count + ")"; mData.mListSubData.Add(mSubData); mListThongTinDanhSachIntent_Flat.Add(mSubData); } } } //Check if (mData.mListData.Count > 0) { mListThongTinDanhSachIntent.Add(mData); mListThongTinDanhSachIntent_Flat.Add(mData); } } } break; default: break; } }
public int InsertDM_Intent_Type(IDbConnection connection, IDbTransaction trans, DM_Intent_Type data) { lock (lockObject) { if (data == null) { return(DataTypeModel.RESULT_NG); } StringBuilder sql = new StringBuilder(); sql.Append(" INSERT INTO tb_dm_intent_type ("); sql.Append(" DM_Intent_TypeID,"); sql.Append(" DM_Intent_TypeName,"); sql.Append(" DM_Intent_TypeHardcode,"); sql.Append(" DM_Intent_TypeDisable)"); sql.Append(" VALUES( "); sql.Append(" " + data.DM_Intent_TypeID.Escape()).Append(", "); sql.Append(" " + data.DM_Intent_TypeName.Escape()).Append(", "); sql.Append(" " + data.DM_Intent_TypeHardcode.Escape()).Append(", "); sql.Append(" " + data.DM_Intent_TypeDisable.Escape()).Append(") "); int newId = baseDAO.DoInsert(connection, trans, sql.ToString()); data.DM_Intent_TypeDBID = newId; if (newId > 0) { return(newId); } else { return(DataTypeModel.RESULT_NG); } } }
public static void UpdateDM_Intent_Type(DM_Intent_Type data) { DM_Intent_TypeDB.mInstance.UpdateDM_Intent_Type(null, null, data); }
public FormViewIntentData() { 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 data = (Intent)x; if (data != null && data.IntentID > 0) { return(DM_Intent_Type.GetDefault(data.DM_Intent_TypeID).DM_Intent_TypeName); } return(""); }; //Init container tree list view this.mListViewData.CanExpandGetter = delegate(object x) { Intent data = (Intent)x; if (data.mListSubData != null && data.mListSubData.Count > 0) { IList <Intent> mListSubData = data.mListSubData; if (mListSubData.Count > 0) { return(true); } } return(false); }; this.mListViewData.ChildrenGetter = delegate(object x) { Intent data = (Intent)x; IList <Intent> mListSubData = data.mListSubData; return(mListSubData); }; //Init container tree list view this.ListViewNhomDichVu.CanExpandGetter = delegate(object x) { ThongTinDanhSachIntent data = (ThongTinDanhSachIntent)x; if (data.mListSubData != null && data.mListSubData.Count > 0) { IList <ThongTinDanhSachIntent> mListSubData = data.mListSubData; return(data.mListSubData.Count > 0); } return(false); }; this.ListViewNhomDichVu.ChildrenGetter = delegate(object x) { ThongTinDanhSachIntent data = (ThongTinDanhSachIntent)x; return(data.mListSubData); }; }
public static int InsertDM_Intent_Type(DM_Intent_Type data) { return(DM_Intent_TypeDB.mInstance.InsertDM_Intent_Type(null, null, data)); }