/// <summary> /// 新增一个Flash文件对象 /// </summary> /// <param name="swfFile">Flash对象</param> /// <returns>受影响行数</returns> public static int AddSwfFile(SwfFile swfFile) { string sql = "INSERT INTO swfFiles(fName,fDesc,fPath) values(@fName,@fDesc,@fPath)"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@fName",swfFile.FName), new SqlParameter("@fDesc",swfFile.FDesc), new SqlParameter("@fPath",swfFile.FPath) }; return DBHelper.GetScalar(sql,par); }
private static SwfFile GetSwfFileByDataRow(DataRow row) { SwfFile swf = new SwfFile(); swf.FID = Convert.ToInt32(row["fID"].ToString()); swf.FName = (string)row["fName"].ToString(); swf.FDesc = (string)row["fDesc"].ToString(); swf.FPath = (string)row["fPath"].ToString(); swf.FInTime = Convert.ToDateTime(row["fInTime"].ToString()); swf.DeptInfo = (DeptInfo)DeptInfoService.GetDeptInfoByDID(Convert.ToInt32(row["sID"].ToString())); return swf; }