/// <summary>
/// 得到一个对象实体
/// </summary>
public JiShi.Model.js_item GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" closed,createDate,curId,deliveryDate,gameId,gameItemId,gender,grade,gradeName,guild,iconPath,id,itemAmount,itemCode,itemDesc,itemName,itemType,power,price,publicityEndDate,returnDate,saveTime,sellerCasId,sellerGameId,sellerRole,serverId,shelfDate,shelfDays,status,unitPrice,temp1,temp2,temp3,temp4,temp5,temp6,temp7 ");
strSql.Append(" from js_item ");
strSql.Append(" where id='" + id + "' ");
JiShi.Model.js_item model = new JiShi.Model.js_item();
DataSet ds = DbHelperMySQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JiShi.Model.js_item DataRowToModel(DataRow row)
{
JiShi.Model.js_item model = new JiShi.Model.js_item();
if (row != null)
{
if (row["closed"] != null)
{
model.closed = row["closed"].ToString();
}
if (row["createDate"] != null)
{
model.createDate = row["createDate"].ToString();
}
if (row["curId"] != null)
{
model.curId = row["curId"].ToString();
}
if (row["deliveryDate"] != null)
{
model.deliveryDate = row["deliveryDate"].ToString();
}
if (row["gameId"] != null)
{
model.gameId = row["gameId"].ToString();
}
if (row["gameItemId"] != null)
{
model.gameItemId = row["gameItemId"].ToString();
}
if (row["gender"] != null)
{
model.gender = row["gender"].ToString();
}
if (row["grade"] != null)
{
model.grade = row["grade"].ToString();
}
if (row["gradeName"] != null)
{
model.gradeName = row["gradeName"].ToString();
}
if (row["guild"] != null)
{
model.guild = row["guild"].ToString();
}
if (row["iconPath"] != null)
{
model.iconPath = row["iconPath"].ToString();
}
if (row["id"] != null)
{
model.id = row["id"].ToString();
}
if (row["itemAmount"] != null)
{
model.itemAmount = row["itemAmount"].ToString();
}
if (row["itemCode"] != null)
{
model.itemCode = row["itemCode"].ToString();
}
if (row["itemDesc"] != null)
{
model.itemDesc = row["itemDesc"].ToString();
}
if (row["itemName"] != null)
{
model.itemName = row["itemName"].ToString();
}
if (row["itemType"] != null)
{
model.itemType = row["itemType"].ToString();
}
if (row["power"] != null)
{
model.power = row["power"].ToString();
}
if (row["price"] != null)
{
model.price = row["price"].ToString();
}
if (row["publicityEndDate"] != null)
{
model.publicityEndDate = row["publicityEndDate"].ToString();
}
if (row["returnDate"] != null)
{
model.returnDate = row["returnDate"].ToString();
}
if (row["saveTime"] != null)
{
model.saveTime = row["saveTime"].ToString();
}
if (row["sellerCasId"] != null)
{
model.sellerCasId = row["sellerCasId"].ToString();
}
if (row["sellerGameId"] != null)
{
model.sellerGameId = row["sellerGameId"].ToString();
}
if (row["sellerRole"] != null)
{
model.sellerRole = row["sellerRole"].ToString();
}
if (row["serverId"] != null)
{
model.serverId = row["serverId"].ToString();
}
if (row["shelfDate"] != null)
{
model.shelfDate = row["shelfDate"].ToString();
}
if (row["shelfDays"] != null)
{
model.shelfDays = row["shelfDays"].ToString();
}
if (row["status"] != null)
{
model.status = row["status"].ToString();
}
if (row["unitPrice"] != null)
{
model.unitPrice = row["unitPrice"].ToString();
}
//if(row["temp1"]!=null)
//{
// model.temp1=row["temp1"].ToString();
//}
//if(row["temp2"]!=null)
//{
// model.temp2=row["temp2"].ToString();
//}
//if(row["temp3"]!=null)
//{
// model.temp3=row["temp3"].ToString();
//}
//if(row["temp4"]!=null)
//{
// model.temp4=row["temp4"].ToString();
//}
//if(row["temp5"]!=null)
//{
// model.temp5=row["temp5"].ToString();
//}
//if(row["temp6"]!=null)
//{
// model.temp6=row["temp6"].ToString();
//}
//if(row["temp7"]!=null)
//{
// model.temp7=row["temp7"].ToString();
//}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JiShi.Model.js_item model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.closed != null)
{
strSql1.Append("closed,");
strSql2.Append("'" + model.closed + "',");
}
if (model.createDate != null)
{
strSql1.Append("createDate,");
strSql2.Append("'" + model.createDate + "',");
}
if (model.curId != null)
{
strSql1.Append("curId,");
strSql2.Append("'" + model.curId + "',");
}
if (model.deliveryDate != null)
{
strSql1.Append("deliveryDate,");
strSql2.Append("'" + model.deliveryDate + "',");
}
if (model.gameId != null)
{
strSql1.Append("gameId,");
strSql2.Append("'" + model.gameId + "',");
}
if (model.gameItemId != null)
{
strSql1.Append("gameItemId,");
strSql2.Append("'" + model.gameItemId + "',");
}
if (model.gender != null)
{
strSql1.Append("gender,");
strSql2.Append("'" + model.gender + "',");
}
if (model.grade != null)
{
strSql1.Append("grade,");
strSql2.Append("'" + model.grade + "',");
}
if (model.gradeName != null)
{
strSql1.Append("gradeName,");
strSql2.Append("'" + model.gradeName + "',");
}
if (model.guild != null)
{
strSql1.Append("guild,");
strSql2.Append("'" + model.guild + "',");
}
if (model.iconPath != null)
{
strSql1.Append("iconPath,");
strSql2.Append("'" + model.iconPath + "',");
}
if (model.id != null)
{
strSql1.Append("id,");
strSql2.Append("'" + model.id + "',");
}
if (model.itemAmount != null)
{
strSql1.Append("itemAmount,");
strSql2.Append("'" + model.itemAmount + "',");
}
if (model.itemCode != null)
{
strSql1.Append("itemCode,");
strSql2.Append("'" + model.itemCode + "',");
}
if (model.itemDesc != null)
{
strSql1.Append("itemDesc,");
strSql2.Append("'" + model.itemDesc + "',");
}
if (model.itemName != null)
{
strSql1.Append("itemName,");
strSql2.Append("'" + model.itemName + "',");
}
if (model.itemType != null)
{
strSql1.Append("itemType,");
strSql2.Append("'" + model.itemType + "',");
}
if (model.power != null)
{
strSql1.Append("power,");
strSql2.Append("'" + model.power + "',");
}
if (model.price != null)
{
strSql1.Append("price,");
strSql2.Append("'" + model.price + "',");
}
if (model.publicityEndDate != null)
{
strSql1.Append("publicityEndDate,");
strSql2.Append("'" + model.publicityEndDate + "',");
}
if (model.returnDate != null)
{
strSql1.Append("returnDate,");
strSql2.Append("'" + model.returnDate + "',");
}
if (model.saveTime != null)
{
strSql1.Append("saveTime,");
strSql2.Append("'" + model.saveTime + "',");
}
if (model.sellerCasId != null)
{
strSql1.Append("sellerCasId,");
strSql2.Append("'" + model.sellerCasId + "',");
}
if (model.sellerGameId != null)
{
strSql1.Append("sellerGameId,");
strSql2.Append("'" + model.sellerGameId + "',");
}
if (model.sellerRole != null)
{
strSql1.Append("sellerRole,");
strSql2.Append("'" + model.sellerRole + "',");
}
if (model.serverId != null)
{
strSql1.Append("serverId,");
strSql2.Append("'" + model.serverId + "',");
}
if (model.shelfDate != null)
{
strSql1.Append("shelfDate,");
strSql2.Append("'" + model.shelfDate + "',");
}
if (model.shelfDays != null)
{
strSql1.Append("shelfDays,");
strSql2.Append("'" + model.shelfDays + "',");
}
if (model.status != null)
{
strSql1.Append("status,");
strSql2.Append("'" + model.status + "',");
}
if (model.unitPrice != null)
{
strSql1.Append("unitPrice,");
strSql2.Append("'" + model.unitPrice + "',");
}
//if (model.temp1 != null)
//{
// strSql1.Append("temp1,");
// strSql2.Append("'"+model.temp1+"',");
//}
//if (model.temp2 != null)
//{
// strSql1.Append("temp2,");
// strSql2.Append("'"+model.temp2+"',");
//}
//if (model.temp3 != null)
//{
// strSql1.Append("temp3,");
// strSql2.Append("'"+model.temp3+"',");
//}
//if (model.temp4 != null)
//{
// strSql1.Append("temp4,");
// strSql2.Append("'"+model.temp4+"',");
//}
//if (model.temp5 != null)
//{
// strSql1.Append("temp5,");
// strSql2.Append("'"+model.temp5+"',");
//}
//if (model.temp6 != null)
//{
// strSql1.Append("temp6,");
// strSql2.Append("'"+model.temp6+"',");
//}
//if (model.temp7 != null)
//{
// strSql1.Append("temp7,");
// strSql2.Append("'"+model.temp7+"',");
//}
strSql.Append("insert into js_item(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JiShi.Model.js_item model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update js_item set ");
if (model.closed != null)
{
strSql.Append("closed='" + model.closed + "',");
}
else
{
strSql.Append("closed= null ,");
}
if (model.createDate != null)
{
strSql.Append("createDate='" + model.createDate + "',");
}
else
{
strSql.Append("createDate= null ,");
}
if (model.curId != null)
{
strSql.Append("curId='" + model.curId + "',");
}
else
{
strSql.Append("curId= null ,");
}
if (model.deliveryDate != null)
{
strSql.Append("deliveryDate='" + model.deliveryDate + "',");
}
else
{
strSql.Append("deliveryDate= null ,");
}
if (model.gameId != null)
{
strSql.Append("gameId='" + model.gameId + "',");
}
else
{
strSql.Append("gameId= null ,");
}
if (model.gameItemId != null)
{
strSql.Append("gameItemId='" + model.gameItemId + "',");
}
else
{
strSql.Append("gameItemId= null ,");
}
if (model.gender != null)
{
strSql.Append("gender='" + model.gender + "',");
}
else
{
strSql.Append("gender= null ,");
}
if (model.grade != null)
{
strSql.Append("grade='" + model.grade + "',");
}
else
{
strSql.Append("grade= null ,");
}
if (model.gradeName != null)
{
strSql.Append("gradeName='" + model.gradeName + "',");
}
else
{
strSql.Append("gradeName= null ,");
}
if (model.guild != null)
{
strSql.Append("guild='" + model.guild + "',");
}
else
{
strSql.Append("guild= null ,");
}
if (model.iconPath != null)
{
strSql.Append("iconPath='" + model.iconPath + "',");
}
else
{
strSql.Append("iconPath= null ,");
}
if (model.itemAmount != null)
{
strSql.Append("itemAmount='" + model.itemAmount + "',");
}
else
{
strSql.Append("itemAmount= null ,");
}
if (model.itemCode != null)
{
strSql.Append("itemCode='" + model.itemCode + "',");
}
else
{
strSql.Append("itemCode= null ,");
}
if (model.itemDesc != null)
{
strSql.Append("itemDesc='" + model.itemDesc + "',");
}
else
{
strSql.Append("itemDesc= null ,");
}
if (model.itemName != null)
{
strSql.Append("itemName='" + model.itemName + "',");
}
else
{
strSql.Append("itemName= null ,");
}
if (model.itemType != null)
{
strSql.Append("itemType='" + model.itemType + "',");
}
else
{
strSql.Append("itemType= null ,");
}
if (model.power != null)
{
strSql.Append("power='" + model.power + "',");
}
else
{
strSql.Append("power= null ,");
}
if (model.price != null)
{
strSql.Append("price='" + model.price + "',");
}
else
{
strSql.Append("price= null ,");
}
if (model.publicityEndDate != null)
{
strSql.Append("publicityEndDate='" + model.publicityEndDate + "',");
}
else
{
strSql.Append("publicityEndDate= null ,");
}
if (model.returnDate != null)
{
strSql.Append("returnDate='" + model.returnDate + "',");
}
else
{
strSql.Append("returnDate= null ,");
}
if (model.saveTime != null)
{
strSql.Append("saveTime='" + model.saveTime + "',");
}
else
{
strSql.Append("saveTime= null ,");
}
if (model.sellerCasId != null)
{
strSql.Append("sellerCasId='" + model.sellerCasId + "',");
}
else
{
strSql.Append("sellerCasId= null ,");
}
if (model.sellerGameId != null)
{
strSql.Append("sellerGameId='" + model.sellerGameId + "',");
}
else
{
strSql.Append("sellerGameId= null ,");
}
if (model.sellerRole != null)
{
strSql.Append("sellerRole='" + model.sellerRole + "',");
}
else
{
strSql.Append("sellerRole= null ,");
}
if (model.serverId != null)
{
strSql.Append("serverId='" + model.serverId + "',");
}
else
{
strSql.Append("serverId= null ,");
}
if (model.shelfDate != null)
{
strSql.Append("shelfDate='" + model.shelfDate + "',");
}
else
{
strSql.Append("shelfDate= null ,");
}
if (model.shelfDays != null)
{
strSql.Append("shelfDays='" + model.shelfDays + "',");
}
else
{
strSql.Append("shelfDays= null ,");
}
if (model.status != null)
{
strSql.Append("status='" + model.status + "',");
}
else
{
strSql.Append("status= null ,");
}
if (model.unitPrice != null)
{
strSql.Append("unitPrice='" + model.unitPrice + "',");
}
else
{
strSql.Append("unitPrice= null ,");
}
//if (model.temp1 != null)
//{
// strSql.Append("temp1='"+model.temp1+"',");
//}
//else
//{
// strSql.Append("temp1= null ,");
//}
//if (model.temp2 != null)
//{
// strSql.Append("temp2='"+model.temp2+"',");
//}
//else
//{
// strSql.Append("temp2= null ,");
//}
//if (model.temp3 != null)
//{
// strSql.Append("temp3='"+model.temp3+"',");
//}
//else
//{
// strSql.Append("temp3= null ,");
//}
//if (model.temp4 != null)
//{
// strSql.Append("temp4='"+model.temp4+"',");
//}
//else
//{
// strSql.Append("temp4= null ,");
//}
//if (model.temp5 != null)
//{
// strSql.Append("temp5='"+model.temp5+"',");
//}
//else
//{
// strSql.Append("temp5= null ,");
//}
//if (model.temp6 != null)
//{
// strSql.Append("temp6='"+model.temp6+"',");
//}
//else
//{
// strSql.Append("temp6= null ,");
//}
//if (model.temp7 != null)
//{
// strSql.Append("temp7='"+model.temp7+"',");
//}
//else
//{
// strSql.Append("temp7= null ,");
//}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where id='" + model.id + "' ");
int rowsAffected = DbHelperMySQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
