/// <summary>
/// 获取所有的广告信息
/// </summary>
/// <returns></returns>
public List <AdvertmentModel> GetAllAdvertments()
{
string strCommandText = "SELECT A_Id AS AId,A_Name AS AName,A_Url AS AUrl FROM a_info_table WHERE A_Status='N'";
List <AdvertmentModel> list = new List <AdvertmentModel>();
try
{
DataTable dt = MySQLHelper.GetDataTable(MySQLHelper.Conn, CommandType.Text, strCommandText, null);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AdvertmentModel advertObj = new AdvertmentModel();
advertObj.Id = Int32.Parse(dt.Rows[i]["AId"].ToString());
advertObj.Name = dt.Rows[i]["AName"].ToString();
advertObj.Url = dt.Rows[i]["AUrl"].ToString();
list.Add(advertObj);
}
}
else
{
AdvertmentModel objAdvert = new AdvertmentModel();
objAdvert.Id = Int32.Parse("1");
objAdvert.Name = "";
objAdvert.Url = "";
list.Add(objAdvert);
}
return(list);
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message.ToString());
AdvertmentModel objAdvert = new AdvertmentModel();
objAdvert.Id = Int32.Parse("1");
objAdvert.Name = "";
objAdvert.Url = "";
list.Add(objAdvert);
return(list);
}
}
public bool AddAdvertment(AdvertmentModel item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
string strCommandText = "INSERT INTO a_info_table (A_Name,A_Url) VALUES(";
strCommandText += "\'" + item.Name + "\',";
strCommandText += "\'" + item.Url + "\'";
strCommandText += ");";
try
{
int iResult = MySQLHelper.ExecuteNonQuery(MySQLHelper.Conn, CommandType.Text, strCommandText, null);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取指定Id的广告信息详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public AdvertmentModel GetAdvertmentById(int id)
{
string strCommandText = "SELECT A_Id AS AId,A_Name AS AName,A_Url AS AUrl FROM a_info_table WHERE A_Status='N'";
strCommandText += " And A_Id='" + id.ToString() + "'";
AdvertmentModel objAdvert = new AdvertmentModel();
try
{
DataTable dt = MySQLHelper.GetDataTable(MySQLHelper.Conn, CommandType.Text, strCommandText, null);
if (dt.Rows.Count > 0)
{
objAdvert.Id = id;
objAdvert.Name = dt.Rows[0]["AName"].ToString();
objAdvert.Url = dt.Rows[0]["AUrl"].ToString();
}
return(objAdvert);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取最新的广告信息
/// </summary>
/// <returns></returns>
public AdvertmentModel GetAdvertment()
{
string strCommandText = "SELECT A_Id AS AId,A_Name AS AName,A_Url AS AUrl FROM a_info_table WHERE A_Status='N'";
strCommandText += " ORDER BY A_Id DESC";
strCommandText += " LIMIT 1";
AdvertmentModel objAdvert = new AdvertmentModel();
try
{
DataTable dt = MySQLHelper.GetDataTable(MySQLHelper.Conn, CommandType.Text, strCommandText, null);
if (dt.Rows.Count > 0)
{
objAdvert.Id = Int32.Parse(dt.Rows[0]["AId"].ToString());
objAdvert.Name = dt.Rows[0]["AName"].ToString();
objAdvert.Url = dt.Rows[0]["AUrl"].ToString();
}
return(objAdvert);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//Update
public bool UpdateAdvertment(AdvertmentModel item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
//to do
//UPDATE a_info_table SET A_Status="Y" WHERE A_Id=2;
string strCommandText = "UPDATE a_info_table SET";
strCommandText += " A_Name ='" + item.Name + "',";
strCommandText += " A_Url='" + item.Url + "'";
strCommandText += " WHERE A_Id=" + item.Id;
try
{
int iResult = MySQLHelper.ExecuteNonQuery(MySQLHelper.Conn, CommandType.Text, strCommandText, null);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}