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