public int Update(Model.Relation M)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HY_DZ_K7_RELATION set ");
strSql.Append("cjointname=@cjointname,");
strSql.Append("clinkname=@clinkname,");
strSql.Append("cjointfield=@cjointfield,");
strSql.Append("clinkfield=@clinkfield ");
strSql.Append(" where autoid=@autoid ");
SqlParameter[] parameters =
{
new SqlParameter("@autoid", SqlDbType.Int),
new SqlParameter("@cjointname", SqlDbType.NVarChar, 30),
new SqlParameter("@clinkname", SqlDbType.NVarChar, 200),
new SqlParameter("@cjointfield", SqlDbType.NVarChar, 200),
new SqlParameter("@clinkfield", SqlDbType.NVarChar, 200)
};
parameters[0].Value = M.Autoid;
parameters[1].Value = M.Cjointname;
parameters[2].Value = M.Clinkname;
parameters[3].Value = M.Cjointfield;
parameters[4].Value = M.Clinkfield;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
public List <Model.Relation> GetModelList(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from HY_DZ_K7_RELATION ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(" where " + where);
}
List <Model.Relation> list = new List <Model.Relation>();
SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString());
while (sdr.Read())
{
Model.Relation model = new Model.Relation();
model.Cjointname = (string)sdr["cjointname"];
model.Clinkname = (string)sdr["clinkname"];
model.Cjointfield = (string)sdr["cjointfield"];
model.Clinkfield = (string)sdr["clinkfield"];
list.Add(model);
}
sdr.Close();
return(list);
}
/// <summary>
/// 获取一条实体对象
/// </summary>
public Model.Relation GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from HY_DZ_K7_RELATION ");
strSql.Append(" where autoid=@autoid");
SqlParameter[] parameters =
{
new SqlParameter("@autoid", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.Relation model = new Model.Relation();
SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
if (sdr.Read())
{
model.Cjointname = (string)sdr["cjointname"];
model.Clinkname = (string)sdr["clinkname"];
model.Cjointfield = (string)sdr["cjointfield"];
model.Clinkfield = (string)sdr["clinkfield"];
sdr.Close();
return(model);
}
else
{
sdr.Close();
return(null);
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Insert(Model.Relation M)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HY_DZ_K7_RELATION(");
strSql.Append("cjointname,clinkname,cjointfield,clinkfield)");
strSql.Append(" values (");
strSql.Append("@cjointname,@clinkname,@cjointfield,@clinkfield)");
SqlParameter[] parameters =
{
new SqlParameter("@cjointname", SqlDbType.NVarChar, 30),
new SqlParameter("@clinkname", SqlDbType.NVarChar, 200),
new SqlParameter("@cjointfield", SqlDbType.NVarChar, 200),
new SqlParameter("@clinkfield", SqlDbType.NVarChar, 200)
};
parameters[0].Value = M.Cjointname;
parameters[1].Value = M.Clinkname;
parameters[2].Value = M.Cjointfield;
parameters[3].Value = M.Clinkfield;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
