public string withDrawApi()
{
string externalNo = TQuery.GetInput("externalNo");
string amount = TQuery.GetInput("amount");
return("{ \"code\": \"0000\", \"message\": \"收款发起成功\",\"serialNo\":\"1111\",\"customerNumber\":\"123456\",\"amount\":\"" + amount + "\",\"externalNo\":\"" + externalNo + "\",\"mainCustomerNumber\":\"1111\",\"transferWay\":\"1\",\"hmac\":\"21212\"}");
}
public ActionResult CustomerInforQuery()
{
int UserId = TQuery.GetInt("UserId");
string Mobile = TQuery.GetSafeString("Mobile");
respCustomerInforQueryModel result = new respCustomerInforQueryModel();
if (UserId == 0)
{
if (!string.IsNullOrEmpty(Mobile))
{
result = YeepayDepository.CustomerInforQuery(Mobile, (int)Logic.Platform.系统);
}
else
{
result.backState = -100;
result.message = "";
}
}
else
{
result = YeepayDepository.CustomerInforQuery(UserId, (int)Logic.Platform.系统);
}
return(View(result));
}
public FCSingleSeries ChartGetByQueryCodeSingle(string loginKey, ref ErrorInfo err, string queryCode, IList <QueryPara> paraList, ref string reSql)
{
GlobalUser gu = Global.GetUser(loginKey);
if (gu == null)
{
err.IsError = true;
err.Message = "登录超时，请重新登录";
}
FCSingleSeries fc = new FCSingleSeries();
using (DBEntities db = new DBEntities())
{
var query = db.YL_QUERY.SingleOrDefault(x => x.CODE == queryCode);
TQuery ent = Fun.ClassToCopy <YL_QUERY, TQuery>(query);
string whereStr = "";
DataTable reDt = QueryDataTable(loginKey, ref err, queryCode, null, whereStr, paraList, ref reSql);
for (int i = 0; i < reDt.Rows.Count; i++)
{
fc.data.Add(new FCSingleSeries_data {
label = reDt.Rows[i][0].ToString(), value = reDt.Rows[i][1].ToString()
});
}
}
return(fc);
}
public DataTable QueryExecute(string loginKey, ref ErrorInfo err, string queryCode, int pageIndex, int pageSize, string orderStr, string whereJsonStr, IList <QueryPara> paraList, ref string sqlStr)
{
DataTable reDt = new DataTable();
GlobalUser gu = Global.GetUser(loginKey);
if (gu == null)
{
err.IsError = true;
err.Message = "用户【" + loginKey + "】登录超时，请重新登录";
return(reDt);
}
using (DBEntities db = new DBEntities())
{
var query = db.YL_QUERY.SingleOrDefault(x => x.CODE == queryCode);
TQuery ent = Fun.ClassToCopy <YL_QUERY, TQuery>(query);
IList <QueryCfg> cfg = JSON.EncodeToEntity <IList <QueryCfg> >(query.QUERY_CFG_JSON);
string whereStr = "";
ent.QUERY_CONF = MakeSql(gu, ent.QUERY_CONF, orderStr, whereJsonStr, paraList, ref whereStr, Fun.GetDataBaseType());
try
{
sqlStr = ent.QUERY_CONF;
reDt = ExecuteSql(ent.QUERY_CONF, pageIndex, pageSize, orderStr, whereStr, query.DB_SERVER_ID.Value, cfg.Select(x => x.FieldName).ToList());
}
catch (Exception e)
{
err.IsError = true;
err.Message = e.Message;
return(reDt);
}
}
reDt.TableName = "tables1";
return(reDt);
}
public string receiveApi()
{
string url = ITOrm.Utility.Encryption.EncryptionHelper.AESEncrypt("https://www.baidu.com", ITOrm.Payment.Yeepay.YeepayDepository.YeepayHmacKey.Substring(0, 16));
string requestId = TQuery.GetInput("requestId");
return("{ \"code\": \"0000\", \"message\": \"收款发起成功\",\"mainCustomerNumber\":\"1111\",\"customerNumber\":\"123456\",\"url\":\"" + url + "\",\"requestId\":\"" + requestId + "\"}");
}
/// <summary>
/// 查询个人信息
/// </summary>
/// <param name="cid"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public string Single(int cid = 0, int UserId = 0)
{
if (UserId <= 0)
{
return(ApiReturnStr.getError(-100, "参数错误"));
}
JObject data = new JObject();
var user = userDao.Single(UserId);
if (user == null || user.UserId <= 0)
{
return(ApiReturnStr.getError(-100, "用户不存在"));
}
data["Mobile"] = user.Mobile;// ITOrm.Utility.StringHelper.Util.GetHiddenString(user.Mobile, 3, 4);
data["IsRealState"] = user.IsRealState;
data["IsRealStateText"] = user.IsRealState == 0 ? "未认证" : "已认证";
data["RealName"] = user.RealName;
data["IdCard"] = Util.GetHiddenString(user.IdCard, 6, 4);
data["VipType"] = user.VipType;
data["VipTypeTxt"] = ((Logic.VipType)user.VipType).ToString();
var version = TQuery.GetString("version");
if (user.VipType == 1 && version == "1.0.0" && cid == 3)
{
data["VipType"] = 2;
}
data["AvatarImg"] = ITOrm.Utility.Const.Constant.StaticHost + userImageDao.GetUrl(user.AvatarImg);
Logic.VipType vip = (Logic.VipType)user.VipType;
decimal[] r = Constant.GetRate(0, vip);
decimal[] r2 = Constant.GetRate(1, vip);
data["Rate1"] = r[0].perCent();
data["Rate3"] = r[1].ToString("F1");
data["NoneRate1"] = r2[0].perCent();
data["NoneRate3"] = r2[1].ToString("F1");
var ubk = userBankCardDao.Single(" UserId=@UserId and TypeId=0 and state=1 ", new { UserId });
data["BankCard"] = "";
data["BankName"] = "";
data["BankCode"] = "";
if (ubk != null)
{
data["BankCard"] = ubk.BankCard;
data["BankName"] = ubk.BankName;
data["BankCode"] = ubk.BankCode;
}
data["BaseUserName"] = "******";
if (user.BaseUserId > 0)
{
var baseUser = userDao.Single(user.BaseUserId);
data["BaseUserName"] = baseUser.RealName;
}
return(ApiReturnStr.getApiData(data));
}
public T ExecuteQuery <TQuery, T>() where TQuery : SqlQuery <T>, new()
{
var query = new TQuery();
query.SetUnitOfWork();
return(query.Find());
}
private void Clear()
{
Context = null;
CancellationToken = default;
Query = default;
_position = 0;
_closure = this;
}
/// <summary>
/// Creates a new query that shares parameter dictionary with this query.
/// </summary>
/// <returns>
/// A new query that shares parameters.</returns>
public TQuery CreateSubQuery<TQuery>()
where TQuery: QueryWithParams, new()
{
var subQuery = new TQuery
{
parent = this
};
return subQuery;
}
public Closure(QueryBehaviours <TQuery, TResult> context, TQuery query, CancellationToken cancellationToken)
{
Context = context;
Query = query;
CancellationToken = cancellationToken;
_next = GetResponse;
_position = 0;
}
private void Query()
{
var server = new SQLiteService();
var list = server.Find <TestInfo>("1=1 limit 100");
var tQuery = new TQuery <TestInfo>();
tQuery.Init(qqTextBox1, list, new { Name = 0, Value = 0 });
tQuery.SelectedEvent += TQuery_SelectedEvent;
}
public string UpImg(int cid = 0, int UserId = 0)
{
try
{
string base64 = TQuery.GetString("base64");
byte[] bmpBytes = Convert.FromBase64String(base64);
//base64 = "/9j/4AAQSkZJRgABAQEAYABgAAD/4QA6RXhpZgAATU0AKgAAAAgAA1EQAAEAAAABAQAAAFERAAQAAAABAAAAAFESAAQAAAABAAAAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCAAZACMDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDuKKWkr6A+JCilpKBiYoo4ooAfSU6kpAJS4opT0oGhtFLRQB//2Q==";
if (base64.Length < 100)
{
return(ApiReturnStr.getError(-100, "图片太小，不能作为照片上传。"));
}
var fileLength = Convert.ToInt32(base64.Length - (base64.Length / 8) * 2);//文件字节
if (fileLength >= 1024 * 1024 / 2)
{
return(ApiReturnStr.getError(-100, "上传图片大小不能大于512K。"));
}
string url = Constant.StaticHost + "Upload/UpImg";
JObject data = new JObject();
data["cid"] = cid;
data["UserId"] = UserId;
data["dic"] = "users";
data["base64"] = base64;
string json = string.Empty;
int state = HttpHelper.HttpPostJson(url, data.ToString(), System.Text.Encoding.UTF8, out json);
if (state == 200)
{
reqApiModel <JObject> model = JsonConvert.DeserializeObject <reqApiModel <JObject> >(json);
if (model.backState == 0)
{
UserImage userImage = new UserImage();
userImage.CTime = DateTime.Now;
userImage.FileName = model.Data["filename"].ToString();
userImage.Ip = Ip.GetClientIp();
userImage.PlatForm = cid;
userImage.State = 0;
userImage.Url = model.Data["Url"].ToString();
userImage.UserId = UserId;
int result = userImageDao.Insert(userImage);
model.Data["ID"] = result;
userEventDao.UserEventInit(cid, UserId, Ip.GetClientIp(), result > 0 ? 1 : 0, "Upload", "UpImg", $"{{ImgUrl:{model.Data["ImgUrl"]},version:{TQuery.GetString("version")}}}");
return(ApiReturnStr.getApiData(result > 0 ? 0 : -100, result > 0 ? "上传成功" : "上传失败", model.Data));
}
}
return(ApiReturnStr.getApiData(-100, $"上传失败:httpStatus:{state},message:{json}"));
}
catch (Exception ex)
{
Logs.WriteLog(string.Format("cmd=UpImg,cid:{0},UserId:{1},ip:{2},ex:{3}", cid, UserId, Ip.GetClientIp(), ex.Message), "d:\\Log\\Upload", "UpImg");
return(ApiReturnStr.getError(-100, "上传图片失败，请稍后再试。"));
}
}
/// <summary>
/// Creates new instance of <typeparamref name="TQuery"/>
/// </summary>
/// <typeparam name="TQuery">Type of query to be created</typeparam>
/// <returns>Query instance</returns>
public TQuery Create <TQuery>() where TQuery : IQuery
{
TQuery query = services.GetService <TQuery>();
if (query == null)
{
throw new ArgumentException($"Query {typeof(TQuery).Name} does not have a valid registered implementation");
}
return(query);
}
public Task <TResult> GetResponse(TQuery query, CancellationToken cancellationToken)
{
Closure closure = _closure ??= new Closure(this);
_closure = null;
closure.CancellationToken = cancellationToken;
closure.Query = query;
return(closure.GetResponse());
}
public ActionResult tool()
{
decimal Amount = TQuery.GetDecimal("Amount", 10000);
decimal Rate1 = TQuery.GetDecimal("Rate1", 0.0038M);
decimal Rate3 = TQuery.GetDecimal("Rate3", 2M);
decimal BasicRate1 = TQuery.GetDecimal("BasicRate1", 0.0038M);
decimal BasicRate3 = TQuery.GetDecimal("BasicRate3", 2M);
ToolPay model = new ToolPay(Amount == 0M ? 10000 : Amount, Rate1 == 0M ? 0.0043M : Rate1, Rate3 == 0 ? 2 : Rate3, BasicRate1 == 0M ? 0.0038M : BasicRate1, BasicRate3 == 0M ? 2M : BasicRate3);
return(View(model));
}
// Article
public async Task <IEnumerable <Article> > GetArticlesAsync(ArticleParams articleParams)
{
// Gotta back for implementing orderby date after another migration
var articles = _context.Articles
.Where(a => a.IsDeleted == false)
.Include(a => a.Category)
.AsQueryable();
articles = TQuery.ArticleQuery(articleParams, articles);
return(await articles.ToListAsync());
}
private void TestQuery <TQuery>() where TQuery : ITestableQuery, new()
{
var qry = new TQuery();
using (var cn = GetConnection())
{
foreach (var testCase in qry.GetTestCases())
{
testCase.TestExecute(cn);
}
}
}
public async Task <IEnumerable <Ticket> > GetProjectTickets(int id, TicketParams ticketParams)
{
var tickets = _context.Tickets
.Include(t => t.Status)
.Include(t => t.Category)
.Include(t => t.Priority)
.Include(t => t.User)
.Include(t => t.project).Where(t => t.project.Id == id).AsQueryable();
tickets = TQuery.TicketQuery(ticketParams, tickets);
return(await tickets.ToListAsync());
}
// Answer Repo
public async Task <IEnumerable <Answer> > GetAnswersAsync(int id, AnswerParams questionParams)
{
// Gotta back for implementing orderby date after another migration
var answers = _context.Answers
.Where(a => a.IsDeleted == false)
.Where(a => a.Question.Id == id)
.Include(a => a.AnsweredBy)
.AsQueryable();
answers = TQuery.QuestionQuery(questionParams, answers);
return(await answers.ToListAsync());
}
public async Task <IEnumerable <Ticket> > GetUserTickets(string id, TicketParams ticketParams)
{
var tickets = _context.Tickets
.OrderBy(t => t.SubmissionDate)
.Include(t => t.Status)
.Include(t => t.Category)
.Include(t => t.Priority)
.Include(t => t.project)
.Include(t => t.User).Where(t => t.User.Id.Equals(id))
.AsQueryable();
tickets = TQuery.TicketQuery(ticketParams, tickets);
return(await tickets.ToListAsync());
}
// Question Repo
public async Task <IEnumerable <Question> > GetQuestionsAsync(QuestionParams questionParams)
{
// Gotta back for implementing orderby date after another migration
var questions = _context.Questions
.Where(a => a.IsDeleted == false)
.Include(a => a.Category)
.Include(q => q.QuestionBy)
.Include(q => q.Answers)
.AsQueryable();
questions = TQuery.QuestionQuery(questionParams, questions);
return(await questions.ToListAsync());
}
public async Task <IEnumerable <User> > GetUsersAsync(UserParams userParams)
{
var users = _context.Users
.Include(u => u.Articles)
.Include(u => u.Comments)
.Include(u => u.Answers)
.Include(u => u.Questions)
.Include(u => u.UserRoles)
.AsQueryable();
users = TQuery.UserQuery(userParams, users);
return(await users.ToListAsync());
}
// GET: Upload
public string UpImg()
{
int cid = 1;
int UserId = TQuery.GetInt("UserId");
try
{
if (Request.Files.Count == 0)
{
return("");
}
var files = Request.Files[0];
byte[] content = new byte[files.InputStream.Length];
files.InputStream.Read(content, 0, Convert.ToInt32(files.InputStream.Length));
string base64 = Convert.ToBase64String(content.ToArray());;
byte[] bmpBytes = Convert.FromBase64String(base64);
//base64 = "/9j/4AAQSkZJRgABAQEAYABgAAD/4QA6RXhpZgAATU0AKgAAAAgAA1EQAAEAAAABAQAAAFERAAQAAAABAAAAAFESAAQAAAABAAAAAAAAAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCAAZACMDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDuKKWkr6A+JCilpKBiYoo4ooAfSU6kpAJS4opT0oGhtFLRQB//2Q==";
string url = Constant.StaticHost + "Upload/UpImg";
JObject data = new JObject();
data["cid"] = cid;
data["UserId"] = UserId;
data["dic"] = "banner";
data["base64"] = base64;
string json = string.Empty;
int state = HttpHelper.HttpPostJson(url, data.ToString(), System.Text.Encoding.UTF8, out json);
if (state == 200)
{
reqApiModel <JObject> model = JsonConvert.DeserializeObject <reqApiModel <JObject> >(json);
UserImage img = new UserImage();
img.UserId = UserId;
img.Url = model.Data["Url"].ToString();
img.PlatForm = (int)ITOrm.Utility.Const.Logic.Platform.系统;
int ImgId = userImageDao.Insert(img);
model.Data["ImgId"] = ImgId;
return(ApiReturnStr.getApiData(model.backState, model.message, model.Data));
}
return(ApiReturnStr.getApiData(-100, $"上传失败:httpStatus:{state},message:{json}"));
}
catch (Exception ex)
{
return(ApiReturnStr.getError(-100, "上传图片失败，请稍后再试。err:" + ex.Message));
}
}
public ActionResult TreatyQuery()
{
respMasgetModel <respTreatyQueryModel> result = new respMasgetModel <respTreatyQueryModel>();
result.ret = -100;
string BankCard = TQuery.GetString("BankCard");
int ChannelType = TQuery.GetInt("ChannelType");
if (string.IsNullOrEmpty(BankCard))
{
return(View(result));
}
result = MasgetDepository.TreatyQuery(1, (Logic.ChannelType)ChannelType, BankCard);
return(View(result));
}
public ActionResult PaymentjournalGet()
{
respMasgetModel <respPaymentjournalGetModel> result = new respMasgetModel <respPaymentjournalGetModel>();
result.ret = -100;
int requestId = TQuery.GetInt("requestId");
int ChannelType = TQuery.GetInt("ChannelType");
if (requestId == 0)
{
return(View(result));
}
result = MasgetDepository.PaymentjournalGet(requestId, 1, (Logic.ChannelType)ChannelType);
return(View(result));
}
public ActionResult TradeReviceQuery()
{
string requestId = TQuery.GetString("requestId");
respTradeReviceQueryModel result = new respTradeReviceQueryModel();
if (string.IsNullOrEmpty(requestId))
{
result.backState = -100;
result.message = "";
}
else
{
result = YeepayDepository.TradeReviceQuery(requestId, (int)Logic.Platform.系统);
}
return(View(result));
}
public ActionResult Memcached()
{
var keyName = TQuery.GetString("keyName");
var cmd = TQuery.GetString("cmd");
ResultModel result = new ResultModel();
result.data = new JObject();
result.data["keyName"] = keyName;
result.data["keyValue"] = "";
if (cmd == "查询")
{
if (!string.IsNullOrEmpty(keyName))
{
if (!MemcachHelper.Exists(keyName))
{
result.backState = -100;
result.message = "键值不存在";
}
else
{
result.data["keyValue"] = JsonConvert.SerializeObject(MemcachHelper.Get(keyName));
result.data["keyName"] = keyName;
result.message = "查询成功";
}
}
}
else
{
if (!string.IsNullOrEmpty(keyName))
{
if (!MemcachHelper.Exists(keyName))
{
result.backState = -100;
result.message = "键值不存在";
}
else
{
result.backState = -100;
MemcachHelper.Delete(keyName);
result.message = "删除成功";
}
}
}
return(View(result));
}
public ActionResult TransferQuery()
{
//externalNo
string externalNo = TQuery.GetString("externalNo");
respTransferQueryModel result = new respTransferQueryModel();
if (string.IsNullOrEmpty(externalNo))
{
result.backState = -100;
result.message = "";
}
else
{
result = YeepayDepository.TransferQuery(externalNo, (int)Logic.Platform.系统);
}
return(View(result));
}
public ActionResult CustomerBalanceQuery()
{
int UserId = TQuery.GetInt("UserId");
int BalanceType = TQuery.GetInt("BalanceType");
respCustomerBalanceQueryModel result = new respCustomerBalanceQueryModel();
if (UserId == 0)
{
result.backState = -100;
result.message = "";
}
else
{
result = YeepayDepository.CustomerBalanceQuery(UserId, (int)Logic.Platform.系统, BalanceType);
}
return(View(result));
}
public ActionResult LendTargetFeeQuery()
{
int UserId = TQuery.GetInt("UserId");
decimal Amount = TQuery.GetDecimal("Amount", 0m);
respLendTargetFeeQueryModel result = new respLendTargetFeeQueryModel();
if (UserId == 0 || Amount == 0m)
{
result.backState = -100;
result.message = "";
}
else
{
result = YeepayDepository.LendTargetFeeQuery(UserId, (int)Logic.Platform.系统, Amount);
}
return(View(result));
}
