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