/// <summary> /// 删除数据记录 /// </summary> /// <param name="iD">ID集合</param> /// <returns>删除数据是否成功:true成功,false不成功</returns> public static bool Delete(List <int> list) { ArrayList sqlList = new ArrayList(); foreach (int id in list) { sqlList.Add(PersonalNoteReportDBHelper.DeleteCommandWithKey(id)); } return(SqlHelper.ExecuteTransWithArrayList(sqlList)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model">日志实体类</param> /// <param name="list">汇报集合</param> /// <returns></returns> public static bool SaveData(PersonalNoteModel model, IList <PersonalNoteReportModel> list) { ArrayList sqlList = new ArrayList(); SqlCommand cmd = null; #region 日志 if (model.ID.HasValue) {// 编号存在更新 sqlList.Add(PersonalNoteDBHelper.UpdateCommand(model)); } else {// 编号不存在保存 cmd = PersonalNoteDBHelper.InsertCommand(model); sqlList.Add(cmd); } #endregion #region 汇报信息 foreach (PersonalNoteReportModel item in list) { if (item.ID.HasValue) { sqlList.Add(PersonalNoteReportDBHelper.UpdateCommand(item)); } else { sqlList.Add(PersonalNoteReportDBHelper.InsertCommand(item)); } } #endregion // 保存数据 if (SqlHelper.ExecuteTransWithArrayList(sqlList)) { if (!model.ID.HasValue) { int i = 0; if (int.TryParse(cmd.Parameters["@IndexID"].Value.ToString(), out i)) { model.ID = i; } } return(true); } else { return(false); } }
/// <summary> /// 插入数据记录 /// </summary> ///<param name="model">实体类</param> /// <returns>插入数据是否成功:true成功,false不成功</returns> public static bool Insert(PersonalNoteReportModel model) { ArrayList sqlList = new ArrayList(); SqlCommand cmd = PersonalNoteReportDBHelper.InsertCommand(model); sqlList.Add(cmd); if (SqlHelper.ExecuteTransWithArrayList(sqlList)) { int i = 0; if (int.TryParse(cmd.Parameters["@IndexID"].Value.ToString(), out i)) { model.ID = i; } return(true); } else { return(false); } }
/// <summary> /// 修改数据记录 /// </summary> ///<param name="model">实体类</param> /// <returns>修改数据是否成功:true成功,false不成功</returns> public static bool Update(PersonalNoteReportModel model) { return(PersonalNoteReportDBHelper.Update(model)); }
/// <summary> /// 列表界面查询方法 /// </summary> /// <param name="pageIndex">当前页</param> /// <param name="pageCount">每页记录数</param> /// <param name="orderBy">排序方法</param> /// <param name="TotalCount">总记录数</param> /// <param name="model">实体类</param> /// <returns></returns> public static DataTable SelectListData(int pageIndex, int pageCount, string orderBy, ref int TotalCount , PersonalNoteReportModel model) { return(PersonalNoteReportDBHelper.SelectListData(pageIndex, pageCount, orderBy, ref TotalCount, model)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="noteNo">日志编号</param> /// <param name="reportID">汇报流水号(任务流水号,日程流水号)</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectWithKey(string noteNo, int reportID) { return(PersonalNoteReportDBHelper.SelectWithKey(noteNo, reportID)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="iD">流水号</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectDataTable(int iD) { return(PersonalNoteReportDBHelper.SelectDataTable(iD)); }
/// <summary> /// 根据任务ID获得汇报信息 /// </summary> /// <param name="CompanyCD">企业代码</param> /// <param name="ReportID">任务ID</param> /// <param name="ReportType">报表类别</param> /// <returns>返回DataSet数据集</returns> public static DataTable GetTaskReport(string CompanyCD, int ReportID, int ReportType) { return(PersonalNoteReportDBHelper.GetTaskReport(CompanyCD, ReportID, ReportType)); }
/// <summary> /// 根据日志编号查询数据记录 /// </summary> /// <param name="noteNo">企业代码</param> /// <param name="reportID">日志编号</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectWithNoteNo(string CompanyCD, string noteNo) { return(PersonalNoteReportDBHelper.SelectWithNoteNo(CompanyCD, noteNo)); }
/// <summary> /// 删除数据记录 /// </summary> /// <param name="iD">ID集合</param> /// <returns>删除数据是否成功:true成功,false不成功</returns> public static bool Delete(string iD) { return(PersonalNoteReportDBHelper.Delete(iD)); }