/// <summary> /// 增加一条数据 /// </summary> public void Add(TypeToItem model) { using (DBHelper db = DBHelper.Create()) { db.Insert<TypeToItem>(model); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Ajax.Model.TypeToItem model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Ajax.Model.TypeToItem model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TypeToItem model) { using (DBHelper db = DBHelper.Create()) { db.Update<TypeToItem>(model); return true; } }
/// <summary> /// 修改客户类型对应的缴费项 /// </summary> /// <param name="customerTypeID"></param> /// <param name="chargeItemList"></param> /// <returns></returns> public bool ModifyTypeToItem(string customerTypeID, List<string> chargeItemList) { using (DBHelper db = DBHelper.Create()) { db.BeginTransaction(); string deleteSql = "delete from T_TYPETOITEM where TYPEID=@CUSTOMERTYPEID"; Dictionary<string, object> param = new Dictionary<string, object>(); param.Add("CUSTOMERTYPEID", customerTypeID); db.ExecuteNonQuery(deleteSql, param); //新增收费项 if (chargeItemList == null || chargeItemList.Count == 0) { db.RollBack(); return false; } List<TypeToItem> list = new List<TypeToItem>(); foreach (string itemID in chargeItemList) { if (string.IsNullOrEmpty(itemID)) continue; TypeToItem newItem = new TypeToItem(); newItem.ID = Guid.NewGuid().ToString("N"); newItem.TypeID = customerTypeID; newItem.ItemID = itemID; list.Add(newItem); }; db.InsertBatch<TypeToItem>(list.ToArray()); db.Commit(); return true; } }