customeredit.ascx.cs

CRM管理系统 CRM管理系统

        }
        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 > 5)
        {
            msg += "最多上传５个附件\\r\\n";
        }
        if (msg == String.Empty)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        ComId = Convert.ToInt32(Request.QueryString["code"]);
        if (!(CheckData()))
        {
            ShowMessage(msg);
            return;
        }
        if (SubmitData())
        {
            ShowMessage("信息提交成功！");
            Response.Redirect("CustomerManage.aspx");
        }
        else
        {
            ShowMessage("信息提交失败！");
            return;
        }
    }
    /// <summary>
    /// 数据提交操作
    /// </summary>
    /// <returns></returns>
    protected bool SubmitData()
    {
        if (!UploadFiles())
        {
            return false;
        }
        String relation;
        String type;
        String industry;
        String source;
        String district;
        String province;
        String property;
        String customer_size;
        String tracking_persen;
        String is_use;

        String name = txtComName.Text.Trim().Replace("'", "\"");
        if (ddlRelation.SelectedIndex > 0)
        {
            relation = ddlRelation.SelectedValue;
        }
        else
        {
            relation = "";
        }
        if (ddlComType.SelectedIndex > 0)
        {
            type = ddlComType.SelectedValue;
        }
        else
        {
            type = "";
        }
        if (ddlWay.SelectedIndex > 0)
        {
            industry = ddlWay.SelectedValue;
        }
        else
        {
            industry = "";
        }
        if (ddlComResource.SelectedIndex > 0)
        {
            source = ddlComResource.SelectedValue;
        }
        else
        {
            source = "";
        }
        if (ddlnation.SelectedIndex > 0)
        {
            district = ddlnation.SelectedValue;
        }
        else
        {
            district = "";
        }
        if (ddlCity.SelectedIndex > 0)
        {
            province = ddlCity.SelectedValue;
        }
        else
        {
            province = "";
        }
        if (ddlCity.SelectedIndex > 0)
        {
            province = ddlCity.SelectedValue;
        }
        else
        {
            province = "";
        }
        if (ddlCompanyType.SelectedIndex > 0)
        {
            property = ddlCompanyType.SelectedValue;
        }
        else
        {
            property = "";
        }
        if (ddlCompanySize.SelectedIndex > 0)
        {
            customer_size = ddlCompanySize.SelectedValue;
        }
        else
        {
            customer_size = "";
        }
        String tel = this.txtCompanyTel.Text.Trim().Replace("'", "\"");
        String fax = this.txtFax.Text.Trim().Replace("'", "\"");
        String zip = this.txtZip.Text.Trim().Replace("'", "\"");
        String address = this.txtAdress.Text.Trim().Replace("'", "\"");
        String email = this.txtEmail.Text.Trim().Replace("'", "\"");
        String homepage = this.txtHomePage.Text.Trim().Replace("'", "\"");

        String note = this.txtRemark.Text.Trim().Replace("'", "\"");
        if (ddlTrack.SelectedIndex > 0)
        {
            tracking_persen = ddlTrack.SelectedValue;
        }
        else
        {
            tracking_persen = "";
        }
        //String writer = this.CurrentUser.user_id;
        if (ddlIsUse.SelectedIndex > 0)
        {
            is_use = ddlIsUse.SelectedValue;
        }
        else
        {
            is_use = "";
        }
        String organization = this.lblAcc.Text.Trim().Replace("'", "\"");

        String sql = "Update ITSV_CustomerManager set  name = '" + name + "', relation = '" + relation + "', type = '" + type + "', industry = '" + industry + "',";
             sql += "source = '" + source + "', district = '" + district + "', province = '" + province + "', property = '" + property + "',";
             sql += "customer_size = '" + customer_size + "', tel = '" + tel + "',  fax = '" + fax + "', zip = '" + zip + "', address = '" + address + "',";
             sql += "email = '" + email + "', homepage = '" + homepage + "',organization = '" + organization + "',";
             sql += "note = '" + note + "', tracking_persen =  '" + tracking_persen + "', is_use = " + is_use + " ";
             sql += " where code = " + ComId + " ";
        bool falg = dataport.ExeSql(sql);
        if (falg)
        {
            this.WriteUserAction("修改客户\"" + name + "\"资料");
            return true;
        }
        else
        {
            return false;
        }
    }
    /// <summary>
    /// 取消操作
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("CustomerManage.aspx");
    }
    /// <summary>
    /// 不允许上传的文件类型
    /// </summary>
    /// <param name="exten"></param>
    /// <returns></returns>
    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;
    }
    /// <summary>
    /// 多文件上传
    /// </summary>
    /// <returns></returns>
    private bool UploadFiles()
    {
        HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;

        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);
                        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;
    }
    #region DataList事件
    protected void dtlAccList_ItemCommand(object source, DataListCommandEventArgs e)
    {
        ComId = Convert.ToInt32(Request.QueryString["code"]);
        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_CustomerManager set organization = '" + document.Replace("\'", "\"") + "' WHERE (code = " + ComId + ")";
            if (!dataport.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
}