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