protected void btnCusDetailUpDown_Click(object sender, EventArgs e)
    {
        CRM_CUST c_cust = new CRM_CUST();

        c_cust.Cus_ID    = Convert.ToInt32(txt_cus_id.Value);
        c_cust.Email     = page_Email.Value;
        c_cust.Phone     = page_Phone.Value;
        c_cust._Cus_Name = page_Cus_Name.Value;
        BLLTable <CRM_CUST> .Factory(conn).Update(c_cust, CRM_CUST.Attribute.Cus_ID);

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();

        c_customer.Cus_Id         = Convert.ToInt32(txt_cus_id.Value);
        c_customer.CompanyAddress = page_CompanyAddress.Value;
        c_customer.CompanyName    = page_CompanyName.Value;
        c_customer.ShopName       = page_ShopName.Value;
        c_customer.ShopNameURL    = page_ShopNameURL.Value;
        c_customer.WangWangId     = page_WangWangId.Value;
        c_customer.CustQQ         = page_CustQQ.Value;
        BLLTable <CRM_CUSTOMER> .Factory(conn).Update(c_customer, CRM_CUSTOMER.Attribute.Cus_Id);

        lit_CompanyAddress.Text = page_CompanyAddress.Value;
        lit_CompanyName.Text    = page_CompanyName.Value;
        lit_ShopName.Text       = page_ShopName.Value;
        lit_ShopNameURL.Text    = page_ShopNameURL.Value;
        lit_WangWangId.Text     = page_WangWangId.Value;
        lit_CustQQ.Text         = page_CustQQ.Value;
        lit_Phone.Text          = page_Phone.Value;
        lit_Email.Text          = page_Email.Value;
        lit_Cus_Name.Text       = page_Cus_Name.Value;
    }
示例#2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["DelKeyID"] != null)
        {
            int re = BLLTable<CRM_CUST>.Factory(conn).Delete(CRM_CUST.Attribute.Cus_ID, Request["DelKeyID"]);
            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        if (Request["DelKeyIDS"] != null)
        {
            CRM_CUST cond = new CRM_CUST();
            cond.In(CRM_CUST.Attribute.Cus_ID, Request["DelKeyIDS"]);
            int re = BLLTable<CRM_CUST>.Factory(conn).Delete(cond);
            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }
        Response.End();
    }
示例#3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(Request["ProID"]))
        {
            proid = Convert.ToInt32(Request["ProID"]);
        }
        if (!IsPostBack)
        {
            //this.Master.SetGoBackLink("ProCusNew.aspx?ProID=" + proid);
            if (!String.IsNullOrEmpty(this.Request["CusID"]))
            {
                try
                {
                    CRM_CUST entity = new CRM_CUST();
                    entity.Cus_ID = Convert.ToInt32(this.Request["CusID"]);
                    entity = BLLTable<CRM_CUST>.Factory(conn).GetRowData(entity);

                    txtCustomer_Name.Value = entity.Cus_Name;
                    txtJob.Value = entity.Job;
                    txtRelationTxt.Value = entity.RelationTxt;
                }
                catch (Exception ex)
                {
                    //PageHelper.Error(Page, ex);
                }
            }
        }
    }
示例#4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["DelKeyID"] != null)
        {
            int re = BLLTable <CRM_CUST> .Factory(conn).Delete(CRM_CUST.Attribute.Cus_ID, Request["DelKeyID"]);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        if (Request["DelKeyIDS"] != null)
        {
            CRM_CUST cond = new CRM_CUST();
            cond.In(CRM_CUST.Attribute.Cus_ID, Request["DelKeyIDS"]);
            int re = BLLTable <CRM_CUST> .Factory(conn).Delete(cond);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }
        Response.End();
    }
示例#5
0
 protected void btnOK_Click(object sender, EventArgs e)
 {
     try
     {
         if (txtCustomer_Name.Value != "")
         {
             CRM_CUST entity = new CRM_CUST();
             entity.Cus_Name = txtCustomer_Name.Value;
             entity.Job = txtJob.Value;
             entity.RelationTxt = txtRelationTxt.Value;
             try
             {
                 if (!String.IsNullOrEmpty(this.Request["type"]) && !String.IsNullOrEmpty(this.Request["CusID"]))
                 {
                     BLLTable<CRM_CUST>.Factory(conn).Update(entity, CRM_CUST.Attribute.Cus_ID);
                 }
                 else
                 {
                     BLLTable<CRM_CUST>.Factory(conn).Insert(entity, CRM_CUST.Attribute.Cus_ID);
                     Response.Redirect("CusList.aspx");
                 }
             }
             catch (Exception ex)
             {
                 //PageHelper.Error(Page, ex);
             }
         }
         else
             AgileFrame.Core.ScriptHelper.Alert(Page, "信息为空!");
     }
     catch
     {
         AgileFrame.Core.ScriptHelper.Alert(Page, "已经存在此客户!");
     }
 }
示例#6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(Request["ProID"]))
        {
            proid = Convert.ToInt32(Request["ProID"]);
        }
        if (!IsPostBack)
        {
            //this.Master.SetGoBackLink("ProCusNew.aspx?ProID=" + proid);
            if (!String.IsNullOrEmpty(this.Request["CusID"]))
            {
                try
                {
                    CRM_CUST entity = new CRM_CUST();
                    entity.Cus_ID = Convert.ToInt32(this.Request["CusID"]);
                    entity        = BLLTable <CRM_CUST> .Factory(conn).GetRowData(entity);

                    txtCustomer_Name.Value = entity.Cus_Name;
                    txtJob.Value           = entity.Job;
                    txtRelationTxt.Value   = entity.RelationTxt;
                }
                catch (Exception ex)
                {
                    //PageHelper.Error(Page, ex);
                }
            }
        }
    }
示例#7
0
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson<CRM_CUST>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
示例#8
0
 protected void aspPager_PageChanged(object sender, EventArgs e)
 {
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson <CRM_CUST>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
示例#9
0
 protected void btnSetPageSize_Click(object sender, EventArgs e)
 {
     aspPager.PageSize = int.Parse(txtPageSize.Value);
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson <CRM_CUST>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
示例#10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录
        if (Request["DelCus_ID"] != null)
        {
            int re = BLLTable <CRM_CUST> .Factory(conn).Delete(CRM_CUST.Attribute.Cus_ID, Request["DelCus_ID"]);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录
        if (Request["DelKeyIDS"] != null)
        {
            CRM_CUST cond = new CRM_CUST();
            cond.In(CRM_CUST.Attribute.Cus_ID, Request["DelKeyIDS"]);
            int re = BLLTable <CRM_CUST> .Factory(conn).Delete(cond);

            if (re > 0)
            {
                Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示
            }
            else
            {
                Response.Write("删除失败!");
            }
        }

        //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新
        if (Request["saveInfo"] != null)
        {
            CRM_CUST val = new CRM_CUST();
            val.Cus_ID = int.Parse(Request["FieldKeyID"]);
            List <AttributeItem> lstCol = val.af_AttributeItemList;
            for (int i = 0; i < lstCol.Count; i++)
            {
                if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
                {
                    val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]);
                }
            }

            BLLTable <CRM_CUST> .Factory(conn).Update(val, CRM_CUST.Attribute.Cus_ID);

            Response.Write("修改用户信息成功");
        }
        Response.End();
    }
示例#11
0
    protected void Page_Load(object sender, EventArgs e)
    {
        #region//默认隐藏的列
        //hideTableColumnList = new List<AttributeItem>();
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP1);
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP2);
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP3);
        //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要
        //valObj.Remove(hideTableColumnList);

        //hideFindColumnList = new List<AttributeItem>();
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP1);
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP2);
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP3);
        #endregion
        condObj.OrderBy(CRM_CUST.Attribute.Cus_ID, Order.Desc);

        if (!IsPostBack)
        {
            btnFind.Text              = LanguageService.GetLanguageString("btnFind", "查询");
            aspPager.PageSize         = 10;
            aspPager.CurrentPageIndex = 1;

            if (!string.IsNullOrEmpty(Request["ids"]))
            {
                CRM_CUST roleOld = new CRM_CUST();
                roleOld.Where(CRM_CUST.Attribute.Cus_ID, Request["ids"].ToString());
                listObj = BLLTable <CRM_CUST> .Factory(conn).Select(valObj, roleOld);

                for (int i = 0; i < listObj.Count; i++)
                {
                    if (i > 0)
                    {
                        hidOld.Value     += ",";
                        hidInitIDS.Value += ",";
                    }
                    hidOld.Value     += "{ID:'" + listObj[i].Cus_ID + "',Name:'" + listObj[i].Cus_ID + "'}";//这里的Name用于显示在列表中,请自行重定义。
                    hidInitIDS.Value += listObj[i].Cus_ID;
                }
            }
            try
            {
                listObj = BLLTable <CRM_CUST> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);

                repList.DataSource = listObj;
                repList.DataBind();
                aspPager.RecordCount = recount;
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }
示例#12
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
        if (Request["DelCus_ID"] != null)
        {
            int re = BLLTable<CRM_CUST>.Factory(conn).Delete(CRM_CUST.Attribute.Cus_ID, Request["DelCus_ID"]);
            if (re > 0)
            {
                Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
            }
            else
            {
                Response.Write("ɾ��ʧ�ܣ�");
            }
        }

        //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
        if (Request["DelKeyIDS"] != null)
        {
            CRM_CUST cond = new CRM_CUST();
            cond.In(CRM_CUST.Attribute.Cus_ID, Request["DelKeyIDS"]);
            int re = BLLTable<CRM_CUST>.Factory(conn).Delete(cond);
            if (re > 0)
            {
                Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
            }
            else
            {
                Response.Write("ɾ��ʧ�ܣ�");
            }
        }

        //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
        if (Request["saveInfo"] != null)
        {
            CRM_CUST val = new CRM_CUST();
            val.Cus_ID = int.Parse(Request["FieldKeyID"]);
            List<AttributeItem> lstCol = val.af_AttributeItemList;
            for (int i = 0; i < lstCol.Count; i++)
            {
                if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) {
                    val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]);
                }
            }

            BLLTable<CRM_CUST>.Factory(conn).Update(val, CRM_CUST.Attribute.Cus_ID);
            Response.Write("�޸��û���Ϣ�ɹ�");

        }
        Response.End();
    }
示例#13
0
    protected void aspPager_PageChanged(object sender, EventArgs e)
    {
        try
        {
            if (hidCondition.Value != "")
            {
                condObj = JsonServiceBase.FromJson <CRM_CUST>(hidCondition.Value);
            }
            listObj = BLLTable <CRM_CUST> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);

            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
示例#14
0
    private void BindList(CRM_CUST condObj, int curPage)
    {
        if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序
        {
            condObj.af_PageBy(CRM_CUST.Attribute.Cus_ID, Order.Desc);
        }

        #region//数据权限条件

        #endregion
        //condObj.PID = decimal.Parse(pid);

        listObj = BLLTable <CRM_CUST> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);

        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
示例#15
0
    protected void aspPager_PageChanged(object sender, EventArgs e)
    {
        try
        {
            if (hidCondition.Value != "")
            {
                condObj = JsonServiceBase.FromJson<CRM_CUST>(hidCondition.Value);
            }
            listObj = BLLTable<CRM_CUST>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);

            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
示例#16
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        try
        {
            if (txtCustomer_Name.Value != "")
            {
                CRM_CUST entity = new CRM_CUST();
                entity.Cus_Name    = txtCustomer_Name.Value;
                entity.Job         = txtJob.Value;
                entity.RelationTxt = txtRelationTxt.Value;
                try
                {
                    if (!String.IsNullOrEmpty(this.Request["type"]) && !String.IsNullOrEmpty(this.Request["CusID"]))
                    {
                        BLLTable <CRM_CUST> .Factory(conn).Update(entity, CRM_CUST.Attribute.Cus_ID);
                    }
                    else
                    {
                        BLLTable <CRM_CUST> .Factory(conn).Insert(entity, CRM_CUST.Attribute.Cus_ID);

                        Response.Redirect("CusList.aspx");
                    }
                }
                catch (Exception ex)
                {
                    //PageHelper.Error(Page, ex);
                }
            }
            else
            {
                ScriptHelper.Alert(Page, "信息为空!");
            }
        }
        catch
        {
            ScriptHelper.Alert(Page, "已经存在此客户!");
        }
    }
示例#17
0
    private void BindList(CRM_CUST condObj, int curPage)
    {
        if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
            condObj.af_PageBy(CRM_CUST.Attribute.Cus_ID, Order.Desc);

        #region//����Ȩ������

        #endregion
        //condObj.PID = decimal.Parse(pid);

        listObj = BLLTable<CRM_CUST>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
        repList.DataSource = listObj;
        repList.DataBind();
        aspPager.RecordCount = recount;
    }
示例#18
0
 protected void btnSetPageSize_Click(object sender, EventArgs e)
 {
     aspPager.PageSize = int.Parse(txtPageSize.Value);
     if (hidCondition.Value != "")
     {
         condObj = JsonServiceBase.FromJson<CRM_CUST>(hidCondition.Value);
     }
     BindList(condObj, aspPager.CurrentPageIndex);
 }
示例#19
0
    protected bool CheckTheSame()
    {
        if (string.IsNullOrEmpty(txt_addMobPhone.Value) && string.IsNullOrEmpty(txt_addPhone.Value) && string.IsNullOrEmpty(txt_addQQ.Value) && string.IsNullOrEmpty(txt_addEmail.Value))
        {
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">联系方式至少要填一项!</a>";
            lit_AddInfo.Visible = true;
            return true;
        }
        CRM_CUSTOMER cctomer = new CRM_CUSTOMER();
        CRM_CUST cct = new CRM_CUST();
        string cctomerLike = " 1<>1 ";
        string cctLike = " 1<>1 ";
        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
        {
            cctomerLike += " or " + CRM_CUSTOMER.Attribute.WangWangId.FieldName + " like '" + txt_addWangWangId.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
        {
            txt_addShopUrl.Value = txt_addShopUrl.Value.Trim().Replace(" ", "").ToLower();
            if (!txt_addShopUrl.Value.Contains(".com"))
            {
                lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">网店地址错误!</a>";
                lit_AddInfo.Visible = true;
                return true;
            }
            int end = txt_addShopUrl.Value.IndexOf(".com") + 4;
            if (txt_addShopUrl.Value.Contains("://"))
            {
                int start = txt_addShopUrl.Value.IndexOf("://");
                if (end - start <= 0)
                {
                    lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">网店地址错误!</a>";
                    lit_AddInfo.Visible = true;
                    return true;
                }
                string url = txt_addShopUrl.Value.Substring(start, end - start);
                cctomerLike += " or " + CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like '%" + url + "%'";
                //cctomerLike += CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like 'http://" + txt_addShopUrl.Value.Trim().Replace(" ", "") + "%' or ";
            }
            else
            {
                string url = txt_addShopUrl.Value.Substring(0, end);
                cctomerLike += " or " + CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like '" + url + "%'";
                //cctomerLike += CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like 'http://" + txt_addShopUrl.Value.Trim().Replace(" ", "") + "%' or ";
            }
        }
        if (!string.IsNullOrEmpty(txt_addComName.Value))
        {
            cctomerLike += " or " + CRM_CUSTOMER.Attribute.CompanyName.FieldName + " like '" + txt_addComName.Value.Trim().Replace(" ", "") + "'";
        }
        cctomer.Where(cctomerLike);

        if (!string.IsNullOrEmpty(txt_addQQ.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.QQ.FieldName + " like '" + txt_addQQ.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.Phone.FieldName + " like '" + txt_addPhone.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.MobPhone.FieldName + " like '" + txt_addMobPhone.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.Email.FieldName + " like '" + txt_addEmail.Value.Trim().Replace(" ", "") + "'";
        }
        cct.Where(cctLike);

        if (BLLTable<CRM_CUSTOMER>.Exists(cctomer) || BLLTable<CRM_CUST>.Exists(cct))
        {
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!系统中存在该用户!</a>";
            lit_AddInfo.Visible = true;
            return true;
        }
        return false;
    }
示例#20
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new CRM_CUST();

            if(txtCus_ID.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value));

            if(txtCus_Name.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value));

            if(txtJob.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Job, Convert.ToString(txtJob.Value));

            if(txtRelationTxt.Value !="" )
                condObj.Like(CRM_CUST.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value));

            if(txtRecorder.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Recorder, Convert.ToString(txtRecorder.Value));

            if(txtMobPhone.Value !="" )
                condObj.Like(CRM_CUST.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value));

            if(txtPhone.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Phone, Convert.ToString(txtPhone.Value));

            if(txtContactName.Value !="" )
                condObj.Like(CRM_CUST.Attribute.ContactName, Convert.ToString(txtContactName.Value));

            if(txtShopName.Value !="" )
                condObj.Like(CRM_CUST.Attribute.ShopName, Convert.ToString(txtShopName.Value));

            if(txtShopAddr.Value !="" )
                condObj.Like(CRM_CUST.Attribute.ShopAddr, Convert.ToString(txtShopAddr.Value));

            if(txtQQ.Value !="" )
                condObj.Like(CRM_CUST.Attribute.QQ, Convert.ToString(txtQQ.Value));

            if(txtWW.Value !="" )
                condObj.Like(CRM_CUST.Attribute.WW, Convert.ToString(txtWW.Value));

            if(txtEmail.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Email, Convert.ToString(txtEmail.Value));

            if(txtAddress.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Address, Convert.ToString(txtAddress.Value));

            if(txtTrade.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Trade, Convert.ToString(txtTrade.Value));

            if(txtType.Value !="" )
                condObj.Like(CRM_CUST.Attribute.Type, Convert.ToInt32(txtType.Value));

            if(txtState.Value !="" )
                condObj.State = Convert.ToInt32(txtState.Value);

            if(txtIsSign.Value !="" )
                condObj.IsSign = Convert.ToInt32(txtIsSign.Value);

            if(txtAddTime.Value !="" )
                condObj.Like(CRM_CUST.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value));

            if(txtEditTime.Value !="" )
                condObj.Like(CRM_CUST.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value));

            if(txtPATH.Value !="" )
                condObj.Like(CRM_CUST.Attribute.PATH, Convert.ToString(txtPATH.Value));

            if(txtPNAME.Value !="" )
                condObj.Like(CRM_CUST.Attribute.PNAME, Convert.ToString(txtPNAME.Value));

            listObj = BLLTable<CRM_CUST>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
        aspPager.RecordCount = recount;
    }
