public bool Delete(string QQ, XResult rst) //???????
{
QqnumInfo ins = new QQNUM(QQ).INNER;
this.usp_QQNUM(ins, DataOPerType.DELETE, rst);
return(true);
}
protected void ExportCourses(Result result, XResult parent)
{
foreach (var course in result.Courses)
{
_rows.Add(new XCourse(parent, course));
}
}
public object PrintOrder(string orderId, int printonly)
{
string sqlOrder = "SELECT * FROM VM_Order WHERE OrderId = @orderId;";
string sqlDetail = "SELECT * FROM VM_DetailOrder WHERE OrderId = @orderId;";
var result = XDataHelper.ExcuteMultipleReader <VM_Order, VM_DetailOrder>(sqlOrder + sqlDetail, new { orderId });
var xres = new XResult();
var resPrint = PrintSanLiangDan(printonly, result);
if (resPrint.ret == 0)
{
xres.message = "已将订单发送至打印机！";
}
else if (resPrint.ret == 99)
{
xres.message = resPrint.msg;
xres.code = printonly != 0 ? resPrint.ret : 20000;
}
else
{
xres.code = 10000;
xres.message = $"打印机错误码为：{resPrint.ret}，错误信息为：{resPrint.msg}";
}
return(xres);
}
public async Task <XResult <T> > OperationWrap <T>(Func <Task <TableResult> > func)
{
try
{
var result = await func();
if (result.HttpStatusCode != (int)HttpStatusCode.OK && result.HttpStatusCode != (int)HttpStatusCode.NoContent)
{
return
(XResult <T> .GetBadRequest(String.Format("Table Storage not OK result: {0}",
result.HttpStatusCode)));
}
if (result.Result == null)
{
return
(XResult <T> .GetNotFound(String.Format("Table Storage item not found: {0}",
result.HttpStatusCode)));
}
return(new XResult <T>((T)result.Result));
}
catch (Exception ex)
{
_logService.TrackException(ex);
return(XResult <T> .GetException("TableStorage " + ex.ToString(), ex));
}
}
private async Task <XResult <List <TEntity> > > _sendList(string serialisedData = null, string extra = null, string method = "POST")
{
var result = await SendRaw(serialisedData, extra, method);
if (result == null || result.Result == null)
{
var o = new XResult <List <TEntity> >(null, OperationResults.NoData);
if (result != null)
{
o.StatusCode = (int)result.HttpStatusCode;
}
return(o);
}
var e = Deserialise <List <TEntity> >(result.Result);
if (OnEntityListRetreived(e))
{
return(e);
}
return(null);
}
protected XResult <T> Deserialise <T>(string entity)
{
try
{
if (OverrideSerialiser != null)
{
return(OverrideSerialiser.Deserialise <XResult <T> >(entity));
}
var e = _entitySerialiser.Deserialise <XResult <T> >(entity);
if (e == null)
{
return(XResult <T> .GetFailed(entity));
}
if (e.Message == null && e.Object == null && !e.IsSuccess)
{
e.Message = entity;
}
return(e);
}
catch (Exception ex)
{
Debug.WriteLine("Des problem: " + ex.Message);
}
return(XResult <T> .GetFailed(entity));
}
public object Save([FromBody] Order order)
{
if (order.Id <= 0)
{
throw new Exception("哦豁，没有获取到这个订单的Id。");
}
string sql = "";
order.ActuallyPrice = order.ShouldPrice;
order.DiscountRate = 1;
sql = $@"UPDATE TotalOrder SET
PositionId=@PositionId,
IsBuyed=@IsBuyed
WHERE Id = @Id";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, order))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Save([FromBody] DetailOrder detailOrder)
{
string sql = "";
if (detailOrder.Weight == 0)
{
detailOrder.Weight = 1;
}
detailOrder.ShouldPrice = detailOrder.SinglePrice * detailOrder.Weight;
if (detailOrder.Id > 0)
{
sql = $@"UPDATE DetailOrder SET
MenuId=@MenuId,
SinglePrice=@SinglePrice,
Weight=@Weight,
ShouldPrice=@ShouldPrice
WHERE Id = @Id";
}
else
{
sql = $@"INSERT INTO DetailOrder(MenuId, SinglePrice, Weight, ShouldPrice, OrderId)
VALUES(@MenuId, @SinglePrice, @Weight, @ShouldPrice, @OrderId)";
}
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, detailOrder))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Save([FromBody] Menu menu)
{
string sql = "";
if (menu.Id > 0)
{
sql = $@"UPDATE Menu SET
Name=@Name,
MenuTypeId=@MenuTypeId,
IsUsed=@IsUsed,
Price=@Price,
PriceType=@PriceType,
Description=@Description,
IsUsed=@IsUsed,
Sort=@Sort
WHERE Id = @Id";
}
else
{
sql = $@"INSERT INTO Menu(MenuTypeId, NAME, IsUsed,Price,PriceType,Description,CreateTime,Sort)
VALUES(@MenuTypeId, @Name, @IsUsed,@Price,@PriceType,@Description,DATE_ADD(NOW(), INTERVAL 12 HOUR),@Sort)";
}
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, menu))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public async Task <XResult <TEntity> > Upload(byte[] data, string extra, string method)
{
var result = await _downloader.Upload(Service + extra, method, data);
if (result == null || result.Result == null)
{
var o = new XResult <TEntity>(null, OperationResults.NoData);
if (result != null)
{
o.StatusCode = (int)result.HttpStatusCode;
}
return(o);
}
var e = Deserialise <TEntity>(result.Result);
e.StatusCode = (int)result.HttpStatusCode;
if (OnEntityRetreived(e))
{
return(e);
}
return(null);
}
public async Task <XResult <bool> > DownloadByteAsync(string blobName, string fileName)
{
var c = _getBlob(blobName);
var result = await XResiliant.Default.Run(() => OperationWrap <bool>(async() =>
{
using (var fs = new FileStream(fileName, FileMode.OpenOrCreate))
{
await c.DownloadToStreamAsync(fs);
_logRead(blobName);
return(true);
}
}));
if (!result)
{
return(XResult <bool> .GetFailed("Could not read blob"));
}
if (!File.Exists(fileName))
{
return(XResult <bool> .GetFailed("Blob file check not present"));
}
var b = File.ReadAllBytes(fileName);
return(new XResult <bool>(b.Length > 0));
}
public async Task <XResult <bool> > _validateContextChain(XSecurityContext context, Guid userId, int securityTypes)
{
if (context.Members.Contains(userId) && (context.Permissions & securityTypes) != 0)
{
return(new XResult <bool>(true, true, $"Authorised by {context.Name} ({context.Id})"));
}
var parent = await GetParentContext(context.Id);
if (!parent || parent.Object == null)
{
return
(XResult <bool> .GetNotAuthorised(
$"Could not find parent context on context {context.Name} ({context.Id}). looking for permisssions {securityTypes} "));
}
var c = await _validateContextChain(parent.Object, userId, securityTypes);
if (c)
{
return(c);
}
return
(XResult <bool> .GetNotAuthorised(
$"Could not find parent context on context {context.Name} ({context.Id}). looking for permisssions {securityTypes} (last try)"));
}
public bool usp_QQNUM(QqnumInfo ins, DataOPerType dot, XResult rst)
{
SqlCommand _comm = DbHelper.Provider.CreateCommand() as SqlCommand;
SqlConnection _conn = DbHelper.NewConnection as SqlConnection;
_comm.Connection = _conn;
_comm.CommandType = CommandType.StoredProcedure;
_comm.CommandText = "usp_QQNUM";
_conn.Open();
_comm.Parameters.Add(DbHelper.CreateParameter("@ID", DbType.Int32, ins.ID));
_comm.Parameters.Add(DbHelper.CreateParameter("@QQ", DbType.AnsiString, ins.QQ));
_comm.Parameters.Add(DbHelper.CreateParameter("@PASS", DbType.AnsiString, ins.PASS));
_comm.Parameters.Add(DbHelper.CreateParameter("@MD5PASS", DbType.AnsiString, ins.MD5PASS));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825_BYTES", DbType.AnsiString, ins.SP0X0825_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825", DbType.AnsiString, ins.SP0X0825));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825_BYTES", DbType.AnsiString, ins.RP0X0825_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825", DbType.AnsiString, ins.RP0X0825));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826_BYTES", DbType.AnsiString, ins.SP0X0826_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826", DbType.AnsiString, ins.SP0X0826));
_comm.Parameters.Add(DbHelper.CreateParameter("@VERIFYKEY", DbType.AnsiString, ins.VERIFYKEY));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826_BYTES", DbType.AnsiString, ins.RP0X0826_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826", DbType.AnsiString, ins.RP0X0826));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828_BYTES", DbType.AnsiString, ins.SP0X0828_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828", DbType.AnsiString, ins.SP0X0828));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828_BYTES", DbType.AnsiString, ins.RP0X0828_BYTES));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828", DbType.AnsiString, ins.RP0X0828));
_comm.Parameters.Add(DbHelper.CreateParameter("@DataOPerType", DbType.Int16, dot));
_comm.Parameters.Add(DbHelper.CreateParameter("@ErrCode", DbType.Int16, rst.ErrCode, 2, ParameterDirection.Output));
_comm.Parameters.Add(DbHelper.CreateParameter("@ErrMsg", DbType.AnsiString, rst.ErrMsg, 1000, ParameterDirection.Output));
_comm.ExecuteNonQuery();
rst.ErrCode = (OPerErrType)Enum.ToObject(typeof(OPerErrType), _comm.Parameters["@ErrCode"].Value);
rst.ErrMsg = _comm.Parameters["@ErrMsg"].Value.ToString();
return(true); //return
}
public bool usp_QQNUM(DataRow dr, DataOPerType dot, XResult rst)
{
SqlCommand _comm = DbHelper.Provider.CreateCommand() as SqlCommand;
SqlConnection _conn = DbHelper.NewConnection as SqlConnection;
_comm.Connection = _conn;
_comm.CommandType = CommandType.StoredProcedure;
_comm.CommandText = "usp_QQNUM";
_conn.Open();
_comm.Parameters.Add(DbHelper.CreateParameter("@ID", DbType.Int32, dr.RowState == DataRowState.Deleted ? (object)dr["ID", DataRowVersion.Original]:(object)dr["ID"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@QQ", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["QQ", DataRowVersion.Original]:(object)dr["QQ"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["PASS", DataRowVersion.Original]:(object)dr["PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@MD5PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["MD5PASS", DataRowVersion.Original]:(object)dr["MD5PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825_BYTES", DataRowVersion.Original]:(object)dr["SP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825", DataRowVersion.Original]:(object)dr["SP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825_BYTES", DataRowVersion.Original]:(object)dr["RP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825", DataRowVersion.Original]:(object)dr["RP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826_BYTES", DataRowVersion.Original]:(object)dr["SP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826", DataRowVersion.Original]:(object)dr["SP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@VERIFYKEY", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["VERIFYKEY", DataRowVersion.Original]:(object)dr["VERIFYKEY"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826_BYTES", DataRowVersion.Original]:(object)dr["RP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826", DataRowVersion.Original]:(object)dr["RP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828_BYTES", DataRowVersion.Original]:(object)dr["SP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828", DataRowVersion.Original]:(object)dr["SP0X0828"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828_BYTES", DataRowVersion.Original]:(object)dr["RP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828", DataRowVersion.Original]:(object)dr["RP0X0828"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@DataOPerType", DbType.Int16, dot));
_comm.Parameters.Add(DbHelper.CreateParameter("@ErrCode", DbType.Int16, rst.ErrCode, 2, ParameterDirection.Output));
_comm.Parameters.Add(DbHelper.CreateParameter("@ErrMsg", DbType.AnsiString, rst.ErrMsg, 1000, ParameterDirection.Output));
_comm.ExecuteNonQuery();
rst.ErrCode = (OPerErrType)Enum.ToObject(typeof(OPerErrType), _comm.Parameters["@ErrCode"].Value);
rst.ErrMsg = _comm.Parameters["@ErrMsg"].Value.ToString();
return(true); //return
}
public object Get(int id)
{
var result = new XResult();
var select = $"SELECT * FROM BlogArticle WHERE ID = @id";
var one = XDataHelper.ExcuteReader <BlogArticle>(select, new { id }).SingleOrDefault();
result.Data = one;
return(result);
}
public async Task <XResult <XSecurityContext> > GetContextById(Guid contextId)
{
var existing = _contexts.FirstOrDefault(_ => _.Id == contextId);
if (existing == null)
{
return(XResult <XSecurityContext> .GetNoRecord());
}
return(new XResult <XSecurityContext>(existing));
}
//UpdateDB
#region Update Methods
public bool UpdateDB(DataTable dt, XResult rst)
{
SqlCommand _comm = DbHelper.Provider.CreateCommand() as SqlCommand;
SqlConnection _conn = DbHelper.NewConnection as SqlConnection;
_conn.Open();
_comm.Connection = _conn;
_comm.Transaction = _conn.BeginTransaction();
try
{
foreach (DataRow dr in dt.Rows)
{
switch (dr.RowState)
{
case DataRowState.Added:
{
this.usp_QQNUM(dr, DataOPerType.INSERT, rst);
if (rst.ErrCode != OPerErrType.SUCCESS)
{
return(false);
}
break;
}
case DataRowState.Modified:
{
this.usp_QQNUM(dr, DataOPerType.UPDATE, rst);
if (rst.ErrCode != OPerErrType.SUCCESS)
{
return(false);
}
break;
}
case DataRowState.Deleted:
{
this.usp_QQNUM(dr, DataOPerType.DELETE, rst);
if (rst.ErrCode != OPerErrType.SUCCESS)
{
return(false);
}
break;
}
}
}
_comm.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
_comm.Transaction.Rollback();
return(false);
}
}
public async Task <XResult <XSecurityContext> > GetParentContext(Guid contextId)
{
var existing = _contexts.FirstOrDefault(_ => _.Children.Contains(contextId));
if (existing == null)
{
return(XResult <XSecurityContext> .GetNoRecord());
}
return(new XResult <XSecurityContext>(existing));
}
async Task <XResult <bool> > _retry()
{
await Task.Delay(500);
if (count == 0)
{
count++;
return(XResult <bool> .GetFailed("Could not do someting"));
}
return(new XResult <bool>(true));
}
public object GetImageToken()
{
var result = new XResult();
QiniuUpload qiniu = new QiniuUpload();
if (string.IsNullOrEmpty(qiniu.Token))
{
result.Code = 10000;
result.Message = "获取Token失败";
}
result.Data = qiniu.Token;
return(result);
}
public object Delete(int id)
{
var result = new XResult();
var delete = "UPDATE BlogArticle SET DELETETIME=NOW(), IsDeleted=1 WHERE ID = @id";
if (XDataHelper.ExcuteNonQuery(delete, new { id }))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public async Task <XResult <T> > OperationWrap <T>(Func <Task <T> > func)
{
try
{
var result = await func();
return(new XResult <T>(result));
}
catch (Exception ex)
{
_logService.TrackException(ex);
return(XResult <T> .GetException("BlobStorage " + ex.ToString(), ex));
}
}
public async Task <XResult <bool> > RunBool(Func <Task <bool> > func)
{
return(await Run(async() =>
{
var result = await func();
if (!result)
{
return XResult <bool> .GetFailed();
}
return new XResult <bool>(true);
}));
}
public static XResult <T> Log <T>(this XResult <T> result, ILifetimeScope scope, string operationName = null)
{
if (ContainerHost.Container == null)
{
Debug.WriteLine("Warning - ContainerHost.Container is empty. Could not log operation");
return(result);
}
var logger = scope.Resolve <ILogService>();
logger.TrackOperation(result, operationName);
return(result);
}
public object Login([FromBody] TempLoginClass user)
{
var result = new XResult();
if (user.UserName == "xuhong" && user.Password == "xuhongadmin")
{
result.data = "xuhong";
}
else
{
result.code = 10000;
}
return(result);
}
public object Login([FromBody] User user)
{
var result = new XResult();
if (user.username == "admin" && user.password == "admin")
{
result.Code = 20000;
result.Data = user.username;
return(result);
}
result.Code = -1;
result.Message = "用户名密码错误.";
return(result);
}
public object Add([FromBody] BlogArticle model)
{
var result = new XResult();
var insert = $@"INSERT INTO BlogArticle (Title,Category,Tag,Content,ReadCount,CreateTime,ModifiedTime)VALUES ('{model.Title}','{model.Category}','{model.Tag}','{model.Content}',0,NOW(),NOW())";
if (XDataHelper.ExcuteNonQuery(insert))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public object Update(int id)
{
var result = new XResult();
var update = $@"UPDATE BlogArticle SET ReadCount = (ReadCount+1) WHERE ID = @id";
if (XDataHelper.ExcuteNonQuery(update, new { id }))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public object DeleteOrder(string orderId)
{
string sql = @"DELETE FROM TotalOrder WHERE OrderId=@orderId;
DELETE FROM DetailOrder WHERE OrderId=@orderId;";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, new { orderId }))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Save([FromBody] Setting setting)
{
string sql = "";
sql = $"UPDATE TytfSetting SET Value=@Value WHERE Id = @Id";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, setting))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
