/// <summary>
/// 得到一个对象实体
/// </summary>
public t_unit_goods_list GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,unit_id,goods_id,goods_name_new,number,guid,random_num,ping_string,MD5_1,MD5_2,MD5_3,MD5_4,MD5_5,goods_number,isSell,sell_time,isSend,express_fee,status_code,create_time,update_time from t_unit_goods_list ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
t_unit_goods_list model = new t_unit_goods_list();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(t_unit_goods_list model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(t_unit_goods_list model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(t_unit_goods_list model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_unit_goods_list(");
strSql.Append("unit_id,goods_id,goods_name_new,number,guid,random_num,ping_string,MD5_1,MD5_2,MD5_3,MD5_4,MD5_5,goods_number,isSell,sell_time,isSend,express_fee,status_code,create_time,update_time)");
strSql.Append(" values (");
strSql.Append("@unit_id,@goods_id,@goods_name_new,@number,@guid,@random_num,@ping_string,@MD5_1,@MD5_2,@MD5_3,@MD5_4,@MD5_5,@goods_number,@isSell,@sell_time,@isSend,@express_fee,@status_code,@create_time,@update_time)");
MySqlParameter[] parameters =
{
new MySqlParameter("@unit_id", MySqlDbType.Int32, 11),
new MySqlParameter("@goods_id", MySqlDbType.Int32, 11),
new MySqlParameter("@goods_name_new", MySqlDbType.VarChar, 255),
new MySqlParameter("@number", MySqlDbType.VarChar, 255),
new MySqlParameter("@guid", MySqlDbType.VarChar, 255),
new MySqlParameter("@random_num", MySqlDbType.Int32, 11),
new MySqlParameter("@ping_string", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_1", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_2", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_3", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_4", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_5", MySqlDbType.VarChar, 255),
new MySqlParameter("@goods_number", MySqlDbType.VarChar, 255),
new MySqlParameter("@isSell", MySqlDbType.Int32, 11),
new MySqlParameter("@sell_time", MySqlDbType.DateTime),
new MySqlParameter("@isSend", MySqlDbType.Int32, 11),
new MySqlParameter("@express_fee", MySqlDbType.Decimal, 10),
new MySqlParameter("@status_code", MySqlDbType.Int32, 11),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@update_time", MySqlDbType.DateTime)
};
parameters[0].Value = model.unit_id;
parameters[1].Value = model.goods_id;
parameters[2].Value = model.goods_name_new;
parameters[3].Value = model.number;
parameters[4].Value = model.guid;
parameters[5].Value = model.random_num;
parameters[6].Value = model.ping_string;
parameters[7].Value = model.MD5_1;
parameters[8].Value = model.MD5_2;
parameters[9].Value = model.MD5_3;
parameters[10].Value = model.MD5_4;
parameters[11].Value = model.MD5_5;
parameters[12].Value = model.goods_number;
parameters[13].Value = model.isSell;
parameters[14].Value = model.sell_time;
parameters[15].Value = model.isSend;
parameters[16].Value = model.express_fee;
parameters[17].Value = model.status_code;
parameters[18].Value = model.create_time;
parameters[19].Value = model.update_time;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public t_unit_goods_list DataRowToModel(DataRow row)
{
t_unit_goods_list model = new t_unit_goods_list();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["unit_id"] != null && row["unit_id"].ToString() != "")
{
model.unit_id = int.Parse(row["unit_id"].ToString());
}
if (row["goods_id"] != null && row["goods_id"].ToString() != "")
{
model.goods_id = int.Parse(row["goods_id"].ToString());
}
if (row["goods_name_new"] != null)
{
model.goods_name_new = row["goods_name_new"].ToString();
}
if (row["number"] != null)
{
model.number = row["number"].ToString();
}
if (row["guid"] != null)
{
model.guid = row["guid"].ToString();
}
if (row["random_num"] != null && row["random_num"].ToString() != "")
{
model.random_num = int.Parse(row["random_num"].ToString());
}
if (row["ping_string"] != null)
{
model.ping_string = row["ping_string"].ToString();
}
if (row["MD5_1"] != null)
{
model.MD5_1 = row["MD5_1"].ToString();
}
if (row["MD5_2"] != null)
{
model.MD5_2 = row["MD5_2"].ToString();
}
if (row["MD5_3"] != null)
{
model.MD5_3 = row["MD5_3"].ToString();
}
if (row["MD5_4"] != null)
{
model.MD5_4 = row["MD5_4"].ToString();
}
if (row["MD5_5"] != null)
{
model.MD5_5 = row["MD5_5"].ToString();
}
if (row["goods_number"] != null)
{
model.goods_number = row["goods_number"].ToString();
}
if (row["isSell"] != null && row["isSell"].ToString() != "")
{
model.isSell = int.Parse(row["isSell"].ToString());
}
if (row["sell_time"] != null && row["sell_time"].ToString() != "")
{
model.sell_time = DateTime.Parse(row["sell_time"].ToString());
}
if (row["isSend"] != null && row["isSend"].ToString() != "")
{
model.isSend = int.Parse(row["isSend"].ToString());
}
if (row["express_fee"] != null && row["express_fee"].ToString() != "")
{
model.express_fee = decimal.Parse(row["express_fee"].ToString());
}
if (row["status_code"] != null && row["status_code"].ToString() != "")
{
model.status_code = int.Parse(row["status_code"].ToString());
}
if (row["create_time"] != null && row["create_time"].ToString() != "")
{
model.create_time = DateTime.Parse(row["create_time"].ToString());
}
if (row["update_time"] != null && row["update_time"].ToString() != "")
{
model.update_time = DateTime.Parse(row["update_time"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(t_unit_goods_list model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_unit_goods_list set ");
strSql.Append("unit_id=@unit_id,");
strSql.Append("goods_id=@goods_id,");
strSql.Append("goods_name_new=@goods_name_new,");
strSql.Append("number=@number,");
strSql.Append("guid=@guid,");
strSql.Append("random_num=@random_num,");
strSql.Append("ping_string=@ping_string,");
strSql.Append("MD5_1=@MD5_1,");
strSql.Append("MD5_2=@MD5_2,");
strSql.Append("MD5_3=@MD5_3,");
strSql.Append("MD5_4=@MD5_4,");
strSql.Append("MD5_5=@MD5_5,");
strSql.Append("goods_number=@goods_number,");
strSql.Append("isSell=@isSell,");
strSql.Append("sell_time=@sell_time,");
strSql.Append("isSend=@isSend,");
strSql.Append("express_fee=@express_fee,");
strSql.Append("status_code=@status_code,");
strSql.Append("create_time=@create_time,");
strSql.Append("update_time=@update_time");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@unit_id", MySqlDbType.Int32, 11),
new MySqlParameter("@goods_id", MySqlDbType.Int32, 11),
new MySqlParameter("@goods_name_new", MySqlDbType.VarChar, 255),
new MySqlParameter("@number", MySqlDbType.VarChar, 255),
new MySqlParameter("@guid", MySqlDbType.VarChar, 255),
new MySqlParameter("@random_num", MySqlDbType.Int32, 11),
new MySqlParameter("@ping_string", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_1", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_2", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_3", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_4", MySqlDbType.VarChar, 255),
new MySqlParameter("@MD5_5", MySqlDbType.VarChar, 255),
new MySqlParameter("@goods_number", MySqlDbType.VarChar, 255),
new MySqlParameter("@isSell", MySqlDbType.Int32, 11),
new MySqlParameter("@sell_time", MySqlDbType.DateTime),
new MySqlParameter("@isSend", MySqlDbType.Int32, 11),
new MySqlParameter("@express_fee", MySqlDbType.Decimal, 10),
new MySqlParameter("@status_code", MySqlDbType.Int32, 11),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@update_time", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.unit_id;
parameters[1].Value = model.goods_id;
parameters[2].Value = model.goods_name_new;
parameters[3].Value = model.number;
parameters[4].Value = model.guid;
parameters[5].Value = model.random_num;
parameters[6].Value = model.ping_string;
parameters[7].Value = model.MD5_1;
parameters[8].Value = model.MD5_2;
parameters[9].Value = model.MD5_3;
parameters[10].Value = model.MD5_4;
parameters[11].Value = model.MD5_5;
parameters[12].Value = model.goods_number;
parameters[13].Value = model.isSell;
parameters[14].Value = model.sell_time;
parameters[15].Value = model.isSend;
parameters[16].Value = model.express_fee;
parameters[17].Value = model.status_code;
parameters[18].Value = model.create_time;
parameters[19].Value = model.update_time;
parameters[20].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}