示例#21
0
    protected void btnSub_Click(object sender, EventArgs e)
    {
        lit_AddInfo.Text = "";
        lit_AddInfo.Visible = false;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();
        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();
        cscCon._SID = hid_SID.Value;
        List<CRM_STAFF_CUSTOMER> cscList = BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Select(cscVal, cscCon);
        if (cscList.Count >= 500)
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!客户数达到上限500个。</a>";
            return;
        }

        if (CheckTheSame())
        {
            return;
        }

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();
        if (!string.IsNullOrEmpty(txt_addComAddress.Value))
            c_customer.CompanyAddress = txt_addComAddress.Value.Trim().Replace(" ", "");
        c_customer._CustSex = txt_addCustSexMan.Checked ? 1 : 0;
        if (!string.IsNullOrEmpty(txt_addShopName.Value))
            c_customer._ShopName = txt_addShopName.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
            c_customer._ShopNameURL = txt_addShopUrl.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
            c_customer._WangWangId = txt_addWangWangId.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addComName.Value))
            c_customer._CompanyName = txt_addComName.Value.Trim().Replace(" ", "");
        else
            c_customer._CompanyName = txt_addShopName.Value.Trim().Replace(" ", "");
        c_customer._LastEditors = hid_SID.Value;
        int count = BLLTable<CRM_CUSTOMER>.Factory(conn).Insert(c_customer);
        if (count < 1)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        c_customer.OrderBy(CRM_CUSTOMER.Attribute.Cus_Id, Order.Desc);
        c_customer.Top(1);
        CRM_CUSTOMER c_customerval = new CRM_CUSTOMER();
        c_customerval.Cus_Id = 0;
        List<CRM_CUSTOMER> c_customercusid = BLLTable<CRM_CUSTOMER>.Factory(conn).Select(c_customerval, c_customer);
        if (c_customercusid.Count < 1)//插入不成功?
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_CUST c_cust = new CRM_CUST();
        c_cust._Cus_ID = c_customercusid[0].Cus_Id;
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
            c_cust._Cus_Name = txt_addCustName.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
            c_cust._Email = txt_addEmail.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
            c_cust._MobPhone = txt_addMobPhone.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
            c_cust._Phone = txt_addPhone.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addQQ.Value))
            c_cust._QQ = txt_addQQ.Value.Trim().Replace(" ", "");
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
            c_cust._ContactName = txt_addCustName.Value.Trim().Replace(" ", "");
        c_cust._AddTime = DateTime.Now;
        c_cust._EditTime = DateTime.Now;
        count += BLLTable<CRM_CUST>.Factory(conn).Insert(c_cust);
        if (count < 2)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        if (string.IsNullOrEmpty(hid_SID.Value))
            return;
        DateTime lastConTime = DateTime.MinValue;
        if (!string.IsNullOrEmpty(txt_addConDailts.Value))
        {
            CRM_STAFF_CUSTOMER_CONTACTRECORDS c_scc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
            c_scc._Cus_ID = c_customercusid[0].Cus_Id;
            c_scc._SID = hid_SID.Value;
            c_scc._NextContactTime = DateTime.Now;
            c_scc._ContactTime = DateTime.Now;
            lastConTime = c_scc._ContactTime;
            c_scc._ContactRecords = txt_addConDailts.Value;
            c_scc._CustStatus = ddl_CusStatus.SelectedIndex;
            BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(c_scc);
        }
        CRM_STAFF_CUSTOMER_CONTACTRECORDS c_sccNext = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
        c_sccNext._Cus_ID = c_customercusid[0].Cus_Id;
        c_sccNext._SID = hid_SID.Value;
        c_sccNext._NextContactTime = DateTime.Now.AddDays(1);
        c_sccNext._CustStatus = ddl_CusStatus.SelectedIndex;
        count += BLLTable<CRM_STAFF_CUSTOMER_CONTACTRECORDS>.Factory(conn).Insert(c_sccNext);
        if (count < 3)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER c_sc = new CRM_STAFF_CUSTOMER();
        c_sc._Cus_ID = c_customercusid[0].Cus_Id;
        c_sc._SID = hid_SID.Value;
        c_sc._CustStatus = ddl_CusStatus.SelectedIndex;
        if (lastConTime != DateTime.MinValue)
            c_sc._LastContactTime = lastConTime;
        count += BLLTable<CRM_STAFF_CUSTOMER>.Factory(conn).Insert(c_sc);
        if (count < 4)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        lit_AddInfo.Visible = true;
        lit_AddInfo.Text = "<a style=\"color:green; font-size:12px;\">添加成功!</a>";
        ClearForm();
    }
