/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.base_carbrandinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update base_carbrandinfo set ");
strSql.Append("id=?id,");
strSql.Append("brandname=?brandname,");
strSql.Append("isenable=?isenable,");
strSql.Append("sort=?sort,");
strSql.Append("remark=?remark,");
strSql.Append("createtime=?createtime,");
strSql.Append("createman=?createman,");
strSql.Append("updatetime=?updatetime,");
strSql.Append("updateman=?updateman");
strSql.Append(" where brandcode=?brandcode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?brandname", MySqlDbType.VarChar, 30),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?sort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36),
new MySqlParameter("?brandcode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = model.id;
parameters[1].Value = model.brandname;
parameters[2].Value = model.isenable;
parameters[3].Value = model.sort;
parameters[4].Value = model.remark;
parameters[5].Value = model.createtime;
parameters[6].Value = model.createman;
parameters[7].Value = model.updatetime;
parameters[8].Value = model.updateman;
parameters[9].Value = model.brandcode;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_carbrandinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.base_carbrandinfo model = new MultiColorPen.Model.base_carbrandinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["brandcode"] != null)
{
model.brandcode = row["brandcode"].ToString();
}
if (row["brandname"] != null)
{
model.brandname = row["brandname"].ToString();
}
if (row["isenable"] != null && row["isenable"].ToString() != "")
{
model.isenable = int.Parse(row["isenable"].ToString());
}
if (row["sort"] != null && row["sort"].ToString() != "")
{
model.sort = int.Parse(row["sort"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["createman"] != null)
{
model.createman = row["createman"].ToString();
}
if (row["updatetime"] != null && row["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(row["updatetime"].ToString());
}
if (row["updateman"] != null)
{
model.updateman = row["updateman"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_carbrandinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, brandcode, brandname, isenable, sort, remark, createtime, createman, updatetime, updateman ");
strSql.Append(" from base_carbrandinfo ");
strSql.Append(" where id=" + id);
MultiColorPen.Model.base_carbrandinfo model = new MultiColorPen.Model.base_carbrandinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.brandcode = ds.Tables[0].Rows[0]["brandcode"].ToString();
model.brandname = ds.Tables[0].Rows[0]["brandname"].ToString();
if (ds.Tables[0].Rows[0]["isenable"].ToString() != "")
{
model.isenable = int.Parse(ds.Tables[0].Rows[0]["isenable"].ToString());
}
if (ds.Tables[0].Rows[0]["sort"].ToString() != "")
{
model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(ds.Tables[0].Rows[0]["createtime"].ToString());
}
model.createman = ds.Tables[0].Rows[0]["createman"].ToString();
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(ds.Tables[0].Rows[0]["updatetime"].ToString());
}
model.updateman = ds.Tables[0].Rows[0]["updateman"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MultiColorPen.Model.base_carbrandinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into base_carbrandinfo(");
strSql.Append("id,brandcode,brandname,isenable,sort,remark,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?brandcode,?brandname,?isenable,?sort,?remark,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?brandcode", MySqlDbType.VarChar, 10),
new MySqlParameter("?brandname", MySqlDbType.VarChar, 30),
new MySqlParameter("?isenable", MySqlDbType.Int32, 11),
new MySqlParameter("?sort", MySqlDbType.Int32, 11),
new MySqlParameter("?remark", MySqlDbType.VarChar, 200),
new MySqlParameter("?createtime", MySqlDbType.DateTime),
new MySqlParameter("?createman", MySqlDbType.VarChar, 36),
new MySqlParameter("?updatetime", MySqlDbType.DateTime),
new MySqlParameter("?updateman", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.id;
parameters[1].Value = model.brandcode;
parameters[2].Value = model.brandname;
parameters[3].Value = model.isenable;
parameters[4].Value = model.sort;
parameters[5].Value = model.remark;
parameters[6].Value = model.createtime;
parameters[7].Value = model.createman;
parameters[8].Value = model.updatetime;
parameters[9].Value = model.updateman;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_carbrandinfo GetModel(string brandcode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,brandcode,brandname,isenable,sort,remark,createtime,createman,updatetime,updateman from base_carbrandinfo ");
strSql.Append(" where brandcode=?brandcode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?brandcode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = brandcode;
MultiColorPen.Model.base_carbrandinfo model = new MultiColorPen.Model.base_carbrandinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
