📄 agentwork.cs
字号:
}
public static void DDL_Init(DropDownList c,string tid,bool emptyLine)
{
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);
}
if (emptyLine )
{
DataRow dr=dt.NewRow();
dr["DSC"]="";
dr["ID"]="";
dt.Rows.InsertAt(dr,0);
}
c.DataSource=dt;
c.DataTextField="dsc";
c.DataValueField="id";
c.DataBind();
}
public static void DDL_Init_SQL(DropDownList c,string sql,bool emptyLine)
{
DataTable dt=new DataTable();
OLEDB OD = Agentwork.db ;
OD.FillTable(dt,sql);
if (emptyLine )
{
DataRow dr=dt.NewRow();
dr["DSC"]="";
dr["ID"]="";
dt.Rows.InsertAt(dr,0);
}
c.DataSource=dt;
c.DataTextField="DSC";
c.DataValueField="ID";
c.DataBind();
}
public static void DDL_Init_back(DropDownList c,string tid,bool emptyLine)
{
string sql = "select * from names where tid = '" + tid + "'" ;
DataTable dt=new DataTable();
OLEDB OD = Agentwork.db ;
OD.FillTable(dt,sql);
if (emptyLine )
{
DataRow dr=dt.NewRow();
dr["DSC"]="";
dr["ID"]="";
dt.Rows.InsertAt(dr,0);
}
c.DataSource=dt;
c.DataTextField="DSC";
c.DataValueField="ID";
c.DataBind();
}
//绑定dt中指定的几列
public static void DDL_Init(DataTable dt,DropDownList c,string text,string val)
{
c.DataSource=dt;
c.DataTextField=text;
c.DataValueField=val;
c.DataBind();
}
//设置产品规格
public static void DDL_Pordtype(DropDownList c,string tid)
{
if(PordType.Rows.Count ==0)return;
DataRow[] drs=PordType.Select("prodrecid='" + tid +"'");
DataTable dt=PordType.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
if(drs.Length>0)
{
c.Enabled=true;
}
else
{
c.Enabled=false;
}
c.DataSource=dt;
c.DataTextField="dsc";
c.DataValueField="recid";
c.DataBind();
}
//事件类型到子类下拉框绑定
public static void DDL_CaseTypeToCate(DropDownList c,string txt)
{
if(Category.Rows.Count ==0)
{
c.Enabled=false;
return;
}
c.Items.Clear();
DataRow[] drs=Category.Select("category='" + txt +"'");
DataTable dt=Category.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
if(drs.Length>0)
{
c.Enabled=true;
}
else
{
c.Enabled=false;
}
c.DataSource=dt;
c.DataTextField="item";
c.DataValueField="categoryid";
c.DataBind();
}
//事件子类到子类下拉框绑定
public static void DDL_CaseCateToCate(DropDownList c,string id)
{
if(Category.Rows.Count ==0)
{
c.Enabled=false;
return;
}
c.Items.Clear();
DataRow[] drs=Category.Select("category='" + getCateLinkID(id) +"'");
DataTable dt=Category.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
if(drs.Length>0)
{
c.Enabled=true;
}
else
{
c.Enabled=false;
}
c.DataSource=dt;
c.DataTextField="item";
c.DataValueField="categoryid";
c.DataBind();
}
//取得事件类型的下级子类ID
public static string getCateLinkID(string categoryid)
{
DataRow dr=Category.Rows.Find(categoryid);
if(dr==null)
return string.Empty;
else
return dr["linkid"].ToString();
}
//取得事件子类名
public static string getCateName(string categoryid)
{
DataRow dr=Category.Rows.Find(categoryid);
if(dr==null)
return string.Empty;
else
return dr["item"].ToString();
}
/// <summary>
/// 设置付款人卡信息（只取信用卡）
/// </summary>
/// <param name="c">下拉框</param>
/// <param name="dt">付款人证件</param>
public static void DDL_PayCard(DropDownList c,DataTable dt)
{
c.Items.Clear();
for(int i=0;i<dt.Rows.Count;i++)
{
if(dt.Rows[i].RowState!=DataRowState.Deleted)
{
if(IsCreditCard(dt.Rows[i]["type"].ToString()))
{
ListItem it=new ListItem(); it.Text = getCreditCardName(dt.Rows[i]["type"].ToString()); it.Value = dt.Rows[i]["dsc"].ToString(); c.Items.Add(it);
}
}
}
if(c.Items.Count>0)
c.Enabled=true;
else
c.Enabled=false;
}
//通话结束绑定
public static void ListBox_Init(ListBox c,string tid)
{
if(Names.Rows.Count==0)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 ListBox_GroupUser(ListBox c,string grpid)
{
if(User.Rows.Count==0)return;
DataTable dt;
if(grpid==string.Empty)
{
dt=User.Copy();
}
else
{
DataRow[] drs=User.Select("defgrp='" + grpid +"'");
dt=User.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="name";
c.DataValueField="usrid";
c.DataBind();
dt=null;
}
public static void SplitAni(string ani)
{
string phn1 = "";
string phn2 = "" ;
if(ani==null) return ;
if(ani.Length < 5)
return ;
string area1 = ani.Substring(0,3) ;
string area2 = ani.Substring(0,4) ;
string area3 = ani.Substring(0,5) ;
string sql = "select distinct telephone from ems "
+ " where telephone is not null and trim(telephone) is not null" ;
OLEDB OD = Agentwork.db ;
DataTable dt = new DataTable() ;
OD.FillTable(dt,sql) ;
for(int i=0;i<dt.Rows.Count;i++)
{
if(dt.Rows[i]["telephone"].ToString() == area1)
{
phn1 = area1 ;
phn2 = ani.Substring(3) ;
break ;
}
else if(dt.Rows[i]["telephone"].ToString() == area2)
{
phn1 = area2 ;
phn2 = ani.Substring(4) ;
break ;
}
else if(dt.Rows[i]["telephone"].ToString() == area3)
{
phn1 = area3 ;
phn2 = ani.Substring(5) ;
break ;
}
}
if(phn1 == "" )
phn2 = ani ;
Agentwork.Ani_Phn1 = phn1 ;
Agentwork.Ani_Phn2 = phn2 ;
}
//取得新的序列号
public static string getNextID(string name)
{
string nextid = null;
OLEDB mydb = Agentwork.db;
object o = mydb.ExecuteScalar( seqsql1 + name + seqsql2);
if( o != null )
nextid = o.ToString();
// while( nextid.Length<8 )
// {
// nextid = "0" + nextid;
// }
return nextid;
}
//根据订单号查询客户编号
public static string getCuidByOdid(string orderid)
{
string cuid = null;
OLEDB mydb = Agentwork.db;
object o = mydb.ExecuteScalar( sqlodno + " where orderid='" + orderid+"'");
if( o != null )
cuid = o.ToString();
return cuid;
}
//根据电话号码查询客户编号
public static string getCuidByPone(string phone)
{
string cuid = null;
OLEDB mydb = Agentwork.db;
object o = mydb.ExecuteScalar( sqlback + " where phn2='" + phone+"'");
if( o != null )
cuid = o.ToString();
return cuid;
}
//拆分电话区号和号码
public static string getAreaCode(string ani)
{
string phn = null;
OLEDB mydb = Agentwork.db;
object o = mydb.ExecuteScalar( "select fun_getareacode('"+ani+"') from dual");
if( o != null )
phn = o.ToString();
return phn;
}
//设置DataGrid行的颜色
public static void setColor(DataGridItem dgi,string txt)
{
switch (txt)
{
case "完成":
dgi.BackColor= System.Drawing.Color.PaleGreen ;
break;
case "取消":
dgi.BackColor= System.Drawing.Color.Silver ;
break;
case "订购":
dgi.BackColor= System.Drawing.Color.LightPink ;
break;
default :
dgi.BackColor= System.Drawing.Color.White;
break;
}
}
//字符型转化为数字
public static int TextToInt(string val) { if(val==string.Empty||val==null)return 0; try { int a=int.Parse(val); return a; } catch
{ return 0; } }
public static double TextToDouble(string val) { if(val==string.Empty||val==null)return 0; try { double a=double.Parse(val); return a; } catch
{ return 0; } }
public static string TextToSDate(string val)
{
try
{
System.DateTime dtime=System.DateTime.Parse(val);
return dtime.ToShortDateString();
}
catch
{
return val;
}
}
public static string TextToSTime(string val)
{
try
{
System.DateTime dtime=System.DateTime.Parse(val);
return dtime.ToLongTimeString();
}
catch
{
return val;
}
}
public static DateTime TextToDateTime(string val)
{
if(val==string.Empty||val==null)
return System.DateTime.MinValue;
try
{
System.DateTime dtime=System.DateTime.Parse(val);
return dtime;
}
catch
{
return System.DateTime.MinValue;
}
}
public static void DDL_Select(DropDownList ddl,string val)
{
if(ddl.SelectedItem!=null)
{
ddl.SelectedItem.Selected=false;
}
for(int i=0;i<ddl.Items.Count;i++)
{
ListItem li=ddl.Items[i];
if(li.Value==val)
{
li.Selected=true;
break;
}
}
}
public static void DDL_Select(RadioButtonList c,string val)
{
if(c.SelectedItem!=null)
{
c.SelectedItem.Selected=false;
}
for(int i=0;i<c.Items.Count;i++)
{
ListItem li=c.Items[i];
if(li.Value==val)
{
li.Selected=true;
break;
}
}
}
public static string getWeek(string sweek) { string s="" ; switch (sweek) { case "Monday": s = "1" ; break ; case "Tuesday": s = "2" ; break; case "Wednesday": s = "3" ; break ; case "Thursday": s = "4" ; break ; case "Friday": s = "5" ; break ; case "Saturday": s = "6" ; break ; case "Sunday": s = "7" ; break ; } return(s); }
//通话结束时选择的类型是否必须选产品
public static bool IsMustSelect(string type)
{
if(strcall.IndexOf(type)<0)
return false;
else
return true;
}
//绑定同一个组的用户到下拉框
public static void DDL_GroupUsr(DropDownList c,string id)
{
if(User.Rows.Count==0)
{
c.Enabled=false;
return;
}
c.Items.Clear();
c.Items.Add("");
DataRow[] drs=User.Select("defgrp='" + id +"'");
DataTable dt=User.Clone();
for(int i=0;i<drs.Length;i++)
{
ListItem it=new ListItem(drs[i]["name"].ToString(),drs[i]["usrid"].ToString());
c.Items.Add(it);
}
}
//绑定同一个组的用户到DataGrid
public static void DG_GroupUsr(DataGrid dg,string id)
{
if(User.Rows.Count==0)
return;
DataRow[] drs=User.Select("defgrp='" + id +"'");
DataTable dt=User.Clone();
for(int i=0;i<drs.Length;i++)
{
DataRow dr=dt.NewRow();
dr.ItemArray=drs[i].ItemArray;
dt.Rows.Add(dr);
}
dg.DataSource=dt;
dg.DataBind();
}
//绑定同一个组的用户到DataGrid
public static void DG_Group(DataGrid dg,DataTable dt)
{
if(Group.Rows.Count==0)
return;
dt=Group.Copy();
dg.DataSource=dt;
dg.DataBind();
}
public static void DDL_Init(DropDownList c,string id,string text,string val)
{
if(Names.Rows.Count==0)
{
c.Enabled=false;
return;
}
c.Items.Clear();
ListItem itf=new ListItem(text,val);
c.Items.Add(itf);
DataRow[] drs=Names.Select("tid='" + id +"'");
DataTable dt=Names.Clone();
for(int i=0;i<drs.Length;i++)
{
ListItem it=new ListItem(drs[i]["dsc"].ToString(),drs[i]["id"].ToString());
c.Items.Add(it);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -