/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(abc.Model.Model.UploadFile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UploadFile set ");
strSql.Append("FileName=SQL2012FileName,");
strSql.Append("FileType=SQL2012FileType,");
strSql.Append("Hash=SQL2012Hash,");
strSql.Append("Ext=SQL2012Ext,");
strSql.Append("Size=SQL2012Size,");
strSql.Append("Enabled=SQL2012Enabled,");
strSql.Append("IsPublic=SQL2012IsPublic,");
strSql.Append("CanDownLoad=SQL2012CanDownLoad,");
strSql.Append("CreateTime=SQL2012CreateTime");
strSql.Append(" where FileId=SQL2012FileId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012FileName", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012FileType", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Hash", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Ext", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Size", SqlDbType.Int, 4),
new SqlParameter("SQL2012Enabled", SqlDbType.Int, 4),
new SqlParameter("SQL2012IsPublic", SqlDbType.Int, 4),
new SqlParameter("SQL2012CanDownLoad", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime),
new SqlParameter("SQL2012FileId", SqlDbType.Int, 4)
};
parameters[0].Value = model.FileName;
parameters[1].Value = model.FileType;
parameters[2].Value = model.Hash;
parameters[3].Value = model.Ext;
parameters[4].Value = model.Size;
parameters[5].Value = model.Enabled;
parameters[6].Value = model.IsPublic;
parameters[7].Value = model.CanDownLoad;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.FileId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.UploadFile DataRowToModel(DataRow row)
{
abc.Model.Model.UploadFile model = new abc.Model.Model.UploadFile();
if (row != null)
{
if (row["FileId"] != null && row["FileId"].ToString() != "")
{
model.FileId = int.Parse(row["FileId"].ToString());
}
if (row["FileName"] != null)
{
model.FileName = row["FileName"].ToString();
}
if (row["FileType"] != null)
{
model.FileType = row["FileType"].ToString();
}
if (row["Hash"] != null)
{
model.Hash = row["Hash"].ToString();
}
if (row["Ext"] != null)
{
model.Ext = row["Ext"].ToString();
}
if (row["Size"] != null && row["Size"].ToString() != "")
{
model.Size = int.Parse(row["Size"].ToString());
}
if (row["Enabled"] != null && row["Enabled"].ToString() != "")
{
model.Enabled = int.Parse(row["Enabled"].ToString());
}
if (row["IsPublic"] != null && row["IsPublic"].ToString() != "")
{
model.IsPublic = int.Parse(row["IsPublic"].ToString());
}
if (row["CanDownLoad"] != null && row["CanDownLoad"].ToString() != "")
{
model.CanDownLoad = int.Parse(row["CanDownLoad"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(abc.Model.Model.UploadFile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UploadFile(");
strSql.Append("FileName,FileType,Hash,Ext,Size,Enabled,IsPublic,CanDownLoad,CreateTime)");
strSql.Append(" values (");
strSql.Append("SQL2012FileName,SQL2012FileType,SQL2012Hash,SQL2012Ext,SQL2012Size,SQL2012Enabled,SQL2012IsPublic,SQL2012CanDownLoad,SQL2012CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012FileName", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012FileType", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Hash", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Ext", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Size", SqlDbType.Int, 4),
new SqlParameter("SQL2012Enabled", SqlDbType.Int, 4),
new SqlParameter("SQL2012IsPublic", SqlDbType.Int, 4),
new SqlParameter("SQL2012CanDownLoad", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.FileName;
parameters[1].Value = model.FileType;
parameters[2].Value = model.Hash;
parameters[3].Value = model.Ext;
parameters[4].Value = model.Size;
parameters[5].Value = model.Enabled;
parameters[6].Value = model.IsPublic;
parameters[7].Value = model.CanDownLoad;
parameters[8].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.UploadFile GetModel(int FileId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FileId,FileName,FileType,Hash,Ext,Size,Enabled,IsPublic,CanDownLoad,CreateTime from UploadFile ");
strSql.Append(" where FileId=SQL2012FileId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012FileId", SqlDbType.Int, 4)
};
parameters[0].Value = FileId;
abc.Model.Model.UploadFile model = new abc.Model.Model.UploadFile();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
