/// <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); } }