/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JY.Model.MemberRank model)
{
int rowsAffected=0;
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.BigInt,8),
new SqlParameter("@MemberRankName", SqlDbType.NVarChar,50),
new SqlParameter("@Fid", SqlDbType.Int,4),
new SqlParameter("@Sort", SqlDbType.Int,4),
new SqlParameter("@Depth", SqlDbType.Int,4),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.ID;
parameters[1].Value = model.MemberRankName;
parameters[2].Value = model.Fid;
parameters[3].Value = model.Sort;
parameters[4].Value = model.Depth;
parameters[5].Value = model.Remark;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.IsDelete;
DbHelperSQL.RunProcedure("MemberRank_Update",parameters,out rowsAffected);
if (rowsAffected > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JY.Model.MemberRank GetModel(long ID)
{
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.BigInt)
};
parameters[0].Value = ID;
JY.Model.MemberRank model=new JY.Model.MemberRank();
DataSet ds= DbHelperSQL.RunProcedure("MemberRank_GetModel",parameters,"ds");
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"]!=null && ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["MemberRankName"]!=null && ds.Tables[0].Rows[0]["MemberRankName"].ToString()!="")
{
model.MemberRankName=ds.Tables[0].Rows[0]["MemberRankName"].ToString();
}
if(ds.Tables[0].Rows[0]["Fid"]!=null && ds.Tables[0].Rows[0]["Fid"].ToString()!="")
{
model.Fid=int.Parse(ds.Tables[0].Rows[0]["Fid"].ToString());
}
if(ds.Tables[0].Rows[0]["Sort"]!=null && ds.Tables[0].Rows[0]["Sort"].ToString()!="")
{
model.Sort=int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
}
if(ds.Tables[0].Rows[0]["Depth"]!=null && ds.Tables[0].Rows[0]["Depth"].ToString()!="")
{
model.Depth=int.Parse(ds.Tables[0].Rows[0]["Depth"].ToString());
}
if(ds.Tables[0].Rows[0]["Remark"]!=null && ds.Tables[0].Rows[0]["Remark"].ToString()!="")
{
model.Remark=ds.Tables[0].Rows[0]["Remark"].ToString();
}
if(ds.Tables[0].Rows[0]["CreateDate"]!=null && ds.Tables[0].Rows[0]["CreateDate"].ToString()!="")
{
model.CreateDate=DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if(ds.Tables[0].Rows[0]["IsDelete"]!=null && ds.Tables[0].Rows[0]["IsDelete"].ToString()!="")
{
if((ds.Tables[0].Rows[0]["IsDelete"].ToString()=="1")||(ds.Tables[0].Rows[0]["IsDelete"].ToString().ToLower()=="true"))
{
model.IsDelete=true;
}
else
{
model.IsDelete=false;
}
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(JY.Model.MemberRank model)
{
int rowsAffected;
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.BigInt,8),
new SqlParameter("@MemberRankName", SqlDbType.NVarChar,50),
new SqlParameter("@Fid", SqlDbType.Int,4),
new SqlParameter("@Sort", SqlDbType.Int,4),
new SqlParameter("@Depth", SqlDbType.Int,4),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.MemberRankName;
parameters[2].Value = model.Fid;
parameters[3].Value = model.Sort;
parameters[4].Value = model.Depth;
parameters[5].Value = model.Remark;
parameters[6].Value = model.CreateDate;
parameters[7].Value = model.IsDelete;
DbHelperSQL.RunProcedure("MemberRank_ADD",parameters,out rowsAffected);
return (long)parameters[0].Value;
}
