/// <summary>
/// 增加一条记录
/// </summary>
public long Insert(OrderChild orderChild)
{
const string insertSql = @"
insert into OrderChild(OrderId,ChildId,TotalPrice,GoodPrice,DeliveryPrice,PayStyle,PayType,
PayStatus,PayBy,PayTime,PayPrice,HasUploadTicket,TicketUrl,CreateBy,CreateTime,UpdateBy,UpdateTime)
values(@OrderId,@ChildId,@TotalPrice,@GoodPrice,@DeliveryPrice,@PayStyle,@PayType,
@PayStatus,@PayBy,@PayTime,@PayPrice,@HasUploadTicket,@TicketUrl,@CreateBy,@CreateTime,@UpdateBy,@UpdateTime)
select @@IDENTITY";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("OrderId", orderChild.OrderId);
dbParameters.AddWithValue("ChildId", orderChild.ChildId);
dbParameters.AddWithValue("TotalPrice", orderChild.TotalPrice);
dbParameters.AddWithValue("GoodPrice", orderChild.GoodPrice);
dbParameters.AddWithValue("DeliveryPrice", orderChild.DeliveryPrice);
dbParameters.AddWithValue("PayStyle", orderChild.PayStyle);
dbParameters.AddWithValue("PayType", orderChild.PayType);
dbParameters.AddWithValue("PayStatus", orderChild.PayStatus);
dbParameters.AddWithValue("PayBy", orderChild.PayBy);
dbParameters.AddWithValue("PayTime", orderChild.PayTime);
dbParameters.AddWithValue("PayPrice", orderChild.PayPrice);
dbParameters.AddWithValue("HasUploadTicket", orderChild.HasUploadTicket);
dbParameters.AddWithValue("TicketUrl", orderChild.TicketUrl);
dbParameters.AddWithValue("CreateBy", orderChild.CreateBy);
dbParameters.AddWithValue("CreateTime", orderChild.CreateTime);
dbParameters.AddWithValue("UpdateBy", orderChild.UpdateBy);
dbParameters.AddWithValue("UpdateTime", orderChild.UpdateTime);
object result = DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters); //提现单号
return(ParseHelper.ToLong(result));
}
/// <summary>
/// 更新一条记录
/// </summary>
public void Update(OrderChild orderChild)
{
const string updateSql = @"
update OrderChild
set OrderId=@OrderId,ChildId=@ChildId,TotalPrice=@TotalPrice,GoodPrice=@GoodPrice,
DeliveryPrice=@DeliveryPrice,PayStyle=@PayStyle,PayType=@PayType,PayStatus=@PayStatus,
PayBy=@PayBy,PayTime=@PayTime,PayPrice=@PayPrice,HasUploadTicket=@HasUploadTicket,
TicketUrl=@TicketUrl,CreateBy=@CreateBy,CreateTime=@CreateTime,UpdateBy=@UpdateBy,UpdateTime=@UpdateTime
where Id=@Id ";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("Id", orderChild.Id);
dbParameters.AddWithValue("OrderId", orderChild.OrderId);
dbParameters.AddWithValue("ChildId", orderChild.ChildId);
dbParameters.AddWithValue("TotalPrice", orderChild.TotalPrice);
dbParameters.AddWithValue("GoodPrice", orderChild.GoodPrice);
dbParameters.AddWithValue("DeliveryPrice", orderChild.DeliveryPrice);
dbParameters.AddWithValue("PayStyle", orderChild.PayStyle);
dbParameters.AddWithValue("PayType", orderChild.PayType);
dbParameters.AddWithValue("PayStatus", orderChild.PayStatus);
dbParameters.AddWithValue("PayBy", orderChild.PayBy);
dbParameters.AddWithValue("PayTime", orderChild.PayTime);
dbParameters.AddWithValue("PayPrice", orderChild.PayPrice);
dbParameters.AddWithValue("HasUploadTicket", orderChild.HasUploadTicket);
dbParameters.AddWithValue("TicketUrl", orderChild.TicketUrl);
dbParameters.AddWithValue("CreateBy", orderChild.CreateBy);
dbParameters.AddWithValue("CreateTime", orderChild.CreateTime);
dbParameters.AddWithValue("UpdateBy", orderChild.UpdateBy);
dbParameters.AddWithValue("UpdateTime", orderChild.UpdateTime);
DbHelper.ExecuteNonQuery(SuperMan_Write, updateSql, dbParameters);
}
/// <summary>
/// 根据ID获取对象
/// </summary>
public OrderChild GetById(long id)
{
OrderChild model = new OrderChild();
const string querysql = @"
select Id,OrderId,ChildId,TotalPrice,GoodPrice,DeliveryPrice,PayStyle,PayType,PayStatus,
PayBy,PayTime,PayPrice,HasUploadTicket,TicketUrl,CreateBy,CreateTime,UpdateBy,UpdateTime
from OrderChild (nolock)
where Id=@Id ";
IDbParameters dbParameters = DbHelper.CreateDbParameters("Id", DbType.Int64, 8, id);
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql, dbParameters));
if (DataTableHelper.CheckDt(dt))
{
model = DataTableHelper.ConvertDataTableList <OrderChild>(dt)[0];
}
return(model);
}
public async Task <ObservableCollection <FirebaseObject <Announcements> > > getAnnounData(string order, string val, OrderChild param, int count)
{
try
{
var collection = new ObservableCollection <FirebaseObject <Announcements> >();
var data_list = (await service.GET_list <Announcements>(order, val, param, count));
var convertList = new ObservableCollection <FirebaseObject <Announcements> >();
foreach (var item in data_list)
{
convertList.Add(correct_Item(item));
}
return(convertList);
}
catch (Exception ex)
{
Console.WriteLine("AnnMVVM error" + ex.Message);
return(AnnList);
}
}
/// <summary>
/// 修改一条记录
///<param name="clienterFinanceAccount">要修改的对象</param>
/// </summary>
public void Modify(OrderChild orderChild)
{
_orderChildDao.Update(orderChild);
}
/// <summary>
/// 新增一条记录
///<param name="clienterFinanceAccount">要新增的对象</param>
/// </summary>
public long Create(OrderChild orderChild)
{
return(_orderChildDao.Insert(orderChild));
}
//Read List order
public async Task <List <FirebaseObject <T> > > GET_list <T>(string orderVal, string val, OrderChild firstOrlast, int count)
{
try
{
var newsFeedList = new List <FirebaseObject <T> >();
var newsFeedObservableList = new ObservableCollection <FirebaseObject <T> >();
switch (firstOrlast)
{
case OrderChild.startAt:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderBy(orderVal).StartAt(val).LimitToLast(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
case OrderChild.startAndEndAt:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderBy(orderVal).StartAt(val).EndAt(val).LimitToLast(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
case OrderChild.key:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderByKey().LimitToLast(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
case OrderChild.keyAndEndAt:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderByKey().EndAt(val).LimitToLast(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
case OrderChild.keyAndStartAt:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderByKey().StartAt(val).LimitToLast(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
default:
newsFeedList = (await App.fireClient.Child(typeof(T).Name.ToLower()).OrderBy(orderVal).EndAt(val).LimitToFirst(count).WithAuth(SaveUserData.userToken).OnceAsync <T>()).OrderByDescending(x => x.Key).ToList();
break;
}
return(newsFeedList);
}
catch (Exception ex)
{
if (await globalTryCatch(ex))
{
return(await GET_list <T>(orderVal, val, firstOrlast, (int)ListCount.mid));
}
else
{
Console.WriteLine("Get list error" + ex.Message);
return(new List <FirebaseObject <T> >());
}
}
}
