/// <summary>
/// 修改信息
/// </summary>
/// <param name="phoneInfo"></param>
/// <returns></returns>
public int AddUpdatePhoneInfo(Sjqd_PhoneInfo phoneInfo)
{
var param = new MySqlParameter[9]
{
new MySqlParameter("?pixel", phoneInfo.pixel),
new MySqlParameter("?resolution", phoneInfo.resolution),
new MySqlParameter("?price", phoneInfo.price),
new MySqlParameter("?frequency", phoneInfo.frequency),
new MySqlParameter("?Alias", phoneInfo.Alias),
new MySqlParameter("?ID", phoneInfo.ID),
new MySqlParameter("?name", phoneInfo.name),
new MySqlParameter("?userCount", phoneInfo.userCount),
new MySqlParameter("?userPercent", phoneInfo.userPercent)
};
//update Cfg_PhoneInfo
// set pixel=?pixel ,resolution=?resolution,PRICE=?price,FREQUENCY=?frequency,
// Alias=?Alias
// where ID=?ID;
string sql = @"
insert into Sjqd_PhoneInfo
values(?name,?userCount,?userPercent,?pixel,?resolution,?price,?frequency,?Alias)";
return(SqlHelper.ExecuteNonQuery(statdbConn, CommandType.Text, sql));
}
/// <summary>
/// 获取手机信息
/// </summary>
/// <param name="pixel"></param>
/// <param name="resolution"></param>
/// <param name="price"></param>
/// <param name="frequency"></param>
/// <param name="alias"></param>
/// <returns></returns>
public List <Sjqd_PhoneInfo> GetSjqd_PhoneInfoList(string name, string pixel, string resolution, string frequency,
string alias)
{
var param = new MySqlParameter[5]
{
new MySqlParameter("?pixel", "%" + pixel + "%"),
new MySqlParameter("?resolution", "%" + resolution + "%"),
new MySqlParameter("?FREQUENCY", "%" + frequency + "%"),
new MySqlParameter("?Alias", "%" + alias + "%"),
new MySqlParameter("?name", "%" + name + "%")
};
string sql =
string.Format(@"select ID, name, userCount, userPercent, pixel, resolution, PRICE, FREQUENCY, Alias
from Cfg_PhoneInfo
where 1=1 {0} {1} {2} {3} {4}",
string.IsNullOrEmpty(pixel) ? "" : (" and pixel like ?pixel"),
string.IsNullOrEmpty(resolution) ? "" : (" and resolution like ?resolution"),
string.IsNullOrEmpty(frequency) ? "" : (" and FREQUENCY like ?FREQUENCY"),
string.IsNullOrEmpty(alias) ? "" : (" and Alias like ?Alias"),
string.IsNullOrEmpty(name) ? "" : (" and name like ?name"));
List <Sjqd_PhoneInfo> list = new List <Sjqd_PhoneInfo>();
using (MySqlCommand cmd = new MySqlCommand(sql, new MySqlConnection(statdbConn)))
{
cmd.Connection.Open();
cmd.CommandTimeout = 180;
using (IDataReader read = cmd.ExecuteReader())
{
while (read.Read())
{
Sjqd_PhoneInfo phone = new Sjqd_PhoneInfo();
object obj = read["ID"];
if (obj != null && obj != DBNull.Value)
{
phone.ID = Convert.ToInt32(obj);
}
obj = read["name"];
if (obj != null && obj != DBNull.Value)
{
phone.name = obj.ToString();
}
obj = read["userCount"];
if (obj != null && obj != DBNull.Value)
{
phone.userCount = Convert.ToInt32(obj);
}
obj = read["userPercent"];
if (obj != null && obj != DBNull.Value)
{
phone.userPercent = Convert.ToDecimal(obj);
}
obj = read["pixel"];
if (obj != null && obj != DBNull.Value)
{
phone.pixel = obj.ToString();
}
obj = read["resolution"];
if (obj != null && obj != DBNull.Value)
{
phone.resolution = obj.ToString();
}
obj = read["PRICE"];
if (obj != null && obj != DBNull.Value)
{
phone.price = Convert.ToInt32(obj);
}
obj = read["FREQUENCY"];
if (obj != null && obj != DBNull.Value)
{
phone.frequency = obj.ToString();
}
obj = read["Alias"];
if (obj != null && obj != DBNull.Value)
{
phone.Alias = obj.ToString();
}
list.Add(phone);
}
}
}
return(list);
}
