public static int UpdateEnInfoByID(EnInfoModel f)
{
string sql = "update T_EnInfo set F_EnName=@F_EnName,F_EnAddr=@F_EnAddr,F_Lang=@F_Lang,F_EnContact=@F_EnContact,F_Keywords=@F_Keywords,F_EnDesc=@F_EnDesc,F_EnContent=@F_EnContent,F_EnOnline=@F_EnOnline where ID=@ID";
OleDbParameter[] parameter = new OleDbParameter[8];
parameter[0] = new OleDbParameter("@F_EnName", OleDbType.VarChar);
parameter[0].Value = f.EnName;
parameter[1] = new OleDbParameter("@F_EnAddr", OleDbType.VarChar);
parameter[1].Value = f.EnAddr;
parameter[2] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[2].Value = f.Lang;
parameter[3] = new OleDbParameter("@F_EnContact", OleDbType.VarChar);
parameter[3].Value = f.EnContact;
parameter[4] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[4].Value = f.EnKeywords;
parameter[5] = new OleDbParameter("@F_EnDesc", OleDbType.VarChar);
parameter[5].Value = f.EnDesc;
parameter[6] = new OleDbParameter("@F_EnContent", OleDbType.VarChar);
parameter[6].Value = f.EnDetail;
parameter[7] = new OleDbParameter("@F_EnOnline", OleDbType.VarChar);
parameter[7].Value = f.EnOnlineContact;
parameter[8] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[8].Value = f.ID;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static int UpdateEnInfoByLang(EnInfoModel f)
{
try {
string sql = "update T_EnInfo set F_EnName=@F_EnName,F_EnAddr=@F_EnAddr,F_EnContact=@F_EnContact,F_Keywords=@F_Keywords,F_EnDesc=@F_EnDesc,F_EnContent=@F_EnContent,F_EnOnline=@F_EnOnline where F_Lang=@F_Lang";
OleDbParameter[] parameter = new OleDbParameter[8];
parameter[0] = new OleDbParameter("@F_EnName", OleDbType.VarChar);
parameter[0].Value = f.EnName;
parameter[1] = new OleDbParameter("@F_EnAddr", OleDbType.VarChar);
parameter[1].Value = f.EnAddr;
parameter[2] = new OleDbParameter("@F_EnContact", OleDbType.VarChar);
parameter[2].Value = f.EnContact;
parameter[3] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[3].Value = f.EnKeywords;
parameter[4] = new OleDbParameter("@F_EnDesc", OleDbType.VarChar);
parameter[4].Value = f.EnDesc;
parameter[5] = new OleDbParameter("@F_EnContent", OleDbType.VarChar);
parameter[5].Value = f.EnDetail;
parameter[6] = new OleDbParameter("@F_EnOnline", OleDbType.VarChar);
parameter[6].Value = f.EnOnlineContact;
parameter[7] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[7].Value = f.Lang;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}catch (Exception es) {
throw new Exception(es.Message + f.EnName + "," + f.EnAddr + "," + f.EnContact + "," + f.EnDesc + "," + f.EnKeywords + "," + f.Lang + "," + f.ID);
}
}
/// <summary>
/// 获取类别
/// </summary>
/// <param name="parentid"></param>
/// <returns></returns>
public static List <ProClassModel> GetProClassListByLang(int lang, int parentid)
{
string sql = "select * from T_ProClass where F_ParentID = ? And F_Lang=? order by F_Sort desc";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_ParentID", OleDbType.Integer);
parameter[0].Value = parentid;
parameter[1] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[1].Value = lang;
List <ProClassModel> list = new List <ProClassModel>();
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
ProClassModel proclass = null;
while (dr.Read())
{
proclass = new ProClassModel();
proclass.ID = Convert.ToInt32(dr["ID"].ToString());
proclass.F_ClassName = dr["F_ClassName"].ToString();
proclass.F_ParentID = Convert.ToInt32(dr["F_ParentID"]);
proclass.F_Sort = Convert.ToInt32(dr["F_Sort"]);
list.Add(proclass);
}
dr.Close();
dr.Dispose();
return(list);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int UpdateByid(DownloadsModel s)
{
string sql = "update T_Downloads set F_FileType=?,F_Content=?,F_Size=?,F_Desc=?,F_Keywords=?,F_Title=?,F_FileImage=?,F_FileSmallImage=? where ID=?";
OleDbParameter[] parameter = new OleDbParameter[9];
parameter[0] = new OleDbParameter("@F_FileType", OleDbType.Integer);
parameter[1] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[2] = new OleDbParameter("@F_Size", OleDbType.VarChar, 200);
parameter[3] = new OleDbParameter("@F_Desc", OleDbType.VarChar, 500);
parameter[4] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[5] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[6] = new OleDbParameter("@F_FileImage", OleDbType.VarChar);
parameter[7] = new OleDbParameter("@F_FileSmallImage", OleDbType.VarChar);
parameter[8] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = s.F_FileType;
parameter[1].Value = s.F_Content;
parameter[2].Value = s.F_Size;
parameter[3].Value = s.F_Desc;
parameter[4].Value = s.F_Keywords;
parameter[5].Value = s.F_Title;
parameter[6].Value = s.F_FileImage;
parameter[7].Value = s.F_FileSmallImage;
parameter[8].Value = s.ID;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static ProClassModel GetParentName(int parentid)
{
string sql = "select * from T_ProClass where ID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = parentid;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
ProClassModel proclass = null;
if (dr.Read())
{
proclass = new ProClassModel();
proclass.ID = Convert.ToInt32(dr["ID"].ToString());
proclass.F_ClassName = dr["F_ClassName"].ToString();
proclass.F_ParentID = Convert.ToInt32(dr["F_ParentID"]);
proclass.F_Sort = Convert.ToInt32(dr["F_Sort"]);
}
dr.Close();
dr.Dispose();
return(proclass);
}
/// <summary>
/// 获取留言，分页
/// </summary>
/// <param name="number"></param>
/// <param name="pagesize"></param>
/// <returns></returns>
public static List <GuestBookModel> GetGuestBookListByLang(int lang, int number, int pagesize)
{
string sql = "select top " + pagesize + " * from (select top " + number + " * from [T_GuestBook] where F_Lang=" + lang + " order by ID asc) order by ID desc";
List <GuestBookModel> list = new List <GuestBookModel>();
OleDbDataReader dr = AccessorDB.ExecuteReader(sql);
GuestBookModel g = null;
while (dr.Read())
{
g = new GuestBookModel();
g.ID = Convert.ToInt32(dr["ID"]);
g.F_Contacts = dr["F_Contacts"].ToString();
g.F_Way = dr["F_Way"].ToString();
g.F_Content = dr["F_Content"].ToString();
g.F_IP = dr["F_IP"].ToString();
g.F_Date = Convert.ToDateTime(dr["F_Date"]);
g.F_Replay = dr["F_Replay"].ToString();
g.F_Lang = Convert.ToInt32(dr["F_Lang"]);
list.Add(g);
}
dr.Close();
dr.Dispose();
return(list);
}
/// <summary>
/// 获取所有销售网络数据
/// </summary>
/// <returns></returns>
public static List <DownloadsModel> GetDownloadsListByLang(int lang, int number, int pagesize)
{
if (number == 0)
{
number = 1;
}
string sql = "select top " + pagesize + " * from (select top " + number + " * from T_Downloads where F_Lang=" + lang + " order by ID asc) order by ID desc";
List <DownloadsModel> list = new List <DownloadsModel>();
DownloadsModel s = null;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql);
while (dr.Read())
{
s = new DownloadsModel();
s.F_Size = dr["F_Size"].ToString();
s.F_Desc = dr["F_Desc"].ToString();
s.F_Keywords = dr["F_Keywords"].ToString();
s.F_Content = dr["F_Content"].ToString();
s.F_FileType = Convert.ToInt32(dr["F_FileType"]);
s.F_Date = Convert.ToDateTime(dr["F_Date"]);
s.ID = Convert.ToInt32(dr["ID"]);
s.F_Title = dr["F_Title"].ToString();
s.F_FileImage = dr["F_FileImage"].ToString();
s.F_FileSmallImage = dr["F_FileSmallImage"].ToString();
list.Add(s);
}
dr.Close();
dr.Dispose();
return(list);
}
/// <summary>
/// 获取一条新闻
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static NewsModel GetNewsByID(int id)
{
string sql = "select t1.ID,t1.F_Title,t1.F_Content,t1.F_Date,t1.F_Location,t1.F_ParentID,t1.F_Keywords,t2.F_ClassName from T_News t1,T_NewsClass t2 where t1.F_ParentID=t2.ID And t1.ID=?";
//throw new Exception(sql);
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = id;
NewsModel a = new NewsModel();
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
if (dr.Read())
{
a.ID = Convert.ToInt32(dr["ID"]);
a.F_Title = dr["F_Title"].ToString();
a.F_Content = dr["F_Content"].ToString();
a.F_Date = Convert.ToDateTime(dr["F_Date"]);
a.F_Location = dr["F_Location"].ToString();
a.F_ParentID = Convert.ToInt32(dr["F_ParentID"]);
a.F_Keyword = dr["F_Keywords"].ToString();
a.F_ClassName = dr["F_ClassName"].ToString();
}
dr.Close();
dr.Dispose();
return(a);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static int ADD(DownloadsModel s)
{
string sql = "insert into T_Downloads(F_FileType,F_Content,F_Size,F_Desc,F_Keywords,F_Lang,F_Title,F_FileImage,F_FileSmallImage) values(?,?,?,?,?,?,?,?,?)";
OleDbParameter[] parameter = new OleDbParameter[9];
parameter[0] = new OleDbParameter("@F_FileType", OleDbType.Integer);
parameter[1] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[2] = new OleDbParameter("@F_Size", OleDbType.VarChar, 200);
parameter[3] = new OleDbParameter("@F_Desc", OleDbType.VarChar, 500);
parameter[4] = new OleDbParameter("@F_Keywords", OleDbType.VarChar);
parameter[5] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[6] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[7] = new OleDbParameter("@F_FileImage", OleDbType.VarChar);
parameter[8] = new OleDbParameter("@F_FileSmallImage", OleDbType.VarChar);
parameter[0].Value = s.F_FileType;
parameter[1].Value = s.F_Content;
parameter[2].Value = s.F_Size;
parameter[3].Value = s.F_Desc;
parameter[4].Value = s.F_Keywords;
parameter[5].Value = s.F_Lang;
parameter[6].Value = s.F_Title;
parameter[7].Value = s.F_FileImage;
parameter[8].Value = s.F_FileSmallImage;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static SysInfoModel GetSysInfoByType(int type, int lang)
{
string sql = "select * from T_SysInfo where F_InfoType=@InfoType And F_Lang=@Lang";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@InfoType", OleDbType.Integer);
parameter[1] = new OleDbParameter("@Lang", OleDbType.Integer);
parameter[0].Value = type;
parameter[1].Value = lang;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
SysInfoModel f = new SysInfoModel();
if (dr.Read())
{
f.ID = Convert.ToInt32(dr["ID"]);
f.Content = dr["F_Content"].ToString();
f.InfoType = Convert.ToInt32(dr["F_InfoType"].ToString());
f.Lang = Convert.ToInt32(dr["F_Lang"].ToString());
f.Title = dr["F_InfoTitile"].ToString();
}
dr.Close();
dr.Dispose();
return(f);
}
/// <summary>
/// 获取1条信息资料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DownloadsModel GetDownLoadsByID(int downid)
{
string sql = "select * from T_Downloads where ID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = downid;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
DownloadsModel s = new DownloadsModel();
if (dr.Read())
{
s.F_Size = dr["F_Size"].ToString();
s.F_Desc = dr["F_Desc"].ToString();
s.F_Keywords = dr["F_Keywords"].ToString();
s.F_Content = dr["F_Content"].ToString();
s.F_FileType = Convert.ToInt32(dr["F_FileType"]);
s.F_Date = Convert.ToDateTime(dr["F_Date"]);
s.ID = Convert.ToInt32(dr["ID"]);
s.F_Title = dr["F_Title"].ToString();
s.F_FileImage = dr["F_FileImage"].ToString();
s.F_FileSmallImage = dr["F_FileSmallImage"].ToString();
}
dr.Close();
dr.Dispose();
return(s);
}
/// <summary>
/// 获取公司简介
/// </summary>
/// <param name="id">查询参数</param>
/// <returns>返回公司简介实体</returns>
public static EnInfoModel GetEnInfoByLang(int Lang)
{
string sql = "select * from T_EnInfo where F_Lang=@F_Lang";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[0].Value = Lang;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
EnInfoModel f = null;
if (dr.Read())
{
f = new EnInfoModel();
f.ID = Convert.ToInt32(dr["ID"]);
f.EnName = dr["F_EnName"].ToString();
f.EnAddr = dr["F_EnAddr"].ToString();
f.Lang = Convert.ToInt32(dr["F_Lang"].ToString());
f.EnContact = dr["F_EnContact"].ToString();
f.EnKeywords = dr["F_Keywords"].ToString();
f.EnDesc = dr["F_EnDesc"].ToString();
f.EnDetail = dr["F_EnContent"].ToString();
f.EnOnlineContact = dr["F_EnOnline"].ToString();
}
dr.Close();
dr.Dispose();
return(f);
}
/// <summary>
/// 获取管理员信息
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static AdminModel GetAdminInfo(AdminModel u)
{
string sql = "select * from T_Admin where F_Name=? and F_Pass=?";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_Name", OleDbType.VarChar, 12);
parameter[0].Value = u.Name;
parameter[1] = new OleDbParameter("@F_Pass", OleDbType.VarChar, 32);
parameter[1].Value = u.Pass;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
AdminModel admin = new AdminModel();
if (dr.Read())
{
admin.Name = dr["F_Name"].ToString();
admin.Pass = dr["F_Pass"].ToString();
admin.Date = Convert.ToDateTime(dr["F_Date"]);
admin.Authority = Convert.ToInt32(dr["F_Authority"]);
}
return(admin);
// dr.Close();
// dr.Dispose();
}
/// <summary>
/// 获取记录总数
/// </summary>
/// <returns></returns>
public static int GetRecordCount()
{
string sql = "select count(1) from T_GuestBook";
int res;
res = AccessorDB.ExecuteScalar(sql);
return(res);
}
public static int GetRecordCountByClassid(int classid)
{
string sql = "select count(1) from T_News where F_ParentID=" + classid;
int res;
res = AccessorDB.ExecuteScalar(sql);
return(res);
}
/// <summary>
/// 获取文章记录总数
/// </summary>
/// <returns></returns>
public static int GetRecordCountByLang(int lang)
{
string sql = "select count(1) from T_Downloads where F_Lang=" + lang;
int res;
res = AccessorDB.ExecuteScalar(sql);
return(res);
}
/// <summary>
/// 是否存在该类产品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int IsPro(int id)
{
string sql = "select count(1) from T_Product where F_ProClassID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@F_ProClassID", OleDbType.Integer);
parameter[0].Value = id;
return(AccessorDB.ExecuteScalar(sql, parameter));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DeleteByID(int id)
{
string sql = "delete from T_AD where ID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = id;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="l"></param>
/// <returns></returns>
public static int AddLink(LinkModel l)
{
string sql = "insert into T_Link(F_LinkName,F_LinkUrl) values(?,?)";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_LinkName", OleDbType.VarChar, 50);
parameter[1] = new OleDbParameter("@F_LinkUrl", OleDbType.VarChar, 50);
parameter[0].Value = l.F_LinkName;
parameter[1].Value = l.F_LinkUrl;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public static int Add(AdModel a)
{
string sql = "insert into T_AD(F_Pic,F_Url) values(?,?)";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_Pic", OleDbType.VarChar, 100);
parameter[1] = new OleDbParameter("@F_Url", OleDbType.VarChar, 200);
parameter[0].Value = a.F_Pic;
parameter[1].Value = a.F_Url;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static int GetRecordCountByClassid(string classid, int provider, int mainclass)
{
string sql = string.Empty;
string providerstr = "false";
if (provider == 1)
{
providerstr = "true";
}
sql = "select count(1) from T_Product where (F_ProClassID in(" + classid + ") Or InStr(F_ProExtClass,'," + mainclass + ",')>0) And F_IsProvider=" + providerstr;
//throw new Exception("无记录" + sql);
return(AccessorDB.ExecuteScalar(sql));
}
/// <summary>
/// 添加管理员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(AdminModel model)
{
string sql = "insert into T_Admin(F_Name,F_Pass,F_Authority) values(?,?,?)";
OleDbParameter[] parameters = new OleDbParameter[3];
parameters[0] = new OleDbParameter("@F_Name", OleDbType.VarChar, 12);
parameters[0].Value = model.Name;
parameters[1] = new OleDbParameter("@F_Pass", OleDbType.VarChar, 32);
parameters[1].Value = model.Pass;
parameters[2] = new OleDbParameter("F_Authority", OleDbType.Integer);
parameters[2].Value = model.Authority;
return(AccessorDB.ExecuteInsert(sql, parameters));
}
public static int AddSysInfo(SysInfoModel f)
{
string sql = "insert into T_SysInfo(F_Content,F_InfoType,F_Lang,F_InfoTitle) values(@F_Content,@F_InfoType,@F_Lang,@F_Title)";
OleDbParameter[] parameter = new OleDbParameter[4];
parameter[0] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[0].Value = f.Content;
parameter[2] = new OleDbParameter("@F_InfoType", OleDbType.Integer);
parameter[2].Value = f.InfoType;
parameter[3] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[3].Value = f.Lang;
parameter[4] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[4].Value = f.Title;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="n"></param>
/// <param name="id"></param>
/// <returns></returns>
public static int UpdateProClass(string n, int id)
{
string sql = "update T_ProClass set F_ClassName=? where ID=?";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_ClassName", OleDbType.VarChar, 50);
parameter[1] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = n;
parameter[1].Value = id;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="l"></param>
/// <returns></returns>
public static int UpdateLink(LinkModel l)
{
string sql = "update T_Link set F_LinkName=?,F_LinkUrl=? where ID=?";
OleDbParameter[] parameter = new OleDbParameter[3];
parameter[0] = new OleDbParameter("@F_LinkName", OleDbType.VarChar, 50);
parameter[1] = new OleDbParameter("@F_LinkUrl", OleDbType.VarChar, 50);
parameter[2] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = l.F_LinkName;
parameter[1].Value = l.F_LinkUrl;
parameter[2].Value = l.ID;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public static int UpdateByID(AdModel a)
{
string sql = "update T_AD set F_Pic=?,F_Url=? where ID=? ";
OleDbParameter[] parameter = new OleDbParameter[3];
parameter[0] = new OleDbParameter("@F_Pic", OleDbType.VarChar, 100);
parameter[1] = new OleDbParameter("@F_Url", OleDbType.VarChar, 200);
parameter[2] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = a.F_Pic;
parameter[1].Value = a.F_Url;
parameter[2].Value = a.ID;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static int UpdateSysInfoByID(SysInfoModel f)
{
string sql = "update T_SysInfo set F_Content=@F_Content,F_InfoType=@F_InfoType,F_Lang=@F_Lang,F_InfoTitle=@F_Title where ID=@ID";
OleDbParameter[] parameter = new OleDbParameter[5];
parameter[0] = new OleDbParameter("@F_Content", OleDbType.VarChar);
parameter[0].Value = f.Content;
parameter[1] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[1].Value = f.ID;
parameter[2] = new OleDbParameter("@F_InfoType", OleDbType.Integer);
parameter[2].Value = f.InfoType;
parameter[3] = new OleDbParameter("@F_Lang", OleDbType.Integer);
parameter[3].Value = f.Lang;
parameter[4] = new OleDbParameter("@F_Title", OleDbType.VarChar);
parameter[4].Value = f.Title;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
public static int GetRecordCountByClassidByLang(int lang, int classid)
{
string sql = "select count(1) from T_News where F_ParentID=" + classid + " And F_Lang=" + lang;
if (classid == -1)
{
sql = "select count(1) from T_News where F_Lang=" + lang;
}
else
{
sql = "select count(1) from T_News where F_ParentID=" + classid + " And F_Lang=" + lang;
}
int res;
res = AccessorDB.ExecuteScalar(sql);
return(res);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="t"></param>
/// <returns>0失败，1成功</returns>
public static int AddProClass(ProClassModel t)
{
string sql = "insert into T_ProClass(F_ClassName,F_ParentID,F_Sort,F_Lang) values(@F_ClassName,@F_ParentID,@F_Sort,@F_Lang)";
OleDbParameter[] parameter = new OleDbParameter[4];
parameter[0] = new OleDbParameter("@F_ClassName", OleDbType.VarChar, 50);
parameter[1] = new OleDbParameter("@F_ParentID", OleDbType.Integer);
parameter[2] = new OleDbParameter("@F_Sort", OleDbType.Integer);
parameter[3] = new OleDbParameter("@F_Sort", OleDbType.Integer);
parameter[0].Value = t.F_ClassName;
parameter[1].Value = t.F_ParentID;
parameter[2].Value = t.F_Sort;
parameter[3].Value = t.F_Lang;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
/// <summary>
/// 根据产品类别获取产品分页功能
/// </summary>
/// <param name="number"></param>
/// <param name="pagesize"></param>
/// <param name="classid"></param>
/// <returns></returns>
public static List <ProModel> GetListPageNoByClassID(int number, int pagesize, string classid, int provider, int mainclass)
{
string sql = string.Empty;
string providerstr = "false";
if (provider == 1)
{
providerstr = "true";
}
sql = "select top " + pagesize + " * from (select top " + number + " * from T_Product where (F_ProClassID in(" + classid + ") Or InStr(F_ProExtClass,'," + mainclass + ",')>0) And F_IsProvider=" + providerstr + " order by ProID asc) order by ProID desc";
List <ProModel> list = new List <ProModel>();
ProModel p = null;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql);
while (dr.Read())
{
p = new ProModel();
p.ProID = Convert.ToInt32(dr["ProID"]);
p.F_ProName = dr["F_ProName"].ToString();
p.F_Proattributes = dr["F_Proattributes"].ToString();
p.F_ProDescription = dr["F_ProDescription"].ToString();
p.F_ProSize = dr["F_ProSize"].ToString();
p.F_ProSizeTable = dr["F_ProSizeTable"].ToString();
p.F_ProWashing = dr["F_ProWashing"].ToString();
p.F_ProClassID = Convert.ToInt32(dr["F_ProClassID"]);
p.F_Date = Convert.ToDateTime(dr["F_Date"]);
p.F_Sort = Convert.ToInt32(dr["F_Sort"]);
p.F_IsProvider = Convert.ToBoolean(dr["F_IsProvider"]);
p.F_Pic = dr["F_ProPic"].ToString();
p.F_ExtClass = dr["F_ProExtClass"].ToString();
p.F_SmallPic = dr["F_ProSmallPic"].ToString();
// p.F_ClassName = dr["F_ClassName"].ToString();
p.F_IsTop = Convert.ToBoolean(dr["F_IsTop"]);
list.Add(p);
}
//throw new Exception("无记录" + sql);
dr.Close();
dr.Dispose();
return(list);
}