示例#22
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        try
        {
            CRM_CUST valObj = new CRM_CUST();


            if (txtCus_ID.Value != "")
            {
                valObj.Cus_ID = Convert.ToInt32(txtCus_ID.Value);
            }


            if (txtCus_Name.Value != "")
            {
                valObj.Cus_Name = Convert.ToString(txtCus_Name.Value);
            }


            if (txtJob.Value != "")
            {
                valObj.Job = Convert.ToString(txtJob.Value);
            }


            if (txtRelationTxt.Value != "")
            {
                valObj.RelationTxt = Convert.ToString(txtRelationTxt.Value);
            }


            if (txtRecorder.Value != "")
            {
                valObj.Recorder = Convert.ToString(txtRecorder.Value);
            }


            if (txtMobPhone.Value != "")
            {
                valObj.MobPhone = Convert.ToString(txtMobPhone.Value);
            }


            if (txtPhone.Value != "")
            {
                valObj.Phone = Convert.ToString(txtPhone.Value);
            }


            if (txtContactName.Value != "")
            {
                valObj.ContactName = Convert.ToString(txtContactName.Value);
            }


            if (txtShopName.Value != "")
            {
                valObj.ShopName = Convert.ToString(txtShopName.Value);
            }


            if (txtShopAddr.Value != "")
            {
                valObj.ShopAddr = Convert.ToString(txtShopAddr.Value);
            }


            if (txtQQ.Value != "")
            {
                valObj.QQ = Convert.ToString(txtQQ.Value);
            }


            if (txtWW.Value != "")
            {
                valObj.WW = Convert.ToString(txtWW.Value);
            }


            if (txtEmail.Value != "")
            {
                valObj.Email = Convert.ToString(txtEmail.Value);
            }


            if (txtAddress.Value != "")
            {
                valObj.Address = Convert.ToString(txtAddress.Value);
            }


            if (txtTrade.Value != "")
            {
                valObj.Trade = Convert.ToString(txtTrade.Value);
            }


            if (txtType.Value != "")
            {
                valObj.Type = Convert.ToInt32(txtType.Value);
            }


            if (txtState.Value != "")
            {
                valObj.State = Convert.ToInt32(txtState.Value);
            }


            if (txtIsSign.Value != "")
            {
                valObj.IsSign = Convert.ToInt32(txtIsSign.Value);
            }


            if (txtAddTime.Value != "")
            {
                valObj.AddTime = Convert.ToDateTime(txtAddTime.Value);
            }


            if (txtEditTime.Value != "")
            {
                valObj.EditTime = Convert.ToDateTime(txtEditTime.Value);
            }


            if (txtPATH.Value != "")
            {
                valObj.PATH = Convert.ToString(txtPATH.Value);
            }


            if (txtPNAME.Value != "")
            {
                valObj.PNAME = Convert.ToString(txtPNAME.Value);
            }

            if (keyid != "")
            {
                valObj.Cus_ID = Convert.ToInt32(keyid);
                count         = BLLTable <CRM_CUST> .Factory(conn).Update(valObj, CRM_CUST.Attribute.Cus_ID);
            }
            else
            {
                count = BLLTable <CRM_CUST> .Factory(conn).Insert(valObj, CRM_CUST.Attribute.Cus_ID);

                keyid = valObj.Cus_ID.ToString();
            }
            if (count > 0)
            {
                StringBuilder        sbData = new StringBuilder("({valObj:''");
                List <AttributeItem> lstCol = valObj.af_AttributeItemList;
                for (int i = 0; i < lstCol.Count; i++)
                {
                    object val = valObj.GetValue(lstCol[i]);
                    if (val != null)
                    {
                        sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
                    }
                }
                sbData.Append("})");

                Button btn = (Button)sender;
                if (btn.ID == "btnOK")
                {
                    if (ViewState["hadSave"] == null)
                    {
                        ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
                    }
                }
                else
                {
                    txtCus_ID.Value = "";


                    txtCus_Name.Value = "";


                    txtJob.Value = "";


                    txtRelationTxt.Value = "";


                    txtRecorder.Value = "";


                    txtMobPhone.Value = "";


                    txtPhone.Value = "";


                    txtContactName.Value = "";


                    txtShopName.Value = "";


                    txtShopAddr.Value = "";


                    txtQQ.Value = "";


                    txtWW.Value = "";


                    txtEmail.Value = "";


                    txtAddress.Value = "";


                    txtTrade.Value = "";


                    txtType.Value = "";


                    txtState.Value = "";


                    txtIsSign.Value = "";


                    txtAddTime.Value = "";


                    txtEditTime.Value = "";


                    txtPATH.Value = "";


                    txtPNAME.Value = "";
                }
            }
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
示例#23
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        try
        {
            CRM_CUST valObj = new CRM_CUST();

            if(txtCus_ID.Value !="" )
                valObj.Cus_ID = Convert.ToInt32(txtCus_ID.Value);

            if(txtCus_Name.Value !="" )
                valObj.Cus_Name = Convert.ToString(txtCus_Name.Value);

            if(txtJob.Value !="" )
                valObj.Job = Convert.ToString(txtJob.Value);

            if(txtRelationTxt.Value !="" )
                valObj.RelationTxt = Convert.ToString(txtRelationTxt.Value);

            if(txtRecorder.Value !="" )
                valObj.Recorder = Convert.ToString(txtRecorder.Value);

            if(txtMobPhone.Value !="" )
                valObj.MobPhone = Convert.ToString(txtMobPhone.Value);

            if(txtPhone.Value !="" )
                valObj.Phone = Convert.ToString(txtPhone.Value);

            if(txtContactName.Value !="" )
                valObj.ContactName = Convert.ToString(txtContactName.Value);

            if(txtShopName.Value !="" )
                valObj.ShopName = Convert.ToString(txtShopName.Value);

            if(txtShopAddr.Value !="" )
                valObj.ShopAddr = Convert.ToString(txtShopAddr.Value);

            if(txtQQ.Value !="" )
                valObj.QQ = Convert.ToString(txtQQ.Value);

            if(txtWW.Value !="" )
                valObj.WW = Convert.ToString(txtWW.Value);

            if(txtEmail.Value !="" )
                valObj.Email = Convert.ToString(txtEmail.Value);

            if(txtAddress.Value !="" )
                valObj.Address = Convert.ToString(txtAddress.Value);

            if(txtTrade.Value !="" )
                valObj.Trade = Convert.ToString(txtTrade.Value);

            if(txtType.Value !="" )
                valObj.Type = Convert.ToInt32(txtType.Value);

            if(txtState.Value !="" )
                valObj.State = Convert.ToInt32(txtState.Value);

            if(txtIsSign.Value !="" )
                valObj.IsSign = Convert.ToInt32(txtIsSign.Value);

            if(txtAddTime.Value !="" )
                valObj.AddTime = Convert.ToDateTime(txtAddTime.Value);

            if(txtEditTime.Value !="" )
                valObj.EditTime = Convert.ToDateTime(txtEditTime.Value);

            if(txtPATH.Value !="" )
                valObj.PATH = Convert.ToString(txtPATH.Value);

            if(txtPNAME.Value !="" )
                valObj.PNAME = Convert.ToString(txtPNAME.Value);

            if (keyid != "")
            {
                valObj.Cus_ID = Convert.ToInt32(keyid);
                count = BLLTable<CRM_CUST>.Factory(conn).Update(valObj, CRM_CUST.Attribute.Cus_ID);
            }
            else
            {
                count = BLLTable<CRM_CUST>.Factory(conn).Insert(valObj, CRM_CUST.Attribute.Cus_ID);
                keyid = valObj.Cus_ID.ToString();

            }
            if (count > 0)
            {
                StringBuilder sbData = new StringBuilder("({valObj:''");
                List<AttributeItem> lstCol = valObj.af_AttributeItemList;
                for (int i = 0; i < lstCol.Count; i++)
                {
                    object val = valObj.GetValue(lstCol[i]);
                    if (val != null)
                    {
                        sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
                    }
                }
                sbData.Append("})");

                Button btn = (Button)sender;
                if (btn.ID == "btnOK")
                {
                    if (ViewState["hadSave"] == null)
                    {
                        ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
                    }
                }
                else
                {

                    txtCus_ID.Value ="";

                    txtCus_Name.Value ="";

                    txtJob.Value ="";

                    txtRelationTxt.Value ="";

                    txtRecorder.Value ="";

                    txtMobPhone.Value ="";

                    txtPhone.Value ="";

                    txtContactName.Value ="";

                    txtShopName.Value ="";

                    txtShopAddr.Value ="";

                    txtQQ.Value ="";

                    txtWW.Value ="";

                    txtEmail.Value ="";

                    txtAddress.Value ="";

                    txtTrade.Value ="";

                    txtType.Value ="";

                    txtState.Value ="";

                    txtIsSign.Value ="";

                    txtAddTime.Value ="";

                    txtEditTime.Value ="";

                    txtPATH.Value ="";

                    txtPNAME.Value ="";
                }
            }
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
    }
示例#24
0
    protected bool CheckTheSame()
    {
        if (string.IsNullOrEmpty(txt_addMobPhone.Value) && string.IsNullOrEmpty(txt_addPhone.Value) && string.IsNullOrEmpty(txt_addQQ.Value) && string.IsNullOrEmpty(txt_addEmail.Value))
        {
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">联系方式至少要填一项!</a>";
            lit_AddInfo.Visible = true;
            return(true);
        }
        CRM_CUSTOMER cctomer     = new CRM_CUSTOMER();
        CRM_CUST     cct         = new CRM_CUST();
        string       cctomerLike = " 1<>1 ";
        string       cctLike     = " 1<>1 ";

        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
        {
            cctomerLike += " or " + CRM_CUSTOMER.Attribute.WangWangId.FieldName + " like '" + txt_addWangWangId.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
        {
            txt_addShopUrl.Value = txt_addShopUrl.Value.Trim().Replace(" ", "").ToLower();
            if (!txt_addShopUrl.Value.Contains(".com"))
            {
                lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">网店地址错误!</a>";
                lit_AddInfo.Visible = true;
                return(true);
            }
            int end = txt_addShopUrl.Value.IndexOf(".com") + 4;
            if (txt_addShopUrl.Value.Contains("://"))
            {
                int start = txt_addShopUrl.Value.IndexOf("://");
                if (end - start <= 0)
                {
                    lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">网店地址错误!</a>";
                    lit_AddInfo.Visible = true;
                    return(true);
                }
                string url = txt_addShopUrl.Value.Substring(start, end - start);
                cctomerLike += " or " + CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like '%" + url + "%'";
                //cctomerLike += CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like 'http://" + txt_addShopUrl.Value.Trim().Replace(" ", "") + "%' or ";
            }
            else
            {
                string url = txt_addShopUrl.Value.Substring(0, end);
                cctomerLike += " or " + CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like '" + url + "%'";
                //cctomerLike += CRM_CUSTOMER.Attribute.ShopNameURL.FieldName + " like 'http://" + txt_addShopUrl.Value.Trim().Replace(" ", "") + "%' or ";
            }
        }
        if (!string.IsNullOrEmpty(txt_addComName.Value))
        {
            cctomerLike += " or " + CRM_CUSTOMER.Attribute.CompanyName.FieldName + " like '" + txt_addComName.Value.Trim().Replace(" ", "") + "'";
        }
        cctomer.Where(cctomerLike);

        if (!string.IsNullOrEmpty(txt_addQQ.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.QQ.FieldName + " like '" + txt_addQQ.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.Phone.FieldName + " like '" + txt_addPhone.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.MobPhone.FieldName + " like '" + txt_addMobPhone.Value.Trim().Replace(" ", "") + "'";
        }
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
        {
            cctLike += " or " + CRM_CUST.Attribute.Email.FieldName + " like '" + txt_addEmail.Value.Trim().Replace(" ", "") + "'";
        }
        cct.Where(cctLike);

        if (BLLTable <CRM_CUSTOMER> .Exists(cctomer) || BLLTable <CRM_CUST> .Exists(cct))
        {
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!系统中存在该用户!</a>";
            lit_AddInfo.Visible = true;
            return(true);
        }
        return(false);
    }
示例#25
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        try
        {
            condObj = new CRM_CUST();



            if (txtCus_ID.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value));
            }


            if (txtCus_Name.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value));
            }


            if (txtJob.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Job, Convert.ToString(txtJob.Value));
            }


            if (txtRelationTxt.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value));
            }


            if (txtRecorder.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Recorder, Convert.ToString(txtRecorder.Value));
            }


            if (txtMobPhone.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value));
            }


            if (txtPhone.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Phone, Convert.ToString(txtPhone.Value));
            }


            if (txtContactName.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.ContactName, Convert.ToString(txtContactName.Value));
            }


            if (txtShopName.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.ShopName, Convert.ToString(txtShopName.Value));
            }


            if (txtShopAddr.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.ShopAddr, Convert.ToString(txtShopAddr.Value));
            }


            if (txtQQ.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.QQ, Convert.ToString(txtQQ.Value));
            }


            if (txtWW.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.WW, Convert.ToString(txtWW.Value));
            }


            if (txtEmail.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Email, Convert.ToString(txtEmail.Value));
            }


            if (txtAddress.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Address, Convert.ToString(txtAddress.Value));
            }


            if (txtTrade.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Trade, Convert.ToString(txtTrade.Value));
            }


            if (txtType.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.Type, Convert.ToInt32(txtType.Value));
            }


            if (txtState.Value != "")
            {
                condObj.State = Convert.ToInt32(txtState.Value);
            }


            if (txtIsSign.Value != "")
            {
                condObj.IsSign = Convert.ToInt32(txtIsSign.Value);
            }


            if (txtAddTime.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value));
            }


            if (txtEditTime.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value));
            }


            if (txtPATH.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.PATH, Convert.ToString(txtPATH.Value));
            }


            if (txtPNAME.Value != "")
            {
                condObj.Like(CRM_CUST.Attribute.PNAME, Convert.ToString(txtPNAME.Value));
            }

            listObj = BLLTable <CRM_CUST> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);

            repCus.DataSource = listObj;
            repCus.DataBind();
        }
        catch (Exception ex)
        {
            litWarn.Text = ex.Message;
        }
        aspPager.RecordCount = recount;
    }
