/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Photos DataRowToModel(DataRow row)
{
Model.Photos model = new Model.Photos();
if (row != null)
{
if (row["PhotoId"] != null && row["PhotoId"].ToString() != "")
{
model.PhotoId = int.Parse(row["PhotoId"].ToString());
}
if (row["AlbumId"] != null && row["AlbumId"].ToString() != "")
{
model.AlbumId = int.Parse(row["AlbumId"].ToString());
}
if (row["PhotoName"] != null)
{
model.PhotoName = row["PhotoName"].ToString();
}
if (row["PhotoPath"] != null)
{
model.PhotoPath = row["PhotoPath"].ToString();
}
if (row["PhotoDesc"] != null)
{
model.PhotoDesc = row["PhotoDesc"].ToString();
}
if (row["AddUser"] != null)
{
model.AddUser = row["AddUser"].ToString();
}
if (row["AddTime"] != null && row["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(row["AddTime"].ToString());
}
if (row["IsAlbumFace"] != null && row["IsAlbumFace"].ToString() != "")
{
if ((row["IsAlbumFace"].ToString() == "1") || (row["IsAlbumFace"].ToString().ToLower() == "true"))
{
model.IsAlbumFace = true;
}
else
{
model.IsAlbumFace = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Photos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Photos set ");
strSql.Append("AlbumId=@AlbumId,");
strSql.Append("PhotoName=@PhotoName,");
strSql.Append("PhotoPath=@PhotoPath,");
strSql.Append("PhotoDesc=@PhotoDesc,");
strSql.Append("AddUser=@AddUser,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("IsAlbumFace=@IsAlbumFace");
strSql.Append(" where PhotoId=@PhotoId");
SqlParameter[] parameters =
{
new SqlParameter("@AlbumId", SqlDbType.Int, 4),
new SqlParameter("@PhotoName", SqlDbType.NVarChar, 50),
new SqlParameter("@PhotoPath", SqlDbType.NVarChar, 100),
new SqlParameter("@PhotoDesc", SqlDbType.Text),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsAlbumFace", SqlDbType.Bit, 1),
new SqlParameter("@PhotoId", SqlDbType.Int, 4)
};
parameters[0].Value = model.AlbumId;
parameters[1].Value = model.PhotoName;
parameters[2].Value = model.PhotoPath;
parameters[3].Value = model.PhotoDesc;
parameters[4].Value = model.AddUser;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.IsAlbumFace;
parameters[7].Value = model.PhotoId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(Model.Photos model)
{
int rowsAffected;
IDataParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 8),
new SqlParameter("@DevId", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@FileName", SqlDbType.VarChar, 100)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.DevId;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.FileName;
DbHelperSQL.RunProcedure("T_Photos_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Photos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Photos(");
strSql.Append("AlbumId,PhotoName,PhotoPath,PhotoDesc,AddUser,AddTime,IsAlbumFace)");
strSql.Append(" values (");
strSql.Append("@AlbumId,@PhotoName,@PhotoPath,@PhotoDesc,@AddUser,@AddTime,@IsAlbumFace)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AlbumId", SqlDbType.Int, 4),
new SqlParameter("@PhotoName", SqlDbType.NVarChar, 50),
new SqlParameter("@PhotoPath", SqlDbType.NVarChar, 100),
new SqlParameter("@PhotoDesc", SqlDbType.Text),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@IsAlbumFace", SqlDbType.Bit, 1)
};
parameters[0].Value = model.AlbumId;
parameters[1].Value = model.PhotoName;
parameters[2].Value = model.PhotoPath;
parameters[3].Value = model.PhotoDesc;
parameters[4].Value = model.AddUser;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.IsAlbumFace;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public Model.Photos DataRowToModel(DataRow row)
{
Model.Photos model = new Model.Photos();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.ID = int.Parse(row["Id"].ToString());
}
if (row["DevId"] != null && row["DevId"].ToString() != "")
{
model.DevId = int.Parse(row["DevId"].ToString());
}
if (row["DnsAddr"] != null && row["DnsAddr"].ToString() != "")
{
model.AddTime = DateTime.Parse(row["DnsAddr"].ToString());
}
if (row["UserName"] != null && row["UserName"].ToString() != "")
{
model.FileName = row["UserName"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Photos GetModel(int PhotoId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PhotoId,AlbumId,PhotoName,PhotoPath,PhotoDesc,AddUser,AddTime,IsAlbumFace from Photos ");
strSql.Append(" where PhotoId=@PhotoId");
SqlParameter[] parameters =
{
new SqlParameter("@PhotoId", SqlDbType.Int, 4)
};
parameters[0].Value = PhotoId;
Model.Photos model = new Model.Photos();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Photos model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Photos model)
{
return(dal.Add(model));
}
