public static void SaveRemarks(ListView lv, string remarks) { int newRemarksID; IDataParameter[] parameters = new System.Data.IDataParameter[4]; //实例化参数对象 parameters[0] = new SqlParameter("@Remarks", remarks); //参数对象赋值 parameters[1] = new SqlParameter("@Founder", "songxi"); //需改成变量change parameters[2] = new SqlParameter("@newRemarksID", SqlDbType.Int); parameters[3] = new SqlParameter("@returnMessage", string.Empty); parameters[2].Direction = ParameterDirection.Output; parameters[3].Direction = ParameterDirection.Output; BaseSQL.RunProcedure("GetNewRemarksID", parameters); newRemarksID = Convert.ToInt32(parameters[2].Value);// FrmAddRemarksDAO.sqlLlist.Clear(); foreach (ListViewItem lvi in lv.SelectedItems) { //项目或文档ID int itemID = Convert.ToInt32(lvi.Tag); try { //如果是文件夹 if (lvi.SubItems[4].Text == "folder") { //获得项目列表 DataTable dt = FrmProjectDocumentDAO.GetAllLevelProjects(itemID); //项目下的所有项目 foreach (DataRow dr in dt.Rows) { //调用保存【项目备注】方法 FrmAddRemarksDAO.SaveProjectsRemarks_AddSql(Convert.ToInt32(dr["projectID"]), newRemarksID); } //获得文件列表 dt = FrmProjectDocumentDAO.GetAllLevelDocuments(itemID); //项目下的所有文件 foreach (DataRow dr in dt.Rows) { //调用保存【文档备注】方法 FrmAddRemarksDAO.SaveDocumentsRemarks_AddSql(Convert.ToInt32(dr["documentID"]), newRemarksID); } } else//如果是文件 { DataRow dr; dr = FrmProjectDocumentDAO.GetDocumentInfo(itemID); //调用保存【文档备注】方法 FrmAddRemarksDAO.SaveDocumentsRemarks_AddSql(Convert.ToInt32(dr["documentID"]), newRemarksID); } BaseSQL.ExecuteSqlTran(FrmAddRemarksDAO.sqlLlist); } catch (Exception e) { MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
/// <summary> /// 获得当前所选项备注信息 /// </summary> /// <param name="lvi">当前所选的第一项</param> public static void GetRemarksInfo(DataSet ds, ListViewItem lvi) { try { if (lvi.SubItems[4].Text == "folder") { FrmAddRemarksDAO.GetProjectsRemarks(ds, Convert.ToInt32(lvi.Tag)); } else { FrmAddRemarksDAO.GetDocumentsRemarks(ds, Convert.ToInt32(lvi.Tag)); } } catch (Exception ex) { MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 获得当前所选项备注信息 /// </summary> /// <param name="lvi">当前所选的第一项</param> public static void GetRemarksInfo(DataSet ds, ListViewItem lvi) { try { if (lvi.SubItems[4].Text == "folder") { FrmAddRemarksDAO.GetProjectsRemarks(ds, Convert.ToInt32(lvi.Tag)); } else { FrmAddRemarksDAO.GetDocumentsRemarks(ds, Convert.ToInt32(lvi.Tag)); } } catch (Exception ex) { ExceptionHandler.HandleException("GetRemarksInfo error", ex); } }