📄 ads.cs
字号:
}
public DataTable getAdsPicInfo(string col, string tbname, string id)
{
SqlParameter param = new SqlParameter("@AdID", id);
string str_Sql = "Select " + col + " From " + Pre + tbname + " Where AdID=@AdID";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, param);
}
public DataTable getAdsInfo(string id)
{
string str_Sql = "Select AdID,adName,ClassID,CusID,adType,leftPic,rightPic,leftSize,rightSize,LinkURL,CycTF,CycAdID,CycSpeed,CycDic" +
",CondiTF,maxShowClick,TimeOutDay,maxClick,creatTime,AdTxtNum,isLock From " + Pre +
"ads Where AdID='" + id + "'";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable get24HourStat(string type, string id)
{
string str_Sql = "";
if (type == "1")
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "' And datediff(hour,creatTime,getDate())" +
" < 24 And datediff(hour,creatTime,getDate()) >=0";
}
else
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "'";
}
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getDayStat(string type, string id, string mday)
{
string str_Sql = "";
if (type == "1")
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "' And datediff(day,creatTime,getDate()) " +
"<= " + mday + " And datediff(hour,creatTime,getDate()) >=0";
}
else
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "'";
}
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getMonthStat(string type, string id)
{
string str_Sql = "";
if (type == "1")
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "' And " +
"datediff(month,creatTime,getDate()) < 13 And datediff(hour,creatTime,getDate()) >=0";
}
else
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "'";
}
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getYearStat(string id)
{
string str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "' And datediff(year,creatTime,getDate())=datediff(year,getDate(),getDate())"; ;
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getWeekStat(string type, string id)
{
string str_Sql = "";
if (type == "1")
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "' And datediff(w,creatTime,getDate()) < 8 And datediff(w,creatTime,getDate()) >=0";
}
else
{
str_Sql = "Select creatTime From " + Pre + "ads_stat Where AdID='" + id + "'";
}
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getSourceStat(string id)
{
string str_Sql = "Select AdID,Address,Count(IP) as Ipnum from " + Pre + "ads_stat group by AdID,Address having AdID=" + id + " order by Count(IP) desc";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getDbNull()
{
string str_Sql = "Select ID,IP From " + Pre + "ads_stat Where Address is Null or Address=''";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public void upStat(string adress, string id)
{
string str_Sql = "Update " + Pre + "ads_stat Set Address='" + adress + "' where ID='" + id + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, str_Sql, null);
}
public void upShowNum(string id)
{
SqlParameter param = new SqlParameter("@AdID", id);
string str_Sql = "Update " + Pre + "ads Set ShowNum=ShowNum+1 Where AdID=@AdID";
DbHelper.ExecuteNonQuery(CommandType.Text, str_Sql, param);
}
public void upClickNum(string id, string type)
{
SqlParameter param = new SqlParameter("@AdID", id);
string str_Sql = "Update " + Pre + "ads Set ClickNum=ClickNum+1 Where AdID=@AdID";
DbHelper.ExecuteNonQuery(CommandType.Text, str_Sql, param);
}
public void addStat(string id, string ip)
{
SqlParameter param = new SqlParameter("@ID", id);
string str_Sql = "Insert Into " + Pre + "ads_stat(AdID,IP,creatTime) Values(@ID,'" + ip + "','" + DateTime.Now.ToString() + "')";
DbHelper.ExecuteNonQuery(CommandType.Text, str_Sql, param);
}
public DataTable getClassAdprice(string classid)
{
string str_Sql = "Select Adprice From " + Pre + "ads_class Where AcID='" + classid + "'";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public DataTable getuserG()
{
string str_Sql = "Select gPoint From " + Pre + "sys_User Where UserNum='" + NetCMS.Global.Current.UserNum + "'";
return DbHelper.ExecuteTable(CommandType.Text, str_Sql, null);
}
public void DelUserG(int Gnum)
{
string str_Sql = "Update " + Pre + "sys_User Set gPoint=gPoint-" + Gnum + " Where UserNum='" + NetCMS.Global.Current.UserNum + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, str_Sql, null);
}
private SqlParameter[] GetAdsParameters(NetCMS.Model.AdsInfo ai)
{
SqlParameter[] param = new SqlParameter[24];
param[0] = new SqlParameter("@AdID", SqlDbType.NVarChar, 15);
param[0].Value = ai.AdID;
param[1] = new SqlParameter("@adName", SqlDbType.NVarChar, 50);
param[1].Value = ai.adName;
param[2] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
param[2].Value = ai.ClassID;
param[3] = new SqlParameter("@CusID", SqlDbType.NVarChar, 12);
param[3].Value = ai.CusID;
param[4] = new SqlParameter("@adType", SqlDbType.TinyInt, 1);
param[4].Value = ai.adType;
param[5] = new SqlParameter("@leftPic", SqlDbType.NVarChar, 200);
param[5].Value = ai.leftPic;
param[6] = new SqlParameter("@rightPic", SqlDbType.NVarChar, 200);
param[6].Value = ai.rightPic;
param[7] = new SqlParameter("@leftSize", SqlDbType.NVarChar, 12);
param[7].Value = ai.leftSize;
param[8] = new SqlParameter("@rightSize", SqlDbType.NVarChar, 12);
param[8].Value = ai.rightSize;
param[9] = new SqlParameter("@CycTF", SqlDbType.TinyInt, 1);
param[9].Value = ai.CycTF;
param[10] = new SqlParameter("@CycAdID", SqlDbType.NVarChar, 15);
param[10].Value = ai.CycAdID;
param[11] = new SqlParameter("@CycSpeed", SqlDbType.Int, 4);
param[11].Value = ai.CycSpeed;
param[12] = new SqlParameter("@CycDic", SqlDbType.TinyInt, 1);
param[12].Value = ai.CycDic;
param[13] = new SqlParameter("@ClickNum", SqlDbType.Int, 4);
param[13].Value = ai.ClickNum;
param[14] = new SqlParameter("@ShowNum", SqlDbType.Int, 4);
param[14].Value = ai.ShowNum;
param[15] = new SqlParameter("@CondiTF", SqlDbType.TinyInt, 1);
param[15].Value = ai.CondiTF;
param[16] = new SqlParameter("@maxShowClick", SqlDbType.Int, 4);
param[16].Value = ai.maxShowClick;
param[17] = new SqlParameter("@TimeOutDay", SqlDbType.DateTime, 8);
param[17].Value = ai.TimeOutDay;
param[18] = new SqlParameter("@maxClick", SqlDbType.Int, 4);
param[18].Value = ai.maxClick;
param[19] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
param[19].Value = ai.creatTime;
param[20] = new SqlParameter("@AdTxtNum", SqlDbType.Int, 4);
param[20].Value = ai.AdTxtNum;
param[21] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
param[21].Value = ai.isLock;
param[22] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[22].Value = ai.SiteID;
param[23] = new SqlParameter("@LinkURL", SqlDbType.NVarChar, 200);
param[23].Value = ai.LinkURL;
return param;
}
private SqlParameter[] GetClassParameters(NetCMS.Model.AdsClassInfo aci)
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@AcID", SqlDbType.NVarChar, 12);
param[0].Value = aci.AcID;
param[1] = new SqlParameter("@Cname", SqlDbType.NVarChar, 50);
param[1].Value = aci.Cname;
param[2] = new SqlParameter("@ParentID", SqlDbType.NVarChar, 12);
param[2].Value = aci.ParentID;
param[3] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
param[3].Value = aci.creatTime;
param[4] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[4].Value = aci.SiteID;
param[5] = new SqlParameter("@Adprice", SqlDbType.Int, 4);
param[5].Value = aci.Adprice;
return param;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -