lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/CallerWizard/FrmOutgoingCalls.cs

using LYFZ.ComponentLibrary;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.CallerWizard
{
    public partial class FrmOutgoingCalls : LYFZ.Software.UI.CallerWizard.FrmOutgoingCalls
    {
        LYFZ.BLL.BLL_ErpCallWizard cwbll = new BLL.BLL_ErpCallWizard();
        private delegate void UpdateControl();
        public FrmOutgoingCalls()
        {
            this.Shown += FrmCustomerCalls_Shown;
            this.btnQuery.Click += btnQuery_Click;
            this.btnDelete.Click += btnDelete_Click;
            this.btnCall.Click += btnCall_Click;
            this.btnPlayer.Click += btnPlayer_Click;
            this.btnClose.Click += btnClose_Click;
            this.tabControlEx1.SelectedIndexChanged += tabControlEx1_SelectedIndexChanged;
            this.ucPager_ClientOrder.EventPaging += UcPagerEx1_EventPaging;
        }

        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmCustomerCalls_Shown(object sender, EventArgs e)
        {
            this.btnDelete.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.CustomerCallsCompetence, CustomAttributes.OperatingAuthority.Delete);
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        {
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDelete_Click(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (this.dgvData.CurrentRow == null)
                { MessageBoxCustom.Show("请选中你要录音回放的数据！"); return; }
                if (this.dgvData.CurrentRow.Index >= 0 && this.dgvData.CurrentCell.RowIndex >= 0)
                {
                    if (!string.IsNullOrEmpty(this.dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim()))
                    {
                        if (MessageBoxCustom.Show("您确定删除吗？", "温馨提示！", MessageBoxButtons.YesNo) == DialogResult.No)
                        { return; }
                        if (cwbll.Delete(Convert.ToInt32(this.dgvData.CurrentRow.Cells["ID"].Value)))
                        {
                            string logsContent = "删除客户来电电话号码：" + this.dgvData.CurrentRow.Cells["电话"].Value.ToString();
                            LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除电话记录, logsContent, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                            MessageBoxCustom.Show("删除成功！"); this.dgvData.Rows.Remove(this.dgvData.CurrentRow);
                        }
                        else
                        { MessageBoxCustom.Show("删除失败！"); }
                    }
                }
            }
        }
        /// <summary>
        /// 呼叫
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnCall_Click(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (this.dgvData.CurrentRow == null)
                { MessageBoxCustom.Show("请选中你要录音回放的数据！"); return; }
                if (this.dgvData.CurrentRow.Index >= 0 && this.dgvData.CurrentCell.RowIndex >= 0)
                {
                    if (!string.IsNullOrEmpty(this.dgvData.CurrentRow.Cells["电话"].Value.ToString().Trim()))
                    {
                        LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.PhoneCall(this.dgvData.CurrentRow.Cells["电话"].Value.ToString().Trim());
                    }
                    else
                    { MessageBoxCustom.Show("选择的通话记录电话号码为空！"); }
                }
            }
        }
        /// <summary>
        /// 录音回放
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnPlayer_Click(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            {
                if (this.dgvData.CurrentRow == null)
                { MessageBoxCustom.Show("请选中你要录音回放的数据！"); return; }
                if (this.dgvData.CurrentRow.Index >= 0 && this.dgvData.CurrentCell.RowIndex >= 0)
                {
                    if (!string.IsNullOrEmpty(this.dgvData.CurrentRow.Cells["路径"].Value.ToString().Trim()))
                    {
                        //播放
                        FrmPlayer set = new FrmPlayer();
                        set.Path = this.dgvData.CurrentRow.Cells["路径"].Value.ToString().Trim();
                        set.ShowDialog();
                    }
                    else
                    { MessageBoxCustom.Show("选择的通话记录未录音！"); }
                }
            }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 选项卡选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void tabControlEx1_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 分页前数据，便于展开时用来查询订单的子数据
        /// </summary>
        DataTable tblMianSelectData = new DataTable();
        /// <summary>
        /// 创建行
        /// </summary>
        private void PublicFunctionRows()
        {
            this.UcPagerEx1.EventPaging -= UcPagerEx1_EventPaging;
            this.UcPagerEx1.EventPaging += UcPagerEx1_EventPaging;
            this.UcPagerEx1.PageCurrent = 1;
            this.UcPagerEx1.PageSize = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();//3;分页条数
            this.UcPagerEx1.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        int UcPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            pageData.TableName = GetTableName_Main();
            pageData.PageIndex = this.UcPagerEx1.PageCurrent;
            pageData.PageSize = this.UcPagerEx1.PageSize;
            pageData.QueryCondition = GetWhereStr();
            pageData.OrderStr = "时间";
            pageData.OrderType = 1;
            string StrTabName = this.tabControlEx1.SelectedTab.Name.Trim();

            this.dgvData.dgvGuidName = GetGuidName();
            this.dgvData.dgvUserEmployeeID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
            this.dgvData.dgvFixedHideColumn = "ID,路径";
            this.dgvData.dgvCurrentColumnOriginalSet = GetFieldName();
            pageData.QueryFieldName = this.dgvData.dgvSetColumnName();
            if (string.IsNullOrEmpty(pageData.QueryFieldName))
            { pageData.QueryFieldName = this.dgvData.dgvCurrentColumnOriginalSet; }

            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                this.tblMianSelectData = pageData.QueryDataTable().Tables[0];
                try
                {
                    this.Invoke(new LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.UpdateControl(delegate()
                    {
                        this.dgvData.DataSource(this.tblMianSelectData);
                        this.dgvData.FillLastColumn(true);
                    }));
                }
                catch
                { }
            });
            try
            {
                this.UcPagerEx1.TbDataSource = this.tblMianSelectData;
                this.dgvData.Columns["时间"].Width = 110;
                this.dgvData.ColumnHeaderMouseDoubleClick -= dgvData_ColumnHeaderMouseDoubleClick;
                this.dgvData.ColumnHeaderMouseDoubleClick += dgvData_ColumnHeaderMouseDoubleClick;
            }
            catch { }
            this.dgvData.ClearSelection();
            return pageData.TotalCount;
        }
        /// <summary>
        /// 列表双击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {

        }
        /// <summary>
        /// 查询要获取的字段
        /// </summary>
        /// <returns></returns>
        private string GetGuidName()
        {
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ClientOrder":
                    return LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0035.ToString().Trim();
                case "tabPage_ClientOld":
                    return LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0036.ToString().Trim();
                case "tabPage_ClientIntent":
                    return LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0037.ToString().Trim();
                case "tabPage_ClientOther":
                    return LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0038.ToString().Trim();
                case "tabPage_ClientUser":
                    return LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0039.ToString().Trim();
                default: return "";
            }
        }
        /// <summary>
        /// 查询要获取的字段
        /// </summary>
        /// <returns></returns>
        private string GetFieldName()
        {
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ClientOrder":
                    return "";
                case "tabPage_ClientOld":
                    return "";
                case "tabPage_ClientIntent":
                    return "";
                case "tabPage_ClientOther":
                    return "";
                case "tabPage_ClientUser":
                    return "ID,姓名,电话,时间,路径";
                default: return "";
            }
        }
        /// <summary>
        /// 返回要操作的条件
        /// </summary>
        /// <returns></returns>
        private string GetWhereStr()
        {
            string StrWhere = " 1=1 ";
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ClientOrder":
                    StrWhere += "";
                    break;
                case "tabPage_ClientOld":
                    StrWhere += "";
                    break;
                case "tabPage_ClientIntent":
                    StrWhere += "";
                    break;
                case "tabPage_ClientOther":
                    StrWhere += "";
                    break;
                case "tabPage_ClientUser":
                    StrWhere += " And 状态 = '拨出电话'";
                    if (this.txtQuery.Text.Trim() != "")
                    { StrWhere += " And (姓名 like '%" + this.txtQuery.Text.Trim() + "%' or 电话 like '%" + this.txtQuery.Text.Trim() + "%')"; }
                    break;
            }
            return StrWhere;
        }
        /// <summary>
        /// 返回要操作的数据表
        /// </summary>
        /// <returns></returns>
        private string GetTableName_Main()
        {
            switch (this.tabControlEx1.SelectedTab.Name.Trim())
            {
                case "tabPage_ClientOrder":
                    return "";
                case "tabPage_ClientOld":
                    return "";
                case "tabPage_ClientIntent":
                    return "";
                case "tabPage_ClientOther":
                    return "";
                case "tabPage_ClientUser":
                    return "BView_CallsElves_UserCalls";
                default: return "";
            }
        }
        /// <summary>
        /// 定义列表属性
        /// </summary>
        public LYFZ.ComponentLibrary.DataGridViewEc dgvData
        {
            get
            {
                switch (this.tabControlEx1.SelectedTab.Name.Trim())
                {
                    case "tabPage_ClientOrder":
                        return this.dgvData_ClientOrder;
                    case "tabPage_ClientOld":
                        return this.dgvData_ClientOld;
                    case "tabPage_ClientIntent":
                        return this.dgvData_ClientIntent;
                    case "tabPage_ClientOther":
                        return this.dgvData_ClientOther;
                    case "tabPage_ClientUser":
                        return this.dgvData_ClientUser;
                    default: return this.dgvData_ClientOrder;
                }
            }
            set
            {
                switch (this.tabControlEx1.SelectedTab.Name.Trim())
                {
                    case "tabPage_ClientOrder":
                        this.dgvData_ClientOrder = value;
                        break;
                    case "tabPage_ClientOld":
                        this.dgvData_ClientOld = value;
                        break;
                    case "tabPage_ClientIntent":
                        this.dgvData_ClientIntent = value;
                        break;
                    case "tabPage_ClientOther":
                        this.dgvData_ClientOther = value;
                        break;
                    case "tabPage_ClientUser":
                        this.dgvData_ClientUser = value;
                        break;
                }
            }
        }
        /// <summary>
        /// 定义分页控件属性
        /// </summary>
        public LYFZ.UCPager.ucPagerEx UcPagerEx1
        {
            get
            {
                switch (this.tabControlEx1.SelectedTab.Name.Trim())
                {
                    case "tabPage_ClientOrder":
                        return this.ucPager_ClientOrder;
                    case "tabPage_ClientOld":
                        return this.ucPager_ClientOld;
                    case "tabPage_ClientIntent":
                        return this.ucPager_ClientIntent;
                    case "tabPage_ClientOther":
                        return this.ucPager_ClientOther;
                    case "tabPage_ClientUser":
                        return this.ucPager_ClientUser;
                    default: return this.ucPager_ClientOrder;
                }
            }
            set
            {
                switch (this.tabControlEx1.SelectedTab.Name.Trim())
                {
                    case "tabPage_ClientOrder":
                        this.ucPager_ClientOrder = value;
                        break;
                    case "tabPage_ClientOld":
                        this.ucPager_ClientOld = value;
                        break;
                    case "tabPage_ClientIntent":
                        this.ucPager_ClientIntent = value;
                        break;
                    case "tabPage_ClientOther":
                        this.ucPager_ClientOther = value;
                        break;
                    case "tabPage_ClientUser":
                        this.ucPager_ClientUser = value;
                        break;
                }
            }
        }









        //string type;
        //#region 加载数据
        //protected override void FrmOutgoingCalls_Shown(object sender, EventArgs e)
        //{
           

        //    try
        //    {
        //        type = "5";
        //        GvDataBind();

        //        #region 权限设置
        //        #region  删除拨出电话
        //        if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.OutgoingCallsCompetence, CustomAttributes.OperatingAuthority.Delete))
        //        {
        //            btnDelete.Enabled = true;
        //        }
        //        else
        //        {
        //            btnDelete.Enabled = false;
        //        }
        //        #endregion
        //        #endregion
                
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageBoxCustom.Show(ex.Message);
        //    }
        //}
        //#endregion

        //#region 获取客户来电
        //protected override void btnCustomerCalls_Click(object sender, EventArgs e)
        //{
            
        //    try
        //    {
        //        type = "1";
        //        GvDataBind();
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageBoxCustom.Show(ex.Message);
        //    }
        //}
        //#endregion

        //#region 获取老客户来电
        //protected override void btnOldCustomers_Click(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        type = "2";
        //        GvDataBind();
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageBoxCustom.Show(ex.Message);
        //    }
        //}

        //#region  获取老客户来电
        //public void bindOldCustomers()
        //{
        //    dgv.Rows.Clear();
        //    dgv.Columns["Cus_Name"].Visible = true;
        //    dgv.Columns["Sex"].Visible = true;
        //    LYFZ.BLL.BLL_ErpCallWizard cabll = new BLL.BLL_ErpCallWizard();
        //    LYFZ.BLL.BLL_ErpCustomer cubll = new BLL.BLL_ErpCustomer();
        //    DataTable dt = new DataTable();
        //    string keyword = txtQuery.Text;

        //    #region  获取来电精灵号码
        //    if (!string.IsNullOrEmpty(keyword))
        //    {
        //        dt = cabll.GetView_tb_ErpCallWizard("(Callw_Status='拨出电话' and Cus_Type='老客户') and (Cus_Name like '%" + keyword + "%' or dbo.tb_Product(Cus_Name) like '%" + keyword + "%' or Cus_Telephone like '%" + keyword + "%') order by tb_ErpCallWizard.Id desc").Tables[0];
        //    }
        //    else { dt = cabll.GetView_tb_ErpCallWizard("Callw_Status='拨出电话' and Cus_Type='老客户' order by tb_ErpCallWizard.Id desc").Tables[0]; }

        //    for (int i = 0; i < dt.Rows.Count; i++)
        //    {
        //        DataGridViewRow dgvr = new DataGridViewRow();
        //        DataGridViewCell cell = null;

        //        cell = new DataGridViewTextBoxCell();
        //        cell.Value = dt.Rows[i]["ID"].ToString().Trim(); ;
        //        dgvr.Cells.Add(cell);


        //        cell = new DataGridViewTextBoxCell();
        //        cell.Value = dt.Rows[i]["Cus_Name"].ToString().Trim();
        //        dgvr.Cells.Add(cell);

        //        cell = new DataGridViewTextBoxCell();
        //        if (Convert.ToBoolean(dt.Rows[i]["Cus_Sex"].ToString().Trim()) == false)
        //        {
        //            cell.Value = "男";
        //        }
        //        else { cell.Value = "女"; }
        //        dgvr.Cells.Add(cell);

        //        cell = new DataGridViewTextBoxCell();
        //        cell.Value = dt.Rows[i]["Callw_Telephone"].ToString(); ;
        //        dgvr.Cells.Add(cell);

        //        cell = new DataGridViewTextBoxCell();
        //        cell.Value = dt.Rows[i]["Callw_DateTime"].ToString(); ;
        //        dgvr.Cells.Add(cell);

        //        this.dgv.Rows.Add(dgvr);
        //    }

        //    #endregion


        //}
        //#endregion
        //#endregion

        //#region 获取意向客户
        //protected override void btnIntentionOfCustomers_Click(object sender, EventArgs e)
        //{

        //    try
        //    {
        //        type = "3";
        //        GvDataBind();
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageBoxCustom.Show(ex.Message);
        //    }
        //}

        
        //#endregion

        //#region 获取员工电话
        //protected override void btnStaffPhone_Click(object sender, EventArgs e)
        //{

           
        //}

        
        //#endregion

        //#region 获取其它电话
        //protected override void btnOtherPhone_Click(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        type = "4";
        //        GvDataBind();
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageBoxCustom.Show(ex.Message);
        //    }
        //}
        //#endregion

        //#region 删除
        //protected override void btndelete_Click(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        if (this.dgv.SelectedRows.Count == 0)
        //        {
        //            MessageBoxCustom.Show("请选中你要删除的数据！");
        //            return;
        //        }
        //        if (MessageBoxCustom.Show("你确定要删除吗？", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
        //        {
        //            LYFZ.BLL.BLL_ErpCallWizard bll = new BLL.BLL_ErpCallWizard();
        //            int id = Convert.ToInt32(this.dgv.CurrentRow.Cells["ID"].Value);
        //            if (bll.Delete(id) == true)
        //            {
        //                #region 写入操作日志
        //                string logsContent = "删除拨出电话号码：" + dgv.CurrentRow.Cells["Callw_Telephone"].Value.ToString();
        //                LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除电话记录, logsContent, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
        //                //LYFZ.BLL.BLL_ErpSystemLogs systemLogsBll = new BLL.BLL_ErpSystemLogs();
        //                //LYFZ.Model.Model_ErpSystemLogs systemLogsModel = new Model.Model_ErpSystemLogs();
        //                //systemLogsModel.Slogs_Type = "user";
        //                //systemLogsModel.Slogs_Topic = "删除拨出电话";
        //                //systemLogsModel.Slogs_Content = "删除拨出电话号码：" + dgv.CurrentRow.Cells["Callw_Telephone"].Value.ToString();
        //                //systemLogsModel.Slogs_UserName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
        //                //systemLogsModel.Slogs_IP = "";
        //                //systemLogsModel.Slogs_CreateDatetime =  LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
        //                //systemLogsModel.Slogs_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
        //                //systemLogsBll.Add(systemLogsModel);
        //                #endregion

        //                MessageBoxCustom.Show("删除成功！");
        //                GvDataBind();
        //            }
        //            else { MessageBoxCustom.Show("删除失败！"); }
        //        }
        //    }
        //    catch (Exception ex) { MessageBoxCustom.Show(ex.Message); }
        //}
        //#endregion

        //#region 关闭
        //protected override void btnClose_Click(object sender, EventArgs e)
        //{
        //    this.Close();
        //}
        //#endregion

        //#region 录音回放
        //protected override void btnRecordingPlayback_Click(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        if (this.dgv.SelectedRows.Count == 0)
        //        {
        //            MessageBoxCustom.Show("请选中你要录音回放的数据！");
        //            return;
        //        }

        //        LYFZ.BLL.BLL_ErpCallWizard bll = new BLL.BLL_ErpCallWizard();
        //        int id = Convert.ToInt32(this.dgv.CurrentRow.Cells["ID"].Value);
        //        DataTable dt = bll.GetList("ID=" + id + "").Tables[0];
        //        if (dt.Rows.Count > 0)
        //        {
        //            string Callw_SoundRecording = dt.Rows[0]["Callw_SoundRecording"].ToString();
        //            if (!string.IsNullOrEmpty(Callw_SoundRecording))
        //            {
        //                //播放
        //                FrmPlayer set = new FrmPlayer();
        //                set.Path = Callw_SoundRecording;
        //                set.ShowDialog();
        //            }
        //            else { MessageBoxCustom.Show("文件未找到！"); }
        //        }

        //    }
        //    catch (Exception ex) { MessageBoxCustom.Show(ex.Message); }
        //}
        //#endregion


    }
}