示例#26
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new CRM_CUST();



        if (txtCus_ID.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value));
        }


        if (txtCus_Name.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value));
        }


        if (txtJob.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Job, Convert.ToString(txtJob.Value));
        }


        if (txtRelationTxt.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value));
        }


        if (txtRecorder.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Recorder, Convert.ToString(txtRecorder.Value));
        }


        if (txtMobPhone.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value));
        }


        if (txtPhone.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Phone, Convert.ToString(txtPhone.Value));
        }


        if (txtContactName.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.ContactName, Convert.ToString(txtContactName.Value));
        }


        if (txtShopName.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.ShopName, Convert.ToString(txtShopName.Value));
        }


        if (txtShopAddr.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.ShopAddr, Convert.ToString(txtShopAddr.Value));
        }


        if (txtQQ.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.QQ, Convert.ToString(txtQQ.Value));
        }


        if (txtWW.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.WW, Convert.ToString(txtWW.Value));
        }


        if (txtEmail.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Email, Convert.ToString(txtEmail.Value));
        }


        if (txtAddress.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Address, Convert.ToString(txtAddress.Value));
        }


        if (txtTrade.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Trade, Convert.ToString(txtTrade.Value));
        }


        if (txtType.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.Type, Convert.ToInt32(txtType.Value));
        }


        if (txtState.Value != "")
        {
            condObj.State = Convert.ToInt32(txtState.Value);
        }


        if (txtIsSign.Value != "")
        {
            condObj.IsSign = Convert.ToInt32(txtIsSign.Value);
        }


        if (txtAddTime.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value));
        }


        if (txtEditTime.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value));
        }


        if (txtPATH.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.PATH, Convert.ToString(txtPATH.Value));
        }


        if (txtPNAME.Value != "")
        {
            condObj.Like(CRM_CUST.Attribute.PNAME, Convert.ToString(txtPNAME.Value));
        }

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
示例#27
0
    protected void btnFind_Click(object sender, EventArgs e)
    {
        condObj = new CRM_CUST();

        if(txtCus_ID.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value));

        if(txtCus_Name.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value));

        if(txtJob.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Job, Convert.ToString(txtJob.Value));

        if(txtRelationTxt.Value !="" )
            condObj.Like(CRM_CUST.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value));

        if(txtRecorder.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Recorder, Convert.ToString(txtRecorder.Value));

        if(txtMobPhone.Value !="" )
            condObj.Like(CRM_CUST.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value));

        if(txtPhone.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Phone, Convert.ToString(txtPhone.Value));

        if(txtContactName.Value !="" )
            condObj.Like(CRM_CUST.Attribute.ContactName, Convert.ToString(txtContactName.Value));

        if(txtShopName.Value !="" )
            condObj.Like(CRM_CUST.Attribute.ShopName, Convert.ToString(txtShopName.Value));

        if(txtShopAddr.Value !="" )
            condObj.Like(CRM_CUST.Attribute.ShopAddr, Convert.ToString(txtShopAddr.Value));

        if(txtQQ.Value !="" )
            condObj.Like(CRM_CUST.Attribute.QQ, Convert.ToString(txtQQ.Value));

        if(txtWW.Value !="" )
            condObj.Like(CRM_CUST.Attribute.WW, Convert.ToString(txtWW.Value));

        if(txtEmail.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Email, Convert.ToString(txtEmail.Value));

        if(txtAddress.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Address, Convert.ToString(txtAddress.Value));

        if(txtTrade.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Trade, Convert.ToString(txtTrade.Value));

        if(txtType.Value !="" )
            condObj.Like(CRM_CUST.Attribute.Type, Convert.ToInt32(txtType.Value));

        if(txtState.Value !="" )
            condObj.State = Convert.ToInt32(txtState.Value);

        if(txtIsSign.Value !="" )
            condObj.IsSign = Convert.ToInt32(txtIsSign.Value);

        if(txtAddTime.Value !="" )
            condObj.Like(CRM_CUST.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value));

        if(txtEditTime.Value !="" )
            condObj.Like(CRM_CUST.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value));

        if(txtPATH.Value !="" )
            condObj.Like(CRM_CUST.Attribute.PATH, Convert.ToString(txtPATH.Value));

        if(txtPNAME.Value !="" )
            condObj.Like(CRM_CUST.Attribute.PNAME, Convert.ToString(txtPNAME.Value));

        hidCondition.Value = condObj.ToJson(20);

        BindList(condObj, 1);
    }
