customeradd.ascx.cs

CRM管理系统 CRM管理系统

                    {
                        msg += fileName + "文件大小超过了上传的最大值:10240k";
                    }
                    else
                    {
                        accCount++;
                    }
                }
                else
                {
                    msg += "文件路径不正确\\r\\n";
                }
            }
        }
        if (accCount > 5)
        {
            msg += "最多上传５个附件\\r\\n";
        }

        if (IsExistCustomName(txtComName.Text.Trim().Replace("'", "\"")))
        {
            msg += "客户名称已经存在，请更换客户名称\\r\\n";
        }

        if (msg == String.Empty)
        {
            return true;
        }
        return false;
    }

    /// <summary>
    /// 验证用户名是否存在
    /// </summary>
    /// <param name="custName"></param>
    /// <returns></returns>
    private bool IsExistCustomName(string custName)
    {
        string sql = "select count(*) from ITSV_CustomerManager where name = '" + custName + "'";
        string count = dataport.GetRowResultID(sql);
        if (count == null || count == string.Empty)
            return true;
        if (int.Parse(count) > 0)
            return true;
        else
            return false;
    }

    /// <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("信息提交成功！");
            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.ToString();
        if (ddlIsUse.SelectedIndex > 0)
        {
            is_use = ddlIsUse.SelectedValue;
        }
        else
        {
            is_use = "";
        }
        String organization = this.lblAcc.Text.Trim().Replace("'", "\"");

        String sql = @"INSERT INTO ITSV_CustomerManager
                              (name, relation, type, industry, source, district, province, property, customer_size, tel, 
                              fax, zip, address, email, homepage, organization,note, tracking_persen, writer, is_use)
                        VALUES ('" + name + "', '" + relation + "', '" + type + "', '" + industry + "', '" + source + "', '" + district + "', '" + province + "', '" + property + "', '" + customer_size + "', '" + tel + "', '" + fax + "', '" + zip + "', '" + address + "', '" + email + "', '" + homepage + "', '" + organization + "', '" + note + "', " + tracking_persen + ", '" + writer + "'," + is_use + ")";

        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;
    }
}