/// <summary>
/// 得到一个对象实体
/// </summary>
public CSLG.CTalk.Model.groupu GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,groupID,groupuserID,groupfriendID,groupName,groupImage,groupAnnouncement from groupu ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
CSLG.CTalk.Model.groupu model = new CSLG.CTalk.Model.groupu();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["groupID"] != null && ds.Tables[0].Rows[0]["groupID"].ToString() != "")
{
model.groupID = int.Parse(ds.Tables[0].Rows[0]["groupID"].ToString());
}
if (ds.Tables[0].Rows[0]["groupuserID"] != null && ds.Tables[0].Rows[0]["groupuserID"].ToString() != "")
{
model.groupuserID = int.Parse(ds.Tables[0].Rows[0]["groupuserID"].ToString());
}
if (ds.Tables[0].Rows[0]["groupfriendID"] != null && ds.Tables[0].Rows[0]["groupfriendID"].ToString() != "")
{
model.groupfriendID = int.Parse(ds.Tables[0].Rows[0]["groupfriendID"].ToString());
}
if (ds.Tables[0].Rows[0]["groupName"] != null && ds.Tables[0].Rows[0]["groupName"].ToString() != "")
{
model.groupName = ds.Tables[0].Rows[0]["groupName"].ToString();
}
if (ds.Tables[0].Rows[0]["groupImage"] != null && ds.Tables[0].Rows[0]["groupImage"].ToString() != "")
{
model.groupImage = int.Parse(ds.Tables[0].Rows[0]["groupImage"].ToString());
}
if (ds.Tables[0].Rows[0]["groupAnnouncement"] != null && ds.Tables[0].Rows[0]["groupAnnouncement"].ToString() != "")
{
model.groupAnnouncement = ds.Tables[0].Rows[0]["groupAnnouncement"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CSLG.CTalk.Model.groupu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update groupu set ");
strSql.Append("groupID=@groupID,");
strSql.Append("groupuserID=@groupuserID,");
strSql.Append("groupfriendID=@groupfriendID,");
strSql.Append("groupName=@groupName,");
strSql.Append("groupImage=@groupImage,");
strSql.Append("groupAnnouncement=@groupAnnouncement");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@groupID", SqlDbType.Int, 4),
new SqlParameter("@groupuserID", SqlDbType.Int, 4),
new SqlParameter("@groupfriendID", SqlDbType.Int, 4),
new SqlParameter("@groupName", SqlDbType.NVarChar, 50),
new SqlParameter("@groupImage", SqlDbType.Int, 4),
new SqlParameter("@groupAnnouncement", SqlDbType.Text),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.groupID;
parameters[1].Value = model.groupuserID;
parameters[2].Value = model.groupfriendID;
parameters[3].Value = model.groupName;
parameters[4].Value = model.groupImage;
parameters[5].Value = model.groupAnnouncement;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CSLG.CTalk.Model.groupu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into groupu(");
strSql.Append("groupID,groupuserID,groupfriendID,groupName,groupImage,groupAnnouncement)");
strSql.Append(" values (");
strSql.Append("@groupID,@groupuserID,@groupfriendID,@groupName,@groupImage,@groupAnnouncement)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@groupID", SqlDbType.Int, 4),
new SqlParameter("@groupuserID", SqlDbType.Int, 4),
new SqlParameter("@groupfriendID", SqlDbType.Int, 4),
new SqlParameter("@groupName", SqlDbType.NVarChar, 50),
new SqlParameter("@groupImage", SqlDbType.Int, 4),
new SqlParameter("@groupAnnouncement", SqlDbType.Text)
};
parameters[0].Value = model.groupID;
parameters[1].Value = model.groupuserID;
parameters[2].Value = model.groupfriendID;
parameters[3].Value = model.groupName;
parameters[4].Value = model.groupImage;
parameters[5].Value = model.groupAnnouncement;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