示例#28
0
    protected void Page_Load(object sender, EventArgs e)
    {
        #region//Ĭ�����ص���
        //hideTableColumnList = new List<AttributeItem>();
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP1);
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP2);
        //hideTableColumnList.Add(CRM_CUST.Attribute.EXP3);
        //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
        //valObj.Remove(hideTableColumnList);

        //hideFindColumnList = new List<AttributeItem>();
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP1);
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP2);
        //hideFindColumnList.Add(CRM_CUST.Attribute.EXP3);
        #endregion
        condObj.OrderBy(CRM_CUST.Attribute.Cus_ID, Order.Desc);

        if (!IsPostBack)
        {
            btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
            aspPager.PageSize = 10;
            aspPager.CurrentPageIndex = 1;

            if (!string.IsNullOrEmpty(Request["ids"]))
            {
                CRM_CUST roleOld = new CRM_CUST();
                roleOld.Where(CRM_CUST.Attribute.Cus_ID, Request["ids"].ToString());
                listObj = BLLTable<CRM_CUST>.Factory(conn).Select(valObj, roleOld);
                for (int i = 0; i < listObj.Count; i++)
                {
                    if (i > 0)
                    {
                        hidOld.Value += ",";
                        hidInitIDS.Value += ",";
                    }
                    hidOld.Value += "{ID:'" + listObj[i].Cus_ID + "',Name:'" + listObj[i].Cus_ID + "'}";//�����Name������ʾ���б��У��������ض��塣
                    hidInitIDS.Value += listObj[i].Cus_ID;
                }
            }
            try
            {

                listObj = BLLTable<CRM_CUST>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
                repList.DataSource = listObj;
                repList.DataBind();
                aspPager.RecordCount = recount;
            }
            catch (Exception ex)
            {
                 litWarn.Text = ex.Message;
            }

        }
    }
示例#29
0
    protected void btnSub_Click(object sender, EventArgs e)
    {
        lit_AddInfo.Text    = "";
        lit_AddInfo.Visible = false;
        CRM_STAFF_CUSTOMER cscVal = new CRM_STAFF_CUSTOMER();

        cscVal._Cus_ID = 0;
        CRM_STAFF_CUSTOMER cscCon = new CRM_STAFF_CUSTOMER();

        cscCon._SID = hid_SID.Value;
        List <CRM_STAFF_CUSTOMER> cscList = BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Select(cscVal, cscCon);

        if (cscList.Count >= 500)
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!客户数达到上限500个。</a>";
            return;
        }

        if (CheckTheSame())
        {
            return;
        }

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();

        if (!string.IsNullOrEmpty(txt_addComAddress.Value))
        {
            c_customer.CompanyAddress = txt_addComAddress.Value.Trim().Replace(" ", "");
        }
        c_customer._CustSex = txt_addCustSexMan.Checked ? 1 : 0;
        if (!string.IsNullOrEmpty(txt_addShopName.Value))
        {
            c_customer._ShopName = txt_addShopName.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addShopUrl.Value))
        {
            c_customer._ShopNameURL = txt_addShopUrl.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addWangWangId.Value))
        {
            c_customer._WangWangId = txt_addWangWangId.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addComName.Value))
        {
            c_customer._CompanyName = txt_addComName.Value.Trim().Replace(" ", "");
        }
        else
        {
            c_customer._CompanyName = txt_addShopName.Value.Trim().Replace(" ", "");
        }
        c_customer._LastEditors = hid_SID.Value;
        int count = BLLTable <CRM_CUSTOMER> .Factory(conn).Insert(c_customer);

        if (count < 1)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        c_customer.OrderBy(CRM_CUSTOMER.Attribute.Cus_Id, Order.Desc);
        c_customer.Top(1);
        CRM_CUSTOMER c_customerval = new CRM_CUSTOMER();

        c_customerval.Cus_Id = 0;
        List <CRM_CUSTOMER> c_customercusid = BLLTable <CRM_CUSTOMER> .Factory(conn).Select(c_customerval, c_customer);

        if (c_customercusid.Count < 1)//插入不成功?
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_CUST c_cust = new CRM_CUST();

        c_cust._Cus_ID = c_customercusid[0].Cus_Id;
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
        {
            c_cust._Cus_Name = txt_addCustName.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addEmail.Value))
        {
            c_cust._Email = txt_addEmail.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addMobPhone.Value))
        {
            c_cust._MobPhone = txt_addMobPhone.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addPhone.Value))
        {
            c_cust._Phone = txt_addPhone.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addQQ.Value))
        {
            c_cust._QQ = txt_addQQ.Value.Trim().Replace(" ", "");
        }
        if (!string.IsNullOrEmpty(txt_addCustName.Value))
        {
            c_cust._ContactName = txt_addCustName.Value.Trim().Replace(" ", "");
        }
        c_cust._AddTime  = DateTime.Now;
        c_cust._EditTime = DateTime.Now;
        count           += BLLTable <CRM_CUST> .Factory(conn).Insert(c_cust);

        if (count < 2)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        if (string.IsNullOrEmpty(hid_SID.Value))
        {
            return;
        }
        DateTime lastConTime = DateTime.MinValue;

        if (!string.IsNullOrEmpty(txt_addConDailts.Value))
        {
            CRM_STAFF_CUSTOMER_CONTACTRECORDS c_scc = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();
            c_scc._Cus_ID          = c_customercusid[0].Cus_Id;
            c_scc._SID             = hid_SID.Value;
            c_scc._NextContactTime = DateTime.Now;
            c_scc._ContactTime     = DateTime.Now;
            lastConTime            = c_scc._ContactTime;
            c_scc._ContactRecords  = txt_addConDailts.Value;
            c_scc._CustStatus      = ddl_CusStatus.SelectedIndex;
            BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(c_scc);
        }
        CRM_STAFF_CUSTOMER_CONTACTRECORDS c_sccNext = new CRM_STAFF_CUSTOMER_CONTACTRECORDS();

        c_sccNext._Cus_ID          = c_customercusid[0].Cus_Id;
        c_sccNext._SID             = hid_SID.Value;
        c_sccNext._NextContactTime = DateTime.Now.AddDays(1);
        c_sccNext._CustStatus      = ddl_CusStatus.SelectedIndex;
        count += BLLTable <CRM_STAFF_CUSTOMER_CONTACTRECORDS> .Factory(conn).Insert(c_sccNext);

        if (count < 3)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }

        CRM_STAFF_CUSTOMER c_sc = new CRM_STAFF_CUSTOMER();

        c_sc._Cus_ID     = c_customercusid[0].Cus_Id;
        c_sc._SID        = hid_SID.Value;
        c_sc._CustStatus = ddl_CusStatus.SelectedIndex;
        if (lastConTime != DateTime.MinValue)
        {
            c_sc._LastContactTime = lastConTime;
        }
        count += BLLTable <CRM_STAFF_CUSTOMER> .Factory(conn).Insert(c_sc);

        if (count < 4)//插入不成功
        {
            lit_AddInfo.Visible = true;
            lit_AddInfo.Text    = "<a style=\"color:red; font-size:12px;\">添加失败!</a>";
            return;
        }
        lit_AddInfo.Visible = true;
        lit_AddInfo.Text    = "<a style=\"color:green; font-size:12px;\">添加成功!</a>";
        ClearForm();
    }
