/// <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; }