Пример #1
0
        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;
        }
Пример #2
0
        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;
                    }
                }
            }
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
        }
Пример #5
0
 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;
 }
Пример #6
0
        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);
        }
Пример #7
0
        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;
        }
Пример #8
0
        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);
            }
        }
Пример #9
0
        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);
        }
Пример #10
0
        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;
                }
            }
        }
Пример #11
0
 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()));
     }
 }
Пример #12
0
        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;
            }
        }
Пример #13
0
        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();
                    }
                }
            }
        }
Пример #14
0
        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);
        }
Пример #15
0
        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;
            }
        }
Пример #16
0
        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;
        }
Пример #17
0
        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);
            };
        }
Пример #18
0
        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;
            }
        }
Пример #19
0
        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()));
            }
        }
Пример #20
0
        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;
            }
        }
Пример #21
0
 public static int DeleteDM_Intent_Type(DM_Intent_Type data)
 {
     return(DM_Intent_TypeDB.mInstance.DeleteDM_Intent_Type(data));
 }
Пример #22
0
        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;
            }
        }
Пример #23
0
 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);
         }
     }
 }
Пример #24
0
 public static void UpdateDM_Intent_Type(DM_Intent_Type data)
 {
     DM_Intent_TypeDB.mInstance.UpdateDM_Intent_Type(null, null, data);
 }
Пример #25
0
        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);
            };
        }
Пример #26
0
 public static int InsertDM_Intent_Type(DM_Intent_Type data)
 {
     return(DM_Intent_TypeDB.mInstance.InsertDM_Intent_Type(null, null, data));
 }