/// <summary> /// 增加一条数据 /// </summary> public int Add(Hch.iDisk.Model.ShareInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShareInfo("); strSql.Append("SSender,SReceive,SDate,SFileId)"); strSql.Append(" values ("); strSql.Append("@SSender,@SReceive,@SDate,@SFileId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SSender", SqlDbType.Int, 4), new SqlParameter("@SReceive", SqlDbType.Int, 4), new SqlParameter("@SDate", SqlDbType.DateTime), new SqlParameter("@SFileId", SqlDbType.Int, 4) }; parameters[0].Value = model.SSender; parameters[1].Value = model.SReceive; parameters[2].Value = model.SDate; parameters[3].Value = model.SFileId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hch.iDisk.Model.ShareInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ShareInfo set "); strSql.Append("SSender=@SSender,"); strSql.Append("SReceive=@SReceive,"); strSql.Append("SDate=@SDate,"); strSql.Append("SFileId=@SFileId"); strSql.Append(" where SId=@SId"); SqlParameter[] parameters = { new SqlParameter("@SSender", SqlDbType.Int, 4), new SqlParameter("@SReceive", SqlDbType.Int, 4), new SqlParameter("@SDate", SqlDbType.DateTime), new SqlParameter("@SFileId", SqlDbType.Int, 4), new SqlParameter("@SId", SqlDbType.Int, 4) }; parameters[0].Value = model.SSender; parameters[1].Value = model.SReceive; parameters[2].Value = model.SDate; parameters[3].Value = model.SFileId; parameters[4].Value = model.SId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hch.iDisk.Model.ShareInfo GetModel(int SId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SId,SSender,SReceive,SDate,SFileId from ShareInfo "); strSql.Append(" where SId=@SId"); SqlParameter[] parameters = { new SqlParameter("@SId", SqlDbType.Int, 4) }; parameters[0].Value = SId; Hch.iDisk.Model.ShareInfo model = new Hch.iDisk.Model.ShareInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SId"].ToString() != "") { model.SId = int.Parse(ds.Tables[0].Rows[0]["SId"].ToString()); } if (ds.Tables[0].Rows[0]["SSender"].ToString() != "") { model.SSender = int.Parse(ds.Tables[0].Rows[0]["SSender"].ToString()); } if (ds.Tables[0].Rows[0]["SReceive"].ToString() != "") { model.SReceive = int.Parse(ds.Tables[0].Rows[0]["SReceive"].ToString()); } if (ds.Tables[0].Rows[0]["SDate"].ToString() != "") { model.SDate = DateTime.Parse(ds.Tables[0].Rows[0]["SDate"].ToString()); } if (ds.Tables[0].Rows[0]["SFileId"].ToString() != "") { model.SFileId = int.Parse(ds.Tables[0].Rows[0]["SFileId"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Hch.iDisk.Model.ShareInfo GetModel(int SId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 SId,SSender,SReceive,SDate,SFileId from ShareInfo "); strSql.Append(" where SId=@SId"); SqlParameter[] parameters = { new SqlParameter("@SId", SqlDbType.Int,4) }; parameters[0].Value = SId; Hch.iDisk.Model.ShareInfo model=new Hch.iDisk.Model.ShareInfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["SId"].ToString()!="") { model.SId=int.Parse(ds.Tables[0].Rows[0]["SId"].ToString()); } if(ds.Tables[0].Rows[0]["SSender"].ToString()!="") { model.SSender=int.Parse(ds.Tables[0].Rows[0]["SSender"].ToString()); } if(ds.Tables[0].Rows[0]["SReceive"].ToString()!="") { model.SReceive=int.Parse(ds.Tables[0].Rows[0]["SReceive"].ToString()); } if(ds.Tables[0].Rows[0]["SDate"].ToString()!="") { model.SDate=DateTime.Parse(ds.Tables[0].Rows[0]["SDate"].ToString()); } if(ds.Tables[0].Rows[0]["SFileId"].ToString()!="") { model.SFileId=int.Parse(ds.Tables[0].Rows[0]["SFileId"].ToString()); } return model; } else { return null; } }