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