📄 tj_search.aspx.cs
字号:
}
else
{
if(thewhich=="vOS")
{
for(int intindexofvsoft=0;intindexofvsoft<stros.Length;intindexofvsoft++)
{
if(stros[intindexofvsoft]==dv1[i].Row[thewhich].ToString())
{
aryindex=intindexofvsoft;
break;
}
}
}
else
{
aryindex=int.Parse(dv1[i].Row[thewhich].ToString());
}
}
val[aryindex]=int.Parse(dv1[i].Row["theval"].ToString());
if(val[aryindex]>themax) themax=val[aryindex];
thesum+=val[aryindex];
}
dv1.Dispose();
//防止除数为0而出错
if(themax==0) themax=1;
if(thesum==0) thesum=1;
//计算百分数
for(int i=0;i<thehow;i++) theper[i]=(int)(int.Parse(val[i].ToString())*1000/thesum)/10;
//如果查询项目是星期，则转alt为汉字
if(thewhich=="vweek")
{
for(int i=0;i<thehow;i++) alt[i]=strweek[int.Parse(alt[i].ToString())];
}
//调用HengOut子程序输出到浏览器
return HengOut(statname,tuwidth,themax,thehow,val,alt,theper,unit);
}
//显示分析图表的子程序(横)
public string HengOut(string statname,int tuwidth,int themax,int tuhow,int[] val,string[] alt,int[] theper,string unit)
{
//statname 报告名称
//tuwidth 横图每栏宽度
//themax x坐标最大值
//tuhow 柱图有多少栏
//val() x坐标值数组
//alt() x坐标文字
//theper() 柱图百分数
//unit x坐标单位
string show_data_msg="<table width='500' cellspacing='0' align='center' cellpadding='0' border='0'><tr><td colspan='3'><img src='images/photoup.gif'></td></tr><tr height='30'><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td><td width='498'class='backq'>";
show_data_msg+=" <img src='images/tb_title.gif' align=absmiddle> ∷∷∷ "+statname+" ∷∷∷<br><table border='0' cellpadding='0' cellspacing='0' width='"+(int)(tuhow*tuwidth+70)+"' align=center><tr height='9'><td></td></tr><tr height='101'><td align=right valign=top>";
show_data_msg+="<p style='line-height: 100%; margin-right: 2; margin-top: 0; margin-bottom: 13'><font face='Arial'>"+((int)((float)(themax)*10+0.5)/10).ToString()+"</font>";
show_data_msg+="<p style='line-height: 100%; margin-right: 2; margin-top: 0; margin-bottom: 13'><font face='Arial'>"+((float)(int)((3*(float)(themax)*10/4)+0.5)/10).ToString()+"</font>";
show_data_msg+="<p style='line-height: 100%; margin-right: 2; margin-top: 0; margin-bottom: 13'><font face='Arial'>"+((float)(int)(((float)(themax)*10/2)+0.5)/10).ToString()+"</font>";
show_data_msg+="<p style='line-height: 100%; margin-right: 2; margin-top: 0; margin-bottom: 0'><font face='Arial'>"+((float)(int)(((float)(themax)*10/4)+0.5)/10).ToString()+"<br></font></td>";
show_data_msg+="<td width=10><img src='images/tu_back_left.gif'></td>";
for(int i=0;i<tuhow;i++)
{
if((unit=="日" || unit=="月") && i==0) continue;
show_data_msg+="<td width='"+tuwidth+"' valign=bottom background='images/tu_back.gif' align=center>";
show_data_msg+="<img style='BORDER-BOTTOM: #000000 1px solid;' src='images/tu.gif'";
show_data_msg+="height='"+(int)(float.Parse(val[i].ToString())/themax*100)+"' width='9'";
show_data_msg+="alt='"+alt[i]+unit+"，访问"+val[i]+"次，"+theper[i]+"%'></td>";
}
string show_data_msg1="<td width=10><img src='images/tu_back_right.gif'></td><td width=10></td></tr><tr height='18'><td align=right><p style='line-height: 100%; margin-right: 2; margin-top: 0; margin-bottom: 0'><font face='Arial'>0</font></td><td width=10></td>";
for(int i=0;i<tuhow;i++)
{
if((unit=="日" || unit=="月") && i==0) continue;
show_data_msg1+="<td width='"+tuwidth+"' align=center><a title='";
show_data_msg1+=alt[i]+unit+"，访问"+val[i]+"次，";
show_data_msg1+=theper[i]+"%'><font style='letter-spacing: -1'>";
if(unit=="日")
{
if(i%2!=0) show_data_msg1+=alt[i];
}
else
{
show_data_msg1+=alt[i];
}
show_data_msg1+="</font></a></td>";
}
show_data_msg1+="<td width=10></td><td width=10></td></tr><tr height='5'><td></td></tr></table></td><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td></tr><tr><td colspan='4'><img src='images/photodown.gif'></td></tr></table><br>";
return show_data_msg+show_data_msg1;
}
//输出图表数据的子程序(竖)
public string StatShu(string statname,int leftwidth,string thewhich,string wherestr,bool linkflag)
{
//statname 报告名称
//leftwidth 横图每栏宽度
//thewhich 要查询的项目
//wherestr 查询条件
//linkflag 是否需要链接
string theSql="select " + thewhich + ",count(id) as theval from CounterView " + wherestr + " group by " + thewhich + " order by count(id) DESC";
DataSet myds1=new DataSet();
DataView dv1=new DataView();
myds1=counter.SQLConn.ExecuteSqlForDataSet(theSql);
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
int themax=0;
int thesum=0;
int tuhow=dv1.Count;
if(tuhow>99) tuhow=100;
//声明输出内容数组变量
int[] val=new int[tuhow];
string [] alt=new string[tuhow];
string [] alta=new string[tuhow];
int[] theper=new int[tuhow];
int k=0;
for(int j=0;j<dv1.Count;j++)
{
alta[k]=dv1[j].Row[thewhich].ToString();
if(thewhich=="vcome" || thewhich=="vpage")
{
int thelen=alta[k].Length;
if(thelen==0)
{
alta[k]="#";
alt[k]="通过收藏或直接输入网址访问";
}
if(thelen>0 && thelen<=33)
{
alt[k]=alta[k];
}
if(thelen>33)
{
alt[k]=alta[k].Substring(0,31)+"...";
}
}
else
{
alt[k]=alta[k];
}
val[k]=int.Parse(dv1[j].Row["theval"].ToString());
if(val[k]>themax) themax=val[k];
thesum+=val[k];
if(k==99) break;
k++;
}
//防止除数为0而出错
if(themax==0) themax=1;
if(thesum==0) thesum=1;
//计算百分数
for(int i=0;i<tuhow;i++) theper[i]=(int)(int.Parse(val[i].ToString())*1000/thesum)/10;
//如果查询项目是星期，则转alt为汉字
if(thewhich=="vweek")
{
for(int i=0;i<tuhow;i++) alt[i]=strweek[int.Parse(alt[i].ToString())];
}
//调用HengOut子程序输出到浏览器
return ShuOut(statname,leftwidth,themax,tuhow,val,alt,alta,theper,linkflag);
}
//显示分析图表的子程序(竖)
public string ShuOut(string statname,int leftwidth,int themax,int tuhow,int[] val,string []alt,string []alta,int[] theper,bool linkflag)
{
//statname 报告名称
//leftwidth 图表左边留给文字的宽度
//themax x坐标最大值
//tuhow 多少行记录
//val() 记录的值(访问数)
//alt() 说明文字
//alta() 文字的连接
//theper() 柱图百分数
//linkflag 是否需要链接
string show_data_msg="<table width='500' cellspacing='0' align='center' cellpadding='0' border='0'><tr><td colspan='3'><img src='images/photoup.gif'></td></tr><tr height='30'><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td><td width='498'class='backq'>";
show_data_msg+=" <img src='images/tb_title.gif' align=absmiddle> ∷∷∷ "+statname+" ∷∷∷<br>";
show_data_msg+="<table border='0' cellpadding='0' cellspacing='0' width='"+(int)(leftwidth+230)+"' align=center><tr height='9'><td></td></tr>";
show_data_msg+="<tr height='10'><td width='"+leftwidth+"'></td><td width='230'><img src='images/tu_back_up.gif'></td></tr>";
for(int i=0;i<tuhow;i++)
{
show_data_msg+="<tr><td width='220' align=right><a ";
if(linkflag) show_data_msg+="href='"+alta[i]+"' target='_blank' ";
show_data_msg+=" title='"+alta[i]+" ，访问"+val[i]+"次，"+theper[i]+"%'>"+alt[i]+"</a> </td>";
show_data_msg+="<td width='230' background='images/tu_back_2.gif' align=left>";
show_data_msg+="<img style='BORDER-left: #000000 1px solid;' src='images/tu.gif' width='"+(int)(float.Parse(val[i].ToString())/themax*183)+"' height='9' alt='"+alta[i]+" ，访问"+val[i]+"次，"+theper[i]+"%'> "+val[i]+"</td></tr>";
}
string show_data_msg1="<tr height='10'><td width='220'></td><td width='230'><img src='images/tu_back_down.gif'></td></tr><tr height='5'><td></td></tr></table></td><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td></tr><tr><td colspan='4'><img src='images/photodown.gif'></td></tr></table><br>";
return show_data_msg+show_data_msg1;
}
//显示原来保存的自定义检索
public void show_search_save()
{
string theSql="select * from mysave";
DataSet myds1=new DataSet();
DataView dv1=new DataView();
myds1=counter.SQLConn.ExecuteSqlForDataSet(theSql);
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
string save_msg="";
if(dv1.Count>0)
{
save_msg+="<table width='500' cellspacing='0' align='center' cellpadding='0' border='0'><tr><td colspan='3'><img src='images/photoup.gif'></td></tr><tr height='30'><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td><td width='498'class='backq'> <img src='images/tb_title.gif' align=absmiddle><font style='font-size:16px'> </font>∷∷∷ 已保存的检索条件 ∷∷∷<br><br>";
save_msg+="<table width='430' border='0' cellspacing=0 cellpadding=0 align=center><tr height='1' class='backs'><td colspan=2><img src='images/touming.gif' width='1' height='1'></td></tr>";
for(int i=0;i<dv1.Count;i++)
{
save_msg+="<form name='do_save"+i+"' action='tj_search.aspx' method=post><tr height='28'><td>□ <font class=fonts>"+dv1[i].Row["name"].ToString()+"</font></td><td align=right>";
save_msg+="<input name='content' type='hidden' value=\""+dv1[i].Row["content"]+"\">";
save_msg+="<input type='hidden' name='wherestr' value=\""+dv1[i].Row["wherestr"]+"\">";
save_msg+="<input type='hidden' name='outtype' value=\""+dv1[i].Row["outtype"]+"\">";
save_msg+="<input type='hidden' name='wherename' value=\""+dv1[i].Row["name"]+"\">";
if(Session["master"].ToString() == "master" || int.Parse(Session["whatcan"].ToString()) >=6)
{
save_msg+="<a href='javascript:dodel("+dv1[i].Row["id"]+")'>删除</a> ";
}
save_msg+="<a href='javascript:do_save"+i+".submit();'>查看结果</a> <input type='submit' value=' ' name='save' class='backc2'> </td></tr>";
if(dv1[i].Row["content"].ToString()!="") save_msg+="<tr><td colspan=2><p style='text-indent: 25;line-height: 130%;margin-left: 17;margin-right: 5;margin-top: 0;margin-bottom: 5'><font color='#555555'>"+dv1[i].Row["content"]+"</font></td></tr>";
save_msg+="<tr height='1' class='backs'><td colspan=2><img src='images/touming.gif' width='1' height='1'></td></tr></form>";
}
save_msg+="</table><br></td><td width='1' class='backs'><img src='images/touming.gif' width='1' height='1'></td></tr><tr><td colspan='4'><img src='images/photodown.gif'></td></tr></table><br>";
if(Session["master"].ToString() == "master" || int.Parse(Session["whatcan"].ToString()) >=6)
{
save_msg+="<form name='do_del' action='tj_del.aspx' method='post'>";
save_msg+="<input type='hidden' name='delid' value=''>";
save_msg+="</form>";
save_msg+="<script>function dodel(doid){do_del.delid.value=doid;do_del.submit();}</script>";
}
}
dv1.Dispose();
Response.Write(save_msg);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -