/// <summary> /// 更新商户Staff /// </summary> /// <returns></returns> public int UpdateShopStaff(ShopStaffModel model) { var sqlStr = new StringBuilder("update coupon_shop_staff set "); sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sqlStr.Append(" where innerid = @innerid"); using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sqlStr.ToString(), model, tran); tran.Commit(); return 1; } catch (Exception ex) { LoggerFactories.CreateLogger().Write("更新商户Staff异常:", TraceEventType.Error, ex); tran.Rollback(); return 0; } } }
/// <summary> /// 添加职员 /// </summary> /// <returns></returns> public int AddShopStaff(ShopStaffModel model) { const string sql = "insert into coupon_shop_staff (innerid,shopid, loginname, staffname, sex, mobile, email, status, createdtime, modifiedtime) " + "values (@innerid,@shopid, @loginname, @staffname, @sex, @mobile, @email, @status, @createdtime, @modifiedtime);"; try { Helper.Execute(sql, model); return 1; } catch (Exception ex) { LoggerFactories.CreateLogger().Write("添加职员异常:", TraceEventType.Error, ex); return 0; } }