摘要:
异步批量循环修改示例如下: public async Task<OutPutReturn<string>> CancelAppointmentadminAsync(CancelAppintment cancelmodel, string userid, string username) { OutP 阅读全文
摘要:
阅读全文
摘要:
sql: select a.*,b.IsPayment from Appointment a left join OrderPayment b on a.yyid=b.yyid where b.IsPayment IS NULL or b.IsPayment =0 linq:(linq中无left 阅读全文
摘要:
1.方法1 [HttpGet] public string subZeroAndDot(string s) { string sResult = s.ToString(); if (sResult.IndexOf(".") < 0) return sResult; int iIndex = sRes 阅读全文
摘要:
跳转指定行快捷键Ctrl+G 阅读全文
摘要:
转自:https://www.cnblogs.com/jojomeme/archive/2012/04/05/2433173.html 一、字符转换函数1、ASCII()返回字符表达式最左端字符的ASCII 码值。在ASCII()函数中,纯数字的字符串可不用‘’括起来,但含其它字符的字符串必须用‘’ 阅读全文
摘要:
转自https://www.cnblogs.com/TulipsWill/p/11498859.html 1. 如下表: 2. 转换xml select name from zz FOR XML PATH('root'); 3. 加个分隔符和去掉根节点。 select '、' + name from 阅读全文
摘要:
C# linq示例如下: var s = db.DD_TKSQJLB .Join(db.DD_YYMXB, a => a.YYMXID, b => b.ID, (a, b) => new { DD_TKSQJLB = a, DD_YYMXB = b }) .Join(db.DD_JBXX, a => 阅读全文
摘要:
C#调用Api示例如下: private async Task<bool> UpdateJJStateToKKAsync(string ddid) { HttpClientHelper client = new HttpClientHelper(); string kkttUri = Configu 阅读全文
摘要:
SELECT DATENAME(YEAR, a.CreateTime)as Years,DATENAME(MONTH, a.CreateTime) AS XName,sum(JE+ PacketMoney)as Val from Appointment a where a.zt=6 GROUP BY 阅读全文