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; }
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(); }
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); } } } }
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(); }
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, "已经存在此客户!"); } }
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); } } } }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<CRM_CUST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <CRM_CUST>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
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); }
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(); }
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; } } }
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(); }
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; } }
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; }
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; } }
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, "已经存在此客户!"); } }
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; }
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); }
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; }
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; }
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(); }
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; } }
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; } }
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); }
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; }
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); }
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); }
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; } } }
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(); }
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(); } } }
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; }
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(); } } }
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; } } }