示例#30
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title      = valObj._ZhName + "详细";
        Page.Title = title;
        if (!IsPostBack)
        {
            try
            {
                if (!string.IsNullOrEmpty(Request["Cus_ID"]))
                {
                    valObj = BLLTable <CRM_CUST> .Factory(conn).GetRowData(CRM_CUST.Attribute.Cus_ID, Request["Cus_ID"]);

                    if (valObj == null)
                    {
                        return;
                    }


                    txtCus_ID.Text = Convert.ToString(valObj.Cus_ID);//Convert.ToInt32


                    txtCus_Name.Text = Convert.ToString(valObj.Cus_Name);//Convert.ToString


                    txtJob.Text = Convert.ToString(valObj.Job);//Convert.ToString


                    txtRelationTxt.Text = Convert.ToString(valObj.RelationTxt);//Convert.ToString


                    txtRecorder.Text = Convert.ToString(valObj.Recorder);//Convert.ToString


                    txtMobPhone.Text = Convert.ToString(valObj.MobPhone);//Convert.ToString


                    txtPhone.Text = Convert.ToString(valObj.Phone);//Convert.ToString


                    txtContactName.Text = Convert.ToString(valObj.ContactName);//Convert.ToString


                    txtShopName.Text = Convert.ToString(valObj.ShopName);//Convert.ToString


                    txtShopAddr.Text = Convert.ToString(valObj.ShopAddr);//Convert.ToString


                    txtQQ.Text = Convert.ToString(valObj.QQ);//Convert.ToString


                    txtWW.Text = Convert.ToString(valObj.WW);//Convert.ToString


                    txtEmail.Text = Convert.ToString(valObj.Email);//Convert.ToString


                    txtAddress.Text = Convert.ToString(valObj.Address);//Convert.ToString


                    txtTrade.Text = Convert.ToString(valObj.Trade);//Convert.ToString


                    txtType.Text = Convert.ToString(valObj.Type);//Convert.ToInt32


                    txtState.Text = valObj.State.ToString();


                    txtIsSign.Text = valObj.IsSign.ToString();


                    txtAddTime.Text = (valObj.AddTime == DateTime.MinValue) ? "" : valObj.AddTime.ToString("yyyy-MM-dd HH:mm");


                    txtEditTime.Text = (valObj.EditTime == DateTime.MinValue) ? "" : valObj.EditTime.ToString("yyyy-MM-dd HH:mm");


                    txtPATH.Text = Convert.ToString(valObj.PATH);//Convert.ToString


                    txtPNAME.Text = Convert.ToString(valObj.PNAME);//Convert.ToString
                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }

            if (Request["ajax"] != null)
            {
                Response.Clear();
                Response.Buffer          = true;
                Response.Charset         = "utf-8";
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
                //Response.ContentType = "html/text";

                this.EnableViewState = false;
                System.Globalization.CultureInfo myCItrad        = new System.Globalization.CultureInfo("ZH-CN", true);
                System.IO.StringWriter           oStringWriter   = new System.IO.StringWriter(myCItrad);
                System.Web.UI.HtmlTextWriter     oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                divC.RenderControl(oHtmlTextWriter);

                Response.Write(oStringWriter.ToString());
                Response.End();
            }
        }
    }
