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