/// <summary>
/// 通过管理员ID，获取某个数据备份。
/// </summary>
/// <param name="userid">管理员ID</param>
/// <returns>数据备份对象。</returns>
public Model.DataCopy getCopyByUserId(string userid)
{
Model.DataCopy data = null;
string sqltext = "select * from datacopy where userid=@userid";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@userid", userid);
para.Add(sqlpara1);
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para);
while (sdr.Read())
{
data = new Model.DataCopy();
data.CopyId = sdr["copyId"].ToString();
data.DataName = sdr["dataName"].ToString();
data.CopyTime = DateTime.Parse(sdr["copyTime"].ToString());
data.CopyType = sdr["copyType"].ToString();
data.CopySize = int.Parse(sdr["copySize"].ToString());
data.SysUser = new DAL.SysUserDAO().getUserById(sdr["userId"].ToString());
data.CopyLocation = sdr["copyLocation"].ToString();
data.CopyState = sdr["copyState"].ToString();
}
sdr.Close();
DBTools.DBClose();
return(data);
}
/// <summary>
/// 增加一个数据备份。
/// </summary>
/// <param name="ccopy">数据备份对象</param>
/// <returns>通过布尔值判断操作是否成功。</returns>
public bool addCopy(Model.DataCopy ccopy)
{
string sqltext = "insert datacopy(copyId,dataName,copyTime,copyType,copySize,userId,copyLocation,copyState) values(@copyId,@dataName,@copyTime,@copyType,@copySize,@userId,@copyLocation,@copyState)";
List <SqlParameter> para = new List <SqlParameter>();
string maxid = DBTools.searchID("datacopy", "copyId");
int id = maxid != null?int.Parse(maxid) : 0;
SqlParameter sqlpara1 = new SqlParameter("@copyId", (id + 1).ToString());
SqlParameter sqlpara2 = new SqlParameter("@dataName", ccopy.DataName);
SqlParameter sqlpara3 = new SqlParameter("@copyTime", ccopy.CopyTime);
SqlParameter sqlpara4 = new SqlParameter("@copyType", ccopy.CopyType);
SqlParameter sqlpara5 = new SqlParameter("@copySize", ccopy.CopySize);
SqlParameter sqlpara6 = new SqlParameter("@userId", ccopy.SysUser.UserId);
SqlParameter sqlpara7 = new SqlParameter("@copyLocation", ccopy.CopyLocation);
SqlParameter sqlpara8 = new SqlParameter("@copyState", ccopy.CopyState);
para.Add(sqlpara1);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更改数据备份信息
/// </summary>
/// <param name="ccopy">数据备份对象</param>
/// <returns>通过布尔值判断操作是否成功。</returns>
public bool updateCopy(Model.DataCopy ccopy)
{
string sqltext = "update datacopy set dataName=@dataName,copyTime=@copyTime,copyType=@copyType,copySize=@copySize,userId=@userId,copyLocation=@copyLocation,copyState=@copyState where copyId=@copyId";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@copyId", ccopy.CopyId);
SqlParameter sqlpara2 = new SqlParameter("@dataName", ccopy.DataName);
SqlParameter sqlpara3 = new SqlParameter("@copyTime", ccopy.CopyTime);
SqlParameter sqlpara4 = new SqlParameter("@copyType", ccopy.CopyType);
SqlParameter sqlpara5 = new SqlParameter("@copySize", ccopy.CopySize);
SqlParameter sqlpara6 = new SqlParameter("@userId", ccopy.SysUser.UserId);
SqlParameter sqlpara7 = new SqlParameter("@copyLocation", ccopy.CopyLocation);
SqlParameter sqlpara8 = new SqlParameter("@copyState", ccopy.CopyState);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
para.Add(sqlpara1);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取所有的数据备份。
/// </summary>
public List <Model.DataCopy> getAllCopy()
{
List <Model.DataCopy> data = new List <Model.DataCopy>();
string sqltext = "select * from datacopy";
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ());
while (sdr.Read())
{
Model.DataCopy d = new Model.DataCopy();
d.CopyId = sdr["copyId"].ToString();
d.DataName = sdr["dataName"].ToString();
d.CopyTime = DateTime.Parse(sdr["copyTime"].ToString());
d.CopyType = sdr["copyType"].ToString();
d.CopySize = int.Parse(sdr["copySize"].ToString());
d.SysUser = new DAL.SysUserDAO().getUserById(sdr["userId"].ToString());
d.CopyLocation = sdr["copyLocation"].ToString();
d.CopyState = sdr["copyState"].ToString();
data.Add(d);
}
sdr.Close();
DBTools.DBClose();
return(data);
}
/// <summary>
/// 更新某个备份。
/// </summary>
/// <param name="ccopy">备份对象。</param>
public bool updateCopy(Model.DataCopy ccopy)
{
throw new System.NotImplementedException();
}
