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