public object GetItem(IDataReader dr, ref int index)
{
RentsubletInfo item = new RentsubletInfo();
if (!dr.IsDBNull(++index))
{
item.Id = (uint?)dr.GetInt32(index);
}
if (!dr.IsDBNull(++index))
{
item.Market_id = (uint?)dr.GetInt32(index);
}
if (!dr.IsDBNull(++index))
{
item.Create_time = (DateTime?)dr.GetDateTime(index);
}
if (!dr.IsDBNull(++index))
{
item.Price = (decimal?)dr.GetDecimal(index);
}
if (!dr.IsDBNull(++index))
{
item.Type = (RentsubletTYPE?)dr.GetInt64(index);
}
return(item);
}
public int Update(RentsubletInfo item)
{
return(new SqlUpdateBuild(null, item.Id.Value)
.SetMarket_id(item.Market_id)
.SetCreate_time(item.Create_time)
.SetPrice(item.Price)
.SetType(item.Type).ExecuteNonQuery());
}
private static void RemoveCache(RentsubletInfo item)
{
if (item == null)
{
return;
}
RedisHelper.Remove(string.Concat("pifa_BLL_Rentsublet_", item.Id));
}
public static pifa.DAL.Rentsublet.SqlUpdateBuild UpdateDiy(RentsubletInfo item, uint Id)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item != null ? item : GetItem(Id));
}
return(new pifa.DAL.Rentsublet.SqlUpdateBuild(item, Id));
}
public static int Update(RentsubletInfo item)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(dal.Update(item));
}
public static RentsubletInfo Insert(RentsubletInfo item)
{
item = dal.Insert(item);
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(item);
}
protected static MySqlParameter[] GetParameters(RentsubletInfo item)
{
return(new MySqlParameter[] {
GetParameter("?id", MySqlDbType.UInt32, 10, item.Id),
GetParameter("?market_id", MySqlDbType.UInt32, 10, item.Market_id),
GetParameter("?create_time", MySqlDbType.DateTime, -1, item.Create_time),
GetParameter("?price", MySqlDbType.Decimal, 10, item.Price),
GetParameter("?type", MySqlDbType.Enum, -1, item.Type?.ToInt64())
});
}
public RentsubletInfo Insert(RentsubletInfo item)
{
uint loc1;
if (uint.TryParse(string.Concat(SqlHelper.ExecuteScalar(TSQL.Insert, GetParameters(item))), out loc1))
{
item.Id = loc1;
}
return(item);
}
public ActionResult Edit([FromQuery] uint Id)
{
RentsubletInfo item = Rentsublet.GetItem(Id);
if (item == null)
{
return(APIReturn.记录不存在_或者没有权限);
}
ViewBag.item = item;
return(View());
}
public APIReturn _Add([FromForm] uint?Market_id, [FromForm] decimal?Price, [FromForm] RentsubletTYPE?Type, [FromForm] uint[] mn_Franchising)
{
RentsubletInfo item = new RentsubletInfo();
item.Market_id = Market_id;
item.Create_time = DateTime.Now;
item.Price = Price;
item.Type = Type;
item = Rentsublet.Insert(item);
//关联 Franchising
foreach (uint mn_Franchising_in in mn_Franchising)
{
item.FlagFranchising(mn_Franchising_in);
}
return(APIReturn.成功.SetData("item", item.ToBson()));
}
public APIReturn _Edit([FromQuery] uint Id, [FromForm] uint?Market_id, [FromForm] decimal?Price, [FromForm] RentsubletTYPE?Type, [FromForm] uint[] mn_Franchising)
{
RentsubletInfo item = Rentsublet.GetItem(Id);
if (item == null)
{
return(APIReturn.记录不存在_或者没有权限);
}
item.Market_id = Market_id;
item.Create_time = DateTime.Now;
item.Price = Price;
item.Type = Type;
int affrows = Rentsublet.Update(item);
//关联 Franchising
if (mn_Franchising.Length == 0)
{
item.UnflagFranchisingALL();
}
else
{
List <uint> mn_Franchising_list = mn_Franchising.ToList();
foreach (var Obj_franchising in item.Obj_franchisings)
{
int idx = mn_Franchising_list.FindIndex(a => a == Obj_franchising.Id);
if (idx == -1)
{
item.UnflagFranchising(Obj_franchising.Id);
}
else
{
mn_Franchising_list.RemoveAt(idx);
}
}
mn_Franchising_list.ForEach(a => item.FlagFranchising(a));
}
if (affrows > 0)
{
return(APIReturn.成功.SetMessage($"更新成功，影响行数：{affrows}"));
}
return(APIReturn.失败);
}
public static RentsubletInfo GetItem(uint Id)
{
if (itemCacheTimeout <= 0)
{
return(Select.WhereId(Id).ToOne());
}
string key = string.Concat("pifa_BLL_Rentsublet_", Id);
string value = RedisHelper.Get(key);
if (!string.IsNullOrEmpty(value))
{
try { return(RentsubletInfo.Parse(value)); } catch { }
}
RentsubletInfo item = Select.WhereId(Id).ToOne();
if (item == null)
{
return(null);
}
RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
return(item);
}
public SqlUpdateBuild(RentsubletInfo item, uint Id)
{
_item = item;
_where = SqlHelper.Addslashes("`id` = {0}", Id);
}