示例#31
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title = valObj._ZhName + "�༭";
        Page.Title = title;
        if (!string.IsNullOrEmpty(Request["Cus_ID"]))
        {
            keyid = Request["Cus_ID"];
        }
        if (!IsPostBack)
        {

            txtState.Items.AddRange(FormHelper.GetListItem(CRM_CUST.Attribute.State));
            txtIsSign.Items.AddRange(FormHelper.GetListItem(CRM_CUST.Attribute.IsSign));
            txtAddTime.Value = (DateTime.Now).ToString("yyyy-MM-dd");
            txtEditTime.Value = (DateTime.Now).ToString("yyyy-MM-dd");

            this.txtCus_ID.Disabled = true;
            this.txtCus_ID.Attributes["class"] = "dis";
            try
            {
                if (keyid != "")
                {

                    valObj = BLLTable<CRM_CUST>.Factory(conn).GetRowData(CRM_CUST.Attribute.Cus_ID, Request["Cus_ID"]);
                    if(valObj==null) return ;

                    txtCus_ID.Value = Convert.ToString(valObj.Cus_ID);//Convert.ToInt32

                    txtCus_Name.Value = Convert.ToString(valObj.Cus_Name);//Convert.ToString

                    txtJob.Value = Convert.ToString(valObj.Job);//Convert.ToString

                    txtRelationTxt.Value = Convert.ToString(valObj.RelationTxt);//Convert.ToString

                    txtRecorder.Value = Convert.ToString(valObj.Recorder);//Convert.ToString

                    txtMobPhone.Value = Convert.ToString(valObj.MobPhone);//Convert.ToString

                    txtPhone.Value = Convert.ToString(valObj.Phone);//Convert.ToString

                    txtContactName.Value = Convert.ToString(valObj.ContactName);//Convert.ToString

                    txtShopName.Value = Convert.ToString(valObj.ShopName);//Convert.ToString

                    txtShopAddr.Value = Convert.ToString(valObj.ShopAddr);//Convert.ToString

                    txtQQ.Value = Convert.ToString(valObj.QQ);//Convert.ToString

                    txtWW.Value = Convert.ToString(valObj.WW);//Convert.ToString

                    txtEmail.Value = Convert.ToString(valObj.Email);//Convert.ToString

                    txtAddress.Value = Convert.ToString(valObj.Address);//Convert.ToString

                    txtTrade.Value = Convert.ToString(valObj.Trade);//Convert.ToString

                    txtType.Value = Convert.ToString(valObj.Type);//Convert.ToInt32

                    txtState.Value=valObj.State.ToString();

                    txtIsSign.Value=valObj.IsSign.ToString();

                    txtAddTime.Value = (valObj.AddTime == DateTime.MinValue) ? "" : valObj.AddTime.ToString("yyyy-MM-dd");

                    txtEditTime.Value = (valObj.EditTime == DateTime.MinValue) ? "" : valObj.EditTime.ToString("yyyy-MM-dd");

                    txtPATH.Value = Convert.ToString(valObj.PATH);//Convert.ToString

                    txtPNAME.Value = Convert.ToString(valObj.PNAME);//Convert.ToString
                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }
    protected void btnCusDetailUpDown_Click(object sender, EventArgs e)
    {
        CRM_CUST c_cust = new CRM_CUST();
        c_cust.Cus_ID = Convert.ToInt32(txt_cus_id.Value);
        c_cust.Email = page_Email.Value;
        c_cust.Phone = page_Phone.Value;
        c_cust._Cus_Name = page_Cus_Name.Value;
        BLLTable<CRM_CUST>.Factory(conn).Update(c_cust, CRM_CUST.Attribute.Cus_ID);

        CRM_CUSTOMER c_customer = new CRM_CUSTOMER();
        c_customer.Cus_Id = Convert.ToInt32(txt_cus_id.Value);
        c_customer.CompanyAddress = page_CompanyAddress.Value;
        c_customer.CompanyName = page_CompanyName.Value;
        c_customer.ShopName = page_ShopName.Value;
        c_customer.ShopNameURL = page_ShopNameURL.Value;
        c_customer.WangWangId = page_WangWangId.Value;
        c_customer.CustQQ = page_CustQQ.Value;
        BLLTable<CRM_CUSTOMER>.Factory(conn).Update(c_customer, CRM_CUSTOMER.Attribute.Cus_Id);

        lit_CompanyAddress.Text = page_CompanyAddress.Value;
        lit_CompanyName.Text = page_CompanyName.Value;
        lit_ShopName.Text = page_ShopName.Value;
        lit_ShopNameURL.Text = page_ShopNameURL.Value;
        lit_WangWangId.Text = page_WangWangId.Value;
        lit_CustQQ.Text = page_CustQQ.Value;
        lit_Phone.Text = page_Phone.Value;
        lit_Email.Text = page_Email.Value;
        lit_Cus_Name.Text = page_Cus_Name.Value;
    }
示例#33
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title = valObj._ZhName + "��ϸ";
        Page.Title = title;
        if (!IsPostBack)
        {
            try
            {
                if (!string.IsNullOrEmpty(Request["Cus_ID"]))
                {

                    valObj = BLLTable<CRM_CUST>.Factory(conn).GetRowData(CRM_CUST.Attribute.Cus_ID, Request["Cus_ID"]);
                    if(valObj==null) return ;

                    txtCus_ID.Text = Convert.ToString(valObj.Cus_ID);//Convert.ToInt32

                    txtCus_Name.Text = Convert.ToString(valObj.Cus_Name);//Convert.ToString

                    txtJob.Text = Convert.ToString(valObj.Job);//Convert.ToString

                    txtRelationTxt.Text = Convert.ToString(valObj.RelationTxt);//Convert.ToString

                    txtRecorder.Text = Convert.ToString(valObj.Recorder);//Convert.ToString

                    txtMobPhone.Text = Convert.ToString(valObj.MobPhone);//Convert.ToString

                    txtPhone.Text = Convert.ToString(valObj.Phone);//Convert.ToString

                    txtContactName.Text = Convert.ToString(valObj.ContactName);//Convert.ToString

                    txtShopName.Text = Convert.ToString(valObj.ShopName);//Convert.ToString

                    txtShopAddr.Text = Convert.ToString(valObj.ShopAddr);//Convert.ToString

                    txtQQ.Text = Convert.ToString(valObj.QQ);//Convert.ToString

                    txtWW.Text = Convert.ToString(valObj.WW);//Convert.ToString

                    txtEmail.Text = Convert.ToString(valObj.Email);//Convert.ToString

                    txtAddress.Text = Convert.ToString(valObj.Address);//Convert.ToString

                    txtTrade.Text = Convert.ToString(valObj.Trade);//Convert.ToString

                    txtType.Text = Convert.ToString(valObj.Type);//Convert.ToInt32

                    txtState.Text=valObj.State.ToString();

                    txtIsSign.Text=valObj.IsSign.ToString();

                    txtAddTime.Text = (valObj.AddTime == DateTime.MinValue) ? "" : valObj.AddTime.ToString("yyyy-MM-dd HH:mm");

                    txtEditTime.Text = (valObj.EditTime == DateTime.MinValue) ? "" : valObj.EditTime.ToString("yyyy-MM-dd HH:mm");

                    txtPATH.Text = Convert.ToString(valObj.PATH);//Convert.ToString

                    txtPNAME.Text = Convert.ToString(valObj.PNAME);//Convert.ToString

                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }

            if (Request["ajax"] != null)
            {
                Response.Clear();
                Response.Buffer = true;
                Response.Charset = "utf-8";
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//�����������������
                //Response.ContentType = "html/text";

                this.EnableViewState = false;
                System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                divC.RenderControl(oHtmlTextWriter);

                Response.Write(oStringWriter.ToString());
                Response.End();
            }
        }
    }
示例#34
0
    protected void Page_Load(object sender, EventArgs e)
    {
        title      = valObj._ZhName + "±à¼­";
        Page.Title = title;
        if (!string.IsNullOrEmpty(Request["Cus_ID"]))
        {
            keyid = Request["Cus_ID"];
        }
        if (!IsPostBack)
        {
            txtState.Items.AddRange(FormHelper.GetListItem(CRM_CUST.Attribute.State));
            txtIsSign.Items.AddRange(FormHelper.GetListItem(CRM_CUST.Attribute.IsSign));
            txtAddTime.Value  = (DateTime.Now).ToString("yyyy-MM-dd");
            txtEditTime.Value = (DateTime.Now).ToString("yyyy-MM-dd");

            this.txtCus_ID.Disabled            = true;
            this.txtCus_ID.Attributes["class"] = "dis";
            try
            {
                if (keyid != "")
                {
                    valObj = BLLTable <CRM_CUST> .Factory(conn).GetRowData(CRM_CUST.Attribute.Cus_ID, Request["Cus_ID"]);

                    if (valObj == null)
                    {
                        return;
                    }


                    txtCus_ID.Value = Convert.ToString(valObj.Cus_ID);           //Convert.ToInt32

                    txtCus_Name.Value = Convert.ToString(valObj.Cus_Name);       //Convert.ToString

                    txtJob.Value = Convert.ToString(valObj.Job);                 //Convert.ToString

                    txtRelationTxt.Value = Convert.ToString(valObj.RelationTxt); //Convert.ToString

                    txtRecorder.Value = Convert.ToString(valObj.Recorder);       //Convert.ToString

                    txtMobPhone.Value = Convert.ToString(valObj.MobPhone);       //Convert.ToString

                    txtPhone.Value = Convert.ToString(valObj.Phone);             //Convert.ToString

                    txtContactName.Value = Convert.ToString(valObj.ContactName); //Convert.ToString

                    txtShopName.Value = Convert.ToString(valObj.ShopName);       //Convert.ToString

                    txtShopAddr.Value = Convert.ToString(valObj.ShopAddr);       //Convert.ToString

                    txtQQ.Value = Convert.ToString(valObj.QQ);                   //Convert.ToString

                    txtWW.Value = Convert.ToString(valObj.WW);                   //Convert.ToString

                    txtEmail.Value = Convert.ToString(valObj.Email);             //Convert.ToString

                    txtAddress.Value = Convert.ToString(valObj.Address);         //Convert.ToString

                    txtTrade.Value = Convert.ToString(valObj.Trade);             //Convert.ToString

                    txtType.Value = Convert.ToString(valObj.Type);               //Convert.ToInt32

                    txtState.Value = valObj.State.ToString();

                    txtIsSign.Value = valObj.IsSign.ToString();

                    txtAddTime.Value = (valObj.AddTime == DateTime.MinValue) ? "" : valObj.AddTime.ToString("yyyy-MM-dd");

                    txtEditTime.Value = (valObj.EditTime == DateTime.MinValue) ? "" : valObj.EditTime.ToString("yyyy-MM-dd");

                    txtPATH.Value = Convert.ToString(valObj.PATH);   //Convert.ToString

                    txtPNAME.Value = Convert.ToString(valObj.PNAME); //Convert.ToString
                }
            }
            catch (Exception ex)
            {
                litWarn.Text = ex.Message;
            }
        }
    }