//插入
public bool InsertSpecialtyInfo(SpecialtyInfoData data)
{
string sql = "insert into specialtyinfo(specialtyid,specialtymc) values('"
+ data.Specialtyid + "','" + data.Specialtymc + "')";
DataAccess da = new DataAccess();
return(da.ExecuteSQL(sql));
}
//修改
public bool UpdateSpecialty(SpecialtyInfoData data)
{
string sql = "update specialtyinfo set specialtyid='"
+ data.Specialtyid + "',Specialtymc='" + data.Specialtymc
+ "' where Specialtyid = '" + data.Specialtyid + "'";
DataAccess da = new DataAccess();
return(da.ExecuteSQL(sql));
}
//查询
public System.Data.DataSet GetSpecialtyInfo(SpecialtyInfoData data)
{
string sql = "select * from specialtyinfo where 1=1";
string s = "";
if (data.Specialtyid != "" && data.Specialtyid != null)
{
s += " and specialtyid ='" + data.Specialtyid + "'";
}
if (data.Specialtymc != "" && data.Specialtymc != null)
{
s += " and specialtymc='" + data.Specialtymc + "'";
}
sql += s;
DataAccess da = new DataAccess();
return(da.GetDataSet(sql, "specialtyinfo"));
}
