/// <summary> /// 将 已上传文件大小、文件本地地址 参数写入到数据库中 /// </summary> /// <returns></returns> public static void updateFilesSize() { Maticsoft.BLL.evidence evidence_update = new Maticsoft.BLL.evidence(); Maticsoft.Model.evidence evidence_model = new Maticsoft.Model.evidence(); DataSet ds = evidence_update.GetList("1=1 ORDER BY id desc LIMIT 1"); evidence_model.id = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()); evidence_model.evName = ds.Tables[0].Rows[0]["evName"].ToString(); evidence_model.caseID = Convert.ToInt32(ds.Tables[0].Rows[0]["caseID"].ToString()); evidence_model.evType = Convert.ToInt32(ds.Tables[0].Rows[0]["evType"].ToString()); evidence_model.comment = ds.Tables[0].Rows[0]["comment"].ToString(); evidence_model.evAdmin = ds.Tables[0].Rows[0]["evAdmin"].ToString(); evidence_model.dataTypes = Convert.ToInt32(ds.Tables[0].Rows[0]["dataTypes"].ToString()); evidence_model.finished = "-1"; evidence_model.localPath = totalPathName; // 文件本地上传根目录 evidence_update.Update(evidence_model); Console.WriteLine("---------------更新数据库信息:" + evidence_model.id + " " + evidence_model.dirPath); }
//上传成功后更新evidence 中的字段finished='true' public void updateFilesSuccStatus() { Maticsoft.BLL.evidence evidence_update = new Maticsoft.BLL.evidence(); Maticsoft.Model.evidence evidence_model = new Maticsoft.Model.evidence(); DataSet ds = evidence_update.GetList("1=1 ORDER BY id desc LIMIT 1"); evidence_model.id = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()); evidence_model.evName = ds.Tables[0].Rows[0]["evName"].ToString(); evidence_model.caseID = Convert.ToInt32(ds.Tables[0].Rows[0]["caseID"].ToString()); evidence_model.evType = Convert.ToInt32(ds.Tables[0].Rows[0]["evType"].ToString()); evidence_model.comment = ds.Tables[0].Rows[0]["comment"].ToString(); evidence_model.evAdmin = ds.Tables[0].Rows[0]["evAdmin"].ToString(); evidence_model.dataTypes = Convert.ToInt32(ds.Tables[0].Rows[0]["dataTypes"].ToString()); evidence_model.finished = "true"; evidence_model.localPath = ds.Tables[0].Rows[0]["localPath"].ToString(); evidence_update.Update(evidence_model); Console.WriteLine("---------------更新数据库信息:" + evidence_model.id + " " + evidence_model.evName + " " + evidence_model.caseID); filesBeans[index].setId(evidence_model.id); filesBeans[index].setHasBean(Convert.ToBoolean(evidence_model.finished)); }