摘要:
SELECT STATIC_ID,STATIC_CD,STATIC_VALUE,STATIC_VALUE_EN from [dbo].[T_COMMON_STATIC] where TYPE_CD='ItemClass' and COMPANY_GUID='000018' and R_RECORD_ 阅读全文
摘要:
EF 执行存储过程方法: SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Detail_Item_ID",model.DETAIL_ITEM_ID), SqlParameter("@Detail_Item_ID1",mod 阅读全文
摘要:
SELECT DISTINCT BizID ,STUFF( ( SELECT ',' + ApproveName FROM T_Common_ApproveNode WHERE BizID = A.BizID FOR XML PATH('') ) ,1 ,1 ,'' ) AS ApproveName 阅读全文
摘要:
declare @strReturn varchar(max) exec Proc_Fosun_Pay_Tran2WaitPayment 874302,15,@strReturn OUTPUT select @strReturn declare @BillID varchar(max) declar 阅读全文
摘要:
select db_name(st.dbid) as database_name, object_name(st.objectid) as name, p.size_in_bytes / 1024 as size_in_kb, p.usecounts, st.text from sys.dm_exe 阅读全文
摘要:
public void LoadJson() { using (StreamReader r = new StreamReader("file.json")) { string json = r.ReadToEnd(); List<Item> items = JsonConvert.Deserial 阅读全文
摘要:
stockInfo.Code = str[0].Substring(str[0].IndexOf("_str_"), str[0].IndexOf("=") - str[0].IndexOf("_str_")).Replace("_str_","");//股票编码 --去掉最后一个字符串 appen 阅读全文
摘要:
string strTripID = string.Join(",", model.TripList.Select(s => "'" + s.TripID + "'")); var togetherList = itogetheremployeeservice.GetTogetherEmployee 阅读全文
摘要:
///从List分组后从重组织数据 var res = result.GroupBy(s => new { s.LegalUnitID, s.TYPE_CD, s.TYPE_NAME, s.TYPE_NAME_EN, s.BILLTYPE, s.BasicColor }).ToList(); for 阅读全文