/// <summary> /// 修改数据记录 /// </summary> ///<param name="model">实体类</param> /// <returns>修改数据是否成功:true成功,false不成功</returns> public static bool Update(PersonalDateArrangeModel model) { ArrayList sqlList = new ArrayList(); sqlList.Add(PersonalDateArrangeDBHelper.UpdateCommand(model)); sqlList.Add(PersonalDateArrangeDBHelper.InsertMessage(model)); if (SqlHelper.ExecuteTransWithArrayList(sqlList)) { return(true); } else { return(false); } }
/// <summary> /// 插入数据记录 /// </summary> ///<param name="model">实体类</param> /// <returns>插入数据是否成功:true成功,false不成功</returns> public static bool Insert(PersonalDateArrangeModel model) { ArrayList sqlList = new ArrayList(); SqlCommand cmd = PersonalDateArrangeDBHelper.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; } sqlList.Clear(); sqlList.Add(PersonalDateArrangeDBHelper.InsertMessage(model)); SqlHelper.ExecuteTransWithArrayList(sqlList); return(true); } else { return(false); } }
/// <summary> /// 更新点评信息 /// </summary> /// <param name="model">实体类</param> /// <returns>修改数据是否成功:true成功,false不成功</returns> public static bool UpdateManager(PersonalDateArrangeModel model) { return(PersonalDateArrangeDBHelper.UpdateManager(model)); }
/// <summary> /// 删除数据记录 /// </summary> /// <param name="iD">ID集合</param> /// <returns>删除数据是否成功:true成功,false不成功</returns> public static bool Delete(string iD) { return(PersonalDateArrangeDBHelper.Delete(iD)); }
/// <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 , PersonalDateArrangeModel model) { return(PersonalDateArrangeDBHelper.SelectListData(pageIndex, pageCount, orderBy, ref TotalCount, model)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="companyCD">企业代码</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectWithKey(string companyCD) { return(PersonalDateArrangeDBHelper.SelectWithKey(companyCD)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="iD">自动生成</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectDataTable(int iD) { return(PersonalDateArrangeDBHelper.SelectDataTable(iD)); }