public DataTable GetCustNameTel(enumRoleGrade LoginUserRoleGrade, long LoginUserID, long LoginUserRoleID) { //add search criteria string Filter = string.Empty; //Chemical: sales只能看到自己所属的客户,产品经理可以看到有使用其所属产品的客户,老板可以看到所有 //Ticket: sales能看到所有的客户 switch (LoginUserRoleGrade) { case enumRoleGrade.Sales: //sales Filter = "and CustOwnerID=" + LoginUserID; break; case enumRoleGrade.ProdManager: //Prod Manager can see its prods and it's customer as sales Filter = "and CustId in (select CustId from vw_CRMRoleCustomer where RoleId=" + LoginUserRoleID.ToString() + ")"; break; case enumRoleGrade.DepManager: //Dep Manager can see its department customers Filter = "and CustId in (select CustId from vw_CRMRoleDepCustomer where RoleId=" + LoginUserRoleID.ToString() + ")"; break; case enumRoleGrade.Boss: //Boss Filter = "and 1=1"; break; default: Filter = "and 1=0"; break; } return(DBExtBase.ExeFillTblBySqlText(this.dataCtx, @"select Cast(CustID as varchar(10))+'|'+CustName as CustIDName, CustName + ' '+isnull(CustTel,'') as CustNameTel from CRMCustomer" + OnlyDisplayActiveRecords + Filter + " order by CustNameTel")); }
} //split by "|" //public string strBuddyNameList //{ // get { return (ViewState["strBuddyNameList"] == null) ? "" : ViewState["strBuddyNameList"].ToString(); } // set { ViewState["strBuddyNameList"] = value; } //} //split by "|" protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //bind cust list to ddlcust enumRoleGrade grade = (enumRoleGrade)((BasePage)this.Page).LoginUserRoleGrade; long userID = ((BasePage)this.Page).LoginUserID; long roleID = ((BasePage)this.Page).LoginUserRoleID; ddlCust.BindDropDownListAndSelect(svr.GetCustNameTel(grade, userID, roleID), "CustNameTel", "CustIDName"); BindData(); } }
public DataTable GetCustNameTel(enumRoleGrade LoginUserRoleGrade, long LoginUserID, long LoginUserRoleID) { //add search criteria string Filter = string.Empty; //Chemical: sales只能看到自己所属的客户,产品经理可以看到有使用其所属产品的客户,老板可以看到所有 //Ticket: sales能看到所有的客户 switch (LoginUserRoleGrade) { case enumRoleGrade.Sales://sales Filter = "and CustOwnerID=" + LoginUserID; break; case enumRoleGrade.ProdManager: //Prod Manager can see its prods and it's customer as sales Filter = "and CustId in (select CustId from vw_CRMRoleCustomer where RoleId=" + LoginUserRoleID.ToString() + ")"; break; case enumRoleGrade.DepManager: //Dep Manager can see its department customers Filter = "and CustId in (select CustId from vw_CRMRoleDepCustomer where RoleId=" + LoginUserRoleID.ToString() + ")"; break; case enumRoleGrade.Boss: //Boss Filter = "and 1=1"; break; default: Filter = "and 1=0"; break; } return DBExtBase.ExeFillTblBySqlText(this.dataCtx, @"select Cast(CustID as varchar(10))+'|'+CustName as CustIDName, CustName + ' '+isnull(CustTel,'') as CustNameTel from CRMCustomer" + OnlyDisplayActiveRecords + Filter + " order by CustNameTel"); }