/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <param name="list"></param> /// <returns></returns> public static bool SaveData(UnitGroupModel model, IList <UnitGroupDetailModel> list) { ArrayList sqlList = new ArrayList(); if (!model.ID.HasValue) {// 新增 sqlList.Add(UnitGroupDBHelper.InsertCommand(model)); } else {// 修改 sqlList.Add(UnitGroupDBHelper.UpdateCommand(model)); sqlList.Add(UnitGroupDetailDBHelper.DeleteCommand(model.CompanyCD, model.GroupUnitNo)); } foreach (UnitGroupDetailModel info in list) { sqlList.Add(UnitGroupDetailDBHelper.InsertCommand(info)); } if (SqlHelper.ExecuteTransWithArrayList(sqlList)) { return(true); } else { return(false); } }
/// <summary> /// 删除数据 /// </summary> /// <param name="iD"></param> /// <param name="CompanyCD"></param> /// <param name="GroupUnitNo"></param> /// <returns></returns> public static bool DeleteData(int[] iD, string CompanyCD, string[] GroupUnitNo) { ArrayList sqlList = new ArrayList(); for (int i = 0; i < iD.Length; i++) { sqlList.Add(UnitGroupDBHelper.DeleteCommand(iD[i])); if (i < GroupUnitNo.Length) { sqlList.Add(UnitGroupDetailDBHelper.DeleteCommand(CompanyCD, GroupUnitNo[i])); } } if (SqlHelper.ExecuteTransWithArrayList(sqlList)) { return(true); } else { return(false); } }
/// <summary> /// 计量单位组唯一验证 /// </summary> /// <param name="companyCD">公司代码</param> /// <param name="GroupUnitNo">组代码</param> /// <param name="id">记录ID</param> /// <returns></returns> public static bool CheckUnitNo(string companyCD, string GroupUnitNo, int?id) { return(UnitGroupDBHelper.CheckUnitNo(companyCD, GroupUnitNo, id)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="companyCD">企业代码</param> /// <param name="groupUnitNo">计量单位组编号</param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectDataTable(string companyCD, string groupUnitNo) { return(UnitGroupDBHelper.SelectDataTable(companyCD, groupUnitNo)); }
/// <summary> /// 查询数据记录 /// </summary> /// <param name="iD"></param> /// <returns>返回DataSet数据集</returns> public static DataTable SelectDataTable(int iD) { return(UnitGroupDBHelper.SelectDataTable(iD)); }
/// <summary> /// 查询界面列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageCount"></param> /// <param name="orderBy"></param> /// <param name="TotalCount"></param> /// <param name="CompanyCD"></param> /// <param name="GroupUnitNo"></param> /// <param name="GroupUnitName"></param> /// <param name="BaseUnitID"></param> /// <param name="Remark"></param> /// <returns></returns> public static DataTable SelectListData(int pageIndex, int pageCount, string orderBy, ref int TotalCount , string CompanyCD, string GroupUnitNo, string GroupUnitName, int?BaseUnitID, string Remark) { return(UnitGroupDBHelper.SelectListData(pageIndex, pageCount, orderBy, ref TotalCount, CompanyCD, GroupUnitNo, GroupUnitName, BaseUnitID, Remark)); }