/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.BST.staff_data model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update staff_data set ");
strSql.Append("name=@name,");
strSql.Append("info=@info,");
strSql.Append("image=@image,");
strSql.Append("authority=@authority,");
strSql.Append("date_begin=@date_begin,");
strSql.Append("date_end=@date_end,");
strSql.Append("data_keepon1=@data_keepon1,");
strSql.Append("data_keepon2=@data_keepon2,");
strSql.Append("data_keepon3=@data_keepon3,");
strSql.Append("data_keepon4=@data_keepon4,");
strSql.Append("data_keepon5=@data_keepon5");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 45),
new MySqlParameter("@info", MySqlDbType.VarBinary),
new MySqlParameter("@image", MySqlDbType.MediumBlob),
new MySqlParameter("@authority", MySqlDbType.VarChar, 1),
new MySqlParameter("@date_begin", MySqlDbType.VarChar, 45),
new MySqlParameter("@date_end", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon1", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon2", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon3", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon4", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon5", MySqlDbType.VarChar, 45),
new MySqlParameter("@id", MySqlDbType.VarChar, 60)
};
parameters[0].Value = model.name;
parameters[1].Value = model.info;
parameters[2].Value = model.image;
parameters[3].Value = model.authority;
parameters[4].Value = model.date_begin;
parameters[5].Value = model.date_end;
parameters[6].Value = model.data_keepon1;
parameters[7].Value = model.data_keepon2;
parameters[8].Value = model.data_keepon3;
parameters[9].Value = model.data_keepon4;
parameters[10].Value = model.data_keepon5;
parameters[11].Value = model.id;
int rows = DbHelperMySQLP.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.BST.staff_data DataRowToModel(DataRow row)
{
Maticsoft.Model.BST.staff_data model = new Maticsoft.Model.BST.staff_data();
if (row != null)
{
if (row["id"] != null)
{
model.id = row["id"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["info"] != null && row["info"].ToString() != "")
{
model.info = (byte[])row["info"];
}
//model.image=row["image"].ToString();
if (row["authority"] != null)
{
model.authority = row["authority"].ToString();
}
if (row["date_begin"] != null)
{
model.date_begin = row["date_begin"].ToString();
}
if (row["date_end"] != null)
{
model.date_end = row["date_end"].ToString();
}
if (row["data_keepon1"] != null)
{
model.data_keepon1 = row["data_keepon1"].ToString();
}
if (row["data_keepon2"] != null)
{
model.data_keepon2 = row["data_keepon2"].ToString();
}
if (row["data_keepon3"] != null)
{
model.data_keepon3 = row["data_keepon3"].ToString();
}
if (row["data_keepon4"] != null)
{
model.data_keepon4 = row["data_keepon4"].ToString();
}
if (row["data_keepon5"] != null)
{
model.data_keepon5 = row["data_keepon5"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.BST.staff_data model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into staff_data(");
strSql.Append("id,name,info,image,authority,date_begin,date_end,data_keepon1,data_keepon2,data_keepon3,data_keepon4,data_keepon5)");
strSql.Append(" values (");
strSql.Append("@id,@name,@info,@image,@authority,@date_begin,@date_end,@data_keepon1,@data_keepon2,@data_keepon3,@data_keepon4,@data_keepon5)");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.VarChar, 60),
new MySqlParameter("@name", MySqlDbType.VarChar, 45),
new MySqlParameter("@info", MySqlDbType.VarBinary),
new MySqlParameter("@image", MySqlDbType.MediumBlob),
new MySqlParameter("@authority", MySqlDbType.VarChar, 1),
new MySqlParameter("@date_begin", MySqlDbType.VarChar, 45),
new MySqlParameter("@date_end", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon1", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon2", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon3", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon4", MySqlDbType.VarChar, 45),
new MySqlParameter("@data_keepon5", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.id;
parameters[1].Value = model.name;
parameters[2].Value = model.info;
parameters[3].Value = model.image;
parameters[4].Value = model.authority;
parameters[5].Value = model.date_begin;
parameters[6].Value = model.date_end;
parameters[7].Value = model.data_keepon1;
parameters[8].Value = model.data_keepon2;
parameters[9].Value = model.data_keepon3;
parameters[10].Value = model.data_keepon4;
parameters[11].Value = model.data_keepon5;
int rows = DbHelperMySQLP.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.BST.staff_data GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,name,info,image,authority,date_begin,date_end,data_keepon1,data_keepon2,data_keepon3,data_keepon4,data_keepon5 from staff_data ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.VarChar, 60)
};
parameters[0].Value = id;
Maticsoft.Model.BST.staff_data model = new Maticsoft.Model.BST.staff_data();
DataSet ds = DbHelperMySQLP.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
