📄 agentwork.cs
字号:
public static bool IsRightDate(string val)
{
try
{
if(System.DateTime.Today>Convert.ToDateTime(val+"-1"))
return false;
else
return true;
}
catch
{
return false;
}
}
public static bool IsCreditCard(string type)
{
DataRow dr=CardType.Rows.Find(type);
if(dr==null)
return false;
else
{
if(dr["type1"].ToString()=="2")
return true;
else
return false;
}
}
public static string getCreditCardName(string type)
{
DataRow dr=CardType.Rows.Find(type);
if(dr!=null)
return dr["cardname"].ToString();
else
return string.Empty;
}
public static void GetPayCard(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlpayc+"where contactid='"+sql+"'");
}
#endregion
#region 用户
static public DataTable User
{
get
{
IniUser();
return _dtuser;
}
}
static public void IniUser()
{
if(_dtuser.Rows.Count==0)
{
OLEDB mydb=Agentwork.db;
DataTable dt=new DataTable();
mydb.FillTable(dt,sqluser);
_dtuser=dt;
}
}
static public string GetUsrName(string id)
{
//string dsc="";
//2005-9-14 cl 没有对应的返回原值
string dsc= id;
if(id==string.Empty)return dsc;
for(int i=0;i<User.Rows.Count;i++)
{
if(User.Rows[i]["usrid"].ToString()==id)
{
dsc=User.Rows[i]["name"].ToString();
break;
}
}
return dsc;
}
#endregion
#region 组
static public DataTable Group
{
get
{
IniGroup();
return _dtgrp;
}
}
static public void IniGroup()
{
if(_dtgrp.Rows.Count==0)
{
OLEDB mydb=Agentwork.db;
DataTable dt=new DataTable();
mydb.FillTable(dt,sqlgrp);
_dtgrp=dt;
}
}
static public string GetGrpName(string id)
{
string dsc="";
for(int i=0;i<Group.Rows.Count;i++)
{
if(Group.Rows[i]["grpid"].ToString()==id)
{
dsc=Group.Rows[i]["grpname"].ToString();
break;
}
}
return dsc;
}
static public string GetGrpAreaCode(string id)
{
string dsc="";
for(int i=0;i<Group.Rows.Count;i++)
{
if(Group.Rows[i]["grpid"].ToString()==id)
{
dsc=Group.Rows[i]["areacode"].ToString();
break;
}
}
return dsc;
}
#endregion
#region 地址
static public DataTable Address
{
get
{
HttpSessionState sess=HttpContext.Current.Session;
if( sess["Address"] == null )
{
SAddrByCode("");
}
return (DataTable)sess["Address"];
}
set
{
HttpSessionState sess=HttpContext.Current.Session;
sess["Address"]=value;
}
}
static public void SAddrByCode(string code)
{
OLEDB mydb=Agentwork.db;
string sql=sqladdr+" where spell_code ='"+code+"' or name ='"+code+"'";
DataTable dt=new DataTable();
try
{
mydb.FillTable(dt,sql);
Address=dt;
}
catch{}
}
static public void SAddrByPhone(string telephone)
{
OLEDB mydb=Agentwork.db;
string sql=sqladdr+" where telephone ='"+telephone+"' order by spell_code";
DataTable dt=new DataTable();
try
{
mydb.FillTable(dt,sql);
Address=dt;
}
catch{}
}
static public void SAddrByPrv(string provinceid)
{
OLEDB mydb=Agentwork.db;
string sql=sqladdr+" where provinceid ='"+provinceid+"' order by spell_code";
DataTable dt=new DataTable();
try
{
mydb.FillTable(dt,sql);
Address=dt;
}
catch{}
}
static public void SAddrBySpell(string spellid)
{
OLEDB mydb=Agentwork.db;
string sql=sqladdr+" where spellid ='"+spellid+"'";
DataTable dt=new DataTable();
try
{
mydb.FillTable(dt,sql);
Address=dt;
}
catch{}
}
//2005-8-15 cl 增加地址选中行
static public string sAddressLine
{
get
{
HttpSessionState sess=HttpContext.Current.Session;
return (string)sess["sAddressLine"];
}
set
{
HttpSessionState sess=HttpContext.Current.Session;
if(value==null)
{
sess.Remove("sAddressLine");
}
else
{
sess["sAddressLine"]=value;
}
}
}
#endregion
#region 省份
static public DataTable Province
{
get
{
IniProv();
return _dtprov;
}
}
static public void IniProv()
{
if(_dtprov.Rows.Count==0)
{
OLEDB mydb=Agentwork.db;
DataTable dt=new DataTable();
mydb.FillTable(dt,sqlprov);
_dtprov=dt;
}
}
static public string GetProvName(string id)
{
string dsc="";
for(int i=0;i<Province.Rows.Count;i++)
{
if(Province.Rows[i]["provinceid"].ToString()==id)
{
dsc=Province.Rows[i]["chinese"].ToString();
break;
}
}
return dsc;
}
#endregion
#region 产品规格
static public DataTable PordType
{
get
{
IniProdType();
return _dtpdtp;
}
}
static public void IniProdType()
{
if(_dtpdtp.Rows.Count==0)
{
OLEDB mydb=Agentwork.db;
DataTable dt=new DataTable();
mydb.FillTable(dt,sqlpdtp);
_dtpdtp=dt;
}
}
static public string GetProdTypeDsc(string id)
{
string dsc="";
for(int i=0;i<PordType.Rows.Count;i++)
{
if(PordType.Rows[i]["recid"].ToString()==id)
{
dsc=PordType.Rows[i]["dsc"].ToString();
break;
}
}
return dsc;
}
#endregion
static public void SearchProduct(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlprod+sql);
}
static public void SearchMedia(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlmedia1+sql+sqlmedia2);
}
//用于客户信息页面判断是否刷新订单，订单历史，购物车页面
static public bool IsFreshPage
{
get
{
HttpSessionState sess=HttpContext.Current.Session;
if( sess["FreshPage"] == null )
{
Agentwork.IsFreshPage=false;
}
return (bool)sess["FreshPage"];
}
set
{
HttpSessionState sess=HttpContext.Current.Session;
sess["FreshPage"]=value;
}
}
#region 事件类型
static public DataTable Category
{
get
{
IniCategory();
return _dtcate;
}
}
static public void IniCategory()
{
if(_dtcate.Rows.Count==0)
{
OLEDB mydb=Agentwork.db;
DataTable dt=new DataTable();
mydb.FillTable(dt,sqlcate);
dt.PrimaryKey=new System.Data.DataColumn[] {dt.Columns["categoryid"]};
_dtcate=dt;
}
}
#endregion
#region 业绩查询
static public void SearchYjOrder(DataTable dt,string crusr)
{
OLEDB mydb=Agentwork.db;
//查询作息自己当天的订单
mydb.FillTable(dt,sqlyjod+crusr+"' and a.crdt>=to_date('"+System.DateTime.Now.ToShortDateString()+"','yyyy-mm-dd')");
}
static public void SearchYjAddr(DataTable dt,string cuid)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlyjad+cuid+"'");
}
static public void SearchYjCart(DataTable dt,string orderid)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlyjct+orderid+"'");
}
#endregion
#region 综合查询
//根据客户，座席，地址查询订单
static public void SearchZhOrder(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlStoorder+sql);
for(int i=0;i<dt.Rows.Count;i++)
{
DataRow dr=dt.Rows[i];
dr[7]=GetSingleName("ORDERFEEDBACK",dr[7].ToString());//result
dr[8]=GetSingleName("ORDERSTATUS",dr[8].ToString());//status
dr[11]=GetSingleName("BUYTYPE",dr[11].ToString());//mailtype
dr[12]=GetSingleName("PAYTYPE",dr[12].ToString());//paytype
}
dtZhOrder=dt;
}
//根据产品查询客户
static public void SearchZhPdToCu(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlSpdtocu+sql);
for(int i=0;i<dt.Rows.Count;i++)
{
DataRow dr=dt.Rows[i];
dr[3]=GetSingleName("PRODSTATUS",dr[3].ToString());//result
}
dtZhOrder=dt;
}
//根据订单号查购物车
static public void SearchZhOdToCt(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlSodtoct+sql+"'");
}
//订单查询结果dt（用于汉字转换和Excel导出）
static public DataTable dtZhOrder
{
get
{
HttpSessionState sess=HttpContext.Current.Session;
if( sess["dtZhOrder"] == null )
{
DataTable dt=new DataTable();
dtZhOrder=dt;
}
return (DataTable)sess["dtZhOrder"];
}
set
{
HttpSessionState sess=HttpContext.Current.Session;
if(value==null)
{
sess.Remove("dtZhOrder");
}
else
{
sess["dtZhOrder"]=value;
}
}
}
//用于客户信息页面判断是否刷新订单，订单历史，购物车页面
static public string getZhspellid
{
get
{
HttpSessionState sess=HttpContext.Current.Session;
if( sess["getZhspellid"] == null )
{
getZhspellid=string.Empty;
}
return (string)sess["getZhspellid"];
}
set
{
HttpSessionState sess=HttpContext.Current.Session;
if(value==null)
{
sess.Remove("getZhspellid");
}
else
{
sess["getZhspellid"]=value;
}
}
}
#endregion
#region 黑名单查询
public static bool IsBlackPhn(string phn)
{
DataTable dt=new DataTable();
OLEDB mydb=Agentwork.db;
int t=mydb.FillTable(dt,sqlblack+phn+"'");
bool bl=false;
if(t<1)
{
bl=false;
}
else
{
for(int i=0;i<dt.Rows.Count;i++)
{
if(dt.Rows[i][0].ToString().StartsWith("m"))
{
bl=true;
break;
}
}
}
dt=null;
return bl;
}
#endregion
#region 回执单客户查询
static public void SearchReturn(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqlreturn+sql);
}
#endregion
#region 当天通话结束查询
static public void SearchTDCall(DataTable dt,string sql)
{
OLEDB mydb=Agentwork.db;
mydb.FillTable(dt,sqltdcall+sql);
}
#endregion
//******************************************************************
//******************************************************************
//公用方法 2005-6-1 陈立
//******************************************************************
//绑定names表中的数据到下拉框
public static void DDL_Init(DropDownList c,string tid)
{
if(Names.Rows.Count==0)
{
c.Enabled=false;
return;
}
DataRow[] drs=Names.Select("tid='" + tid +"'");
DataTable dt=Names.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
c.DataSource=dt;
c.DataTextField="dsc";
c.DataValueField="id";
c.DataBind();
}
public static void DDL_Init(RadioButtonList c,string tid)
{
if(Names.Rows.Count==0)
{
c.Enabled=false;
return;
}
DataRow[] drs=Names.Select("tid='" + tid +"'");
DataTable dt=Names.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
c.DataSource=dt;
c.DataTextField="dsc";
c.DataValueField="id";
c.DataBind();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -