/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TypeToItem model)
{
using (DBHelper db = DBHelper.Create())
{
db.Insert <TypeToItem>(model);
}
}
/// <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);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TypeToItem model)
{
using (DBHelper db = DBHelper.Create())
{
db.Update <TypeToItem>(model);
return(true);
}
}
