coneditctrl.ascx.cs

CRM管理系统 CRM管理系统

    #region 数据验证
    /// <summary>
    /// 数据验证
    /// </summary>
    /// <returns></returns>
    private bool CheckData()
    {
        this.msg = "";
        if (ddlCustomNo.SelectedItem == null || ddlCustomNo.SelectedIndex <= 0)
            msg += "请选择客户编号\\r\\n";
        if (ddlCustPerson.SelectedItem == null || ddlCustPerson.SelectedIndex == 0)
            msg += "客户人员不能为空\\r\\n";
        if (txtTitle.Text.Trim().Length == 0)
            msg += "联络主题不能为空\\r\\n";
        if (ddlConType.SelectedItem == null || ddlConType.SelectedIndex == 0)
            msg += "请选择联络方式\\r\\n";
        if (ddlConPriod.SelectedItem == null || ddlConPriod.SelectedIndex == 0)
            msg += "请选择联络阶段\\r\\n";
        if (ddlAndItem.SelectedItem == null || ddlAndItem.SelectedIndex == 0)
            msg += "请选择相关项目\\r\\n";
        if (txtConMoney.Text.Trim().Length == 0)
            msg += "联络费用不能为空\\r\\n";
        else if (!IsNuberic(txtConMoney.Text.Trim()))
            msg += "联络费用必须为数字\\r\\n";
        else if (Convert.ToDouble(txtConMoney.Text.Trim()) < 0)
            msg += "联络费用必须为大于等于０的数字\\r\\n";

        if (ddlPerson.SelectedItem == null || ddlPerson.SelectedIndex == 0)
            msg += "请选择我方人员\\r\\n";
        if (txtDateTime.Text.Trim().Length == 0)
            msg += "联络日期不能为空\\r\\n";
        else if (!IsDate(txtDateTime.Text.Trim()))
            msg += "联络日期格式不正确\\r\\n";

        if (txtContent.Value.Trim().Length == 0)
            msg += "联络内容不能为空\\r\\n";
        if (txtNote.Value.Trim().Length > 250)
            msg += "备注最大长度不能大于250个汉字和250个字符\\r\\n";

        HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;
        int accCount = 0;
        for (int i = 0; i < files.Count; i++)
        {
            HttpPostedFile postFile = files[i];

            if (postFile.FileName.Trim().Length > 0)
            {
                string fileName, fileExtension;
                fileName = System.IO.Path.GetFileName(postFile.FileName);
                if (fileName != "")
                {
                    fileExtension = System.IO.Path.GetExtension(fileName).Replace(".","");
                    if (!CheckExtension(fileExtension))
                    {
                        msg += "存在不允许上传的文件类型：" + fileExtension + "\\r\\n";
                    }
                    else if (postFile.ContentLength > 10240000)
                    {
                        msg += fileName + "文件大小超过了上传的最大值:10240k";
                    }
                    else
                    {
                        accCount++;
                    }
                }
                else
                {
                    msg += "文件路径不正确\\r\\n";
                }
            }
        }
        if (accCount + dtlAccList.Items.Count > 5)
            msg += "最多上传５个附件\\r\\n";


        if (msg != "")
        {
            return false;
        }
        return true;
    }

    private bool CheckExtension(string exten)
    {
        ArrayList array = new ArrayList();
        array.Add("doc");
        array.Add("txt");
        array.Add("jpg");
        array.Add("gif");
        array.Add("ppt");
        array.Add("csv");
        array.Add("xls");
        array.Add("rar");
        array.Add("zip");
        array.Add("docx");

        foreach (string str in array)
        {
            if (exten == str)
            {
                return true;
            }
        }

        return false;
    }
    #endregion

    #region 数据保存
    /// <summary>
    /// 数据提交
    /// </summary>
    /// <returns></returns>
    private bool SubmitData()
    {
        if (!UploadFiles())
        {
            return false;
        }

        String customNo = ddlCustomNo.SelectedValue.Split(',')[0];
        string customName = ddlCustPerson.SelectedValue.Replace("'", "\"");
        string conTitle = txtTitle.Text.Trim().Replace("'", "\"");
        string conType = ddlConType.SelectedValue;
        string conPriod = ddlConPriod.SelectedValue;
        string andItem = ddlAndItem.SelectedValue;
        double conMoney = Convert.ToDouble(txtConMoney.Text.Trim());
        long userid = Convert.ToInt64(ddlPerson.SelectedValue);
        DateTime dateTime = DateTime.Parse(txtDateTime.Text.Trim());
        string conContent = txtContent.Value.Trim().Replace("'", "\"");
        string note = txtNote.Value.Trim().Replace("'", "\"");
        string document = lblAcc.Text;

        System.Text.StringBuilder sql = new System.Text.StringBuilder(@"UPDATE ITSV_CustomerContract SET");
        sql.Append(" customer_id ='" + customNo + "',");
        sql.Append(" customer_person_id ='" + customName + "',");
        sql.Append(" title ='" + conTitle + "',");
        sql.Append(" type ='" + conType + "',");
        sql.Append(" period ='" + conPriod + "',");
        sql.Append(" project ='" + andItem + "',");
        sql.Append(" money ='" + conMoney + "', ");
        sql.Append(" contract_person ='" + userid + "',");
        sql.Append(" contract_time ='" + dateTime.ToShortDateString() + "', ");
        sql.Append(" content ='" + conContent + "',");
        sql.Append(" note ='" + note + "', ");
        sql.Append(" document ='" + document + "'");
        sql.Append(" where code = " + code);

        if (dp.ExeSql(sql.ToString()))
        {
            this.WriteUserAction("修改联络\"" + conTitle + "\"");
            return true;
        }

        msg += "数据提交失败，请您重试!!\\r\\n";
        return false;
    }

    /// <summary>
    /// 多文件上传
    /// </summary>
    /// <returns></returns>
    private bool UploadFiles()
    {
        HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;

        if(!System.IO.Directory.Exists(Server.MapPath("~/upload/")))
        {
            System.IO.Directory.CreateDirectory(Server.MapPath("~/upload/"));
        }

        System.Random rand = new Random(DateTime.Now.Millisecond);
        string result = "";
        for (int i = 0; i < files.Count; i++)
        {
            HttpPostedFile postFile = files[i];

            if (postFile.FileName.Trim().Length > 0)
            {
                int seed = rand.Next(1000, 9999);
                string fileName, fileExtension;
                fileName = System.IO.Path.GetFileName(postFile.FileName);
                if (fileName != "")
                {
                    try
                    {
                        fileExtension = System.IO.Path.GetExtension(fileName).Replace(".", "");
                        string uploadName = "" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + seed + "." + fileExtension;
                        postFile.SaveAs(Server.MapPath("~/upload/") + uploadName);
                        result += "[" + fileName + "]" + uploadName + "|";
                    }
                    catch
                    {
                        msg += fileName + "上传失败\\r\\n";
                        return false;
                    }
                }
            }
        }
        this.lblAcc.Text += result;
        return true;
    }
    #endregion

    #region DataList事件
    protected void dtlAccList_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "lbtnDelete")
        {
            string document = "";
            foreach (DataListItem item in dtlAccList.Items)
            {
                if (item.ItemIndex != e.Item.ItemIndex)
                {
                    string fileName = ((Label)item.FindControl("lblDocumentName")).Text;
                    string uploadName = ((Label)item.FindControl("lblDocumentPath")).Text;
                    document += "" + fileName + "" + uploadName + "|";
                }
            }

            string sql = "update ITSV_CustomerContract set document = '" + document.Replace("\'", "\"") + "' WHERE (code = " + code + ")";
            if (!dp.ExeSql(sql))
            {
                ShowMessage("数据删除错误，请您重试");
                return;
            }
            lblAcc.Text = document;
            BindDtlAccList(document);
        }
    }
    protected void dtlAccList_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            LinkButton lbtnDelete = (LinkButton)e.Item.FindControl("lbtnDelete");
            if (lbtnDelete != null)
            {
                lbtnDelete.Attributes.Add("onclick", "return confirm('您确实要删除此附件吗？');");
            }
        }
    }
    #endregion

    #region 提交按钮事件
    /// <summary>
    /// 提交按钮事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (!CheckData())
        {
            ShowMessage(msg);
            return;
        }

        if (!SubmitData())
        {
            ShowMessage(msg);
        }
        else
        {
            ShowAndClose("数据提交成功!!", "window.opener.location='ConIndex.aspx';");
        }
    }
    #endregion

    protected void ddlCustomNo_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlCustomNo.SelectedItem != null && ddlCustomNo.SelectedIndex != 0)
        {
            string coutId = ddlCustomNo.SelectedValue;
            BindCustPerson(coutId);
        }

    }
}