/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MultiColorPen.Model.base_msgtypeinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update base_msgtypeinfo set ");
strSql.Append("id=?id,");
strSql.Append("msgtypename=?msgtypename,");
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 msgtypecode=?msgtypecode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?msgtypename", 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("?msgtypecode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = model.id;
parameters[1].Value = model.msgtypename;
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.msgtypecode;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MultiColorPen.Model.base_msgtypeinfo DataRowToModel(DataRow row)
{
MultiColorPen.Model.base_msgtypeinfo model = new MultiColorPen.Model.base_msgtypeinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["msgtypecode"] != null)
{
model.msgtypecode = row["msgtypecode"].ToString();
}
if (row["msgtypename"] != null)
{
model.msgtypename = row["msgtypename"].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_msgtypeinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, msgtypecode, msgtypename, isenable, sort, remark, createtime, createman, updatetime, updateman ");
strSql.Append(" from base_msgtypeinfo ");
strSql.Append(" where id=" + id);
MultiColorPen.Model.base_msgtypeinfo model = new MultiColorPen.Model.base_msgtypeinfo();
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.msgtypecode = ds.Tables[0].Rows[0]["msgtypecode"].ToString();
model.msgtypename = ds.Tables[0].Rows[0]["msgtypename"].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_msgtypeinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into base_msgtypeinfo(");
strSql.Append("id,msgtypecode,msgtypename,isenable,sort,remark,createtime,createman,updatetime,updateman)");
strSql.Append(" values (");
strSql.Append("?id,?msgtypecode,?msgtypename,?isenable,?sort,?remark,?createtime,?createman,?updatetime,?updateman)");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11),
new MySqlParameter("?msgtypecode", MySqlDbType.VarChar, 10),
new MySqlParameter("?msgtypename", 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.msgtypecode;
parameters[2].Value = model.msgtypename;
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_msgtypeinfo GetModel(string msgtypecode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,msgtypecode,msgtypename,isenable,sort,remark,createtime,createman,updatetime,updateman from base_msgtypeinfo ");
strSql.Append(" where msgtypecode=?msgtypecode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?msgtypecode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = msgtypecode;
MultiColorPen.Model.base_msgtypeinfo model = new MultiColorPen.Model.base_msgtypeinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
