个人博客 用于记载日常收集的一些技术文章 ...

K3 BOS : C# 截取字符串的方法 K3 BOS : C# 截取字符串的方法 原文链接：https://blog.csdn.net/weixin_45707610/article/details/131122420

----------------------------------------------------------------------------------------------------------------------------------
1.根据单个分隔字符用split截取

string st="GT123_1";
string[] sArray=st.split("_");

即可得到sArray[0]="GT123",sArray[1]="1";

----------------------------------------------------------------------------------------------------------------------------------
2.利用多个字符来分隔字符串

string str = "GTAZB_JiangjBen_123";
string[] sArray = str.Split(new char[2] { 'j', '_' });
foreach(string e in sArray)
{
Console.WriteLine(e);
}

得到sArray[0]="GTAZB",sArray[1]="Jiang",sArray[2]="Ben",sArray[3]="123";

----------------------------------------------------------------------------------------------------------------------------------
3.根据字符串或字符串组来截取字符串

string str = "GTAZB_JiangjBen_123";
string[] sArray = str.Split( new string[]{"Ji","jB"}, StringSplitOptions.RemoveEmptyEntries);
foreach(string e in sArray)
{
Console.WriteLine(e);
}

得到sArray[0]="GTAZB_",sArray[1]="ang",sArray[2]="en_123";

----------------------------------------------------------------------------------------------------------------------------------
4.提取字符串中的第i个字符开始的长度为j的字符串：中间截取

string str = "GTAZB_JiangjBen_123";
int start=3,length=8;
Console.WriteLine(str.Substring(start-1, length));

输出得到AZB_Jian。

----------------------------------------------------------------------------------------------------------------------------------
5.提取字符串中右数长度为i的字符串：右截取

string str = "GTAZB_JiangjBen_123";
string tSt;
int i=5;
tSt = str.Substring(str.Length - i);
Console.WriteLine(tSt);

输出n_123;

----------------------------------------------------------------------------------------------------------------------------------
6.替换字符串中的特定字符串：替换文本

string str = "GTAZB_JiangjBen_123";
string tSt;
tSt = str.Replace("123","321");
Console.WriteLine(tSt);

输出GTAZB_JiangjBen_321

----------------------------------------------------------------------------------------------------------------------------------
7.删除字符串中的特定字符串Jiangj：删除文本

string str = "GTAZB_JiangjBen_123";
string tSt;
tSt = str.Replace("Jiangj","");
Console.WriteLine(tSt);

输出GTAZB_Ben_123

----------------------------------------------------------------------------------------------------------------------------------
8.删除指定位置(第i个)的指定长度（length）的字符串：删除文本

string str = "GTAZB_JiangjBen_123";
int i=5,length=8;
str=str.remove(i,length);
console.writeline(str);


输出GTAZBen_123。

郭少锋 编辑 2023-10-28 14:37:19 创建 2023-10-28 14:33:49 K3 BOS 生活 : 柿子 牛奶 生活 : 柿子 牛奶 柿子和牛奶不能一起吃。

柿子和牛奶一起吃主要会引起蛋白质的沉淀变性也会引起钙的沉着，导致消化功能不好，

胃里面会有这个胃肠蠕动的功能改变，胃酸也会增多，严重的话也会引起肠道里面发生肠梗阻。


柿子可以和什么一起吃：

1.鸡蛋。柿子能跟鸡蛋吃有很高的营养价值，柿子的营养价值比较高具有清热润肺,生津止渴,健脾化痰的功效。

2.蜂蜜。柿子可以和蜂蜜一起吃，这样两者同食营养会更加丰富，还可防止甲状腺肿大。

3.杨桃。柿子还可以和杨桃一起吃，因为杨桃味酸，可降低柿子的副作用，二者同食还有清热降火的功效。


柿子不可以和什么一起吃：

1.柿子吃完之后是不可以吃海鲜，或者是饮酒的会造成食物中毒的现象，而且平时也不建议你吃大量的柿子属于寒性食物，吃太多对脾胃是有伤害的。

2.柿子不宜与山楂、黑枣等鞣酸、纤维素丰富的食物一同吃，若吃得过多，易引起胀气等消化道不适症状。

3.柿子不能和鹅肉一起吃，因为鹅肉是优质的蛋白质，蛋白质与柿子中的鞣酸相结合后，容易危及生命的现象。进食时应注意两者食物之间的配伍禁忌，以免危及生命。 郭少锋 创建 2023-10-25 23:41:01 生活 K3 BOS : python 单据体 回车跳到下一行 K3 BOS : python 单据体 回车跳到下一行 import clr;
clr.AddReference('System');
clr.AddReference('Kingdee.BOS.Core');
from Kingdee.BOS.Core.DynamicForm import *;
from Kingdee.BOS.JSON import *;
def AfterBindData(e):
this.View.GetControl("F_cm_SubEntity").SetEnterMoveNextColumnCell(True); # 尺码明细 单据体 回车跳到下一行

// 原文链接：https://vip.kingdee.com/questions/241940017382256640/answers/241940017382256640
郭少锋 创建 2023-10-24 17:21:07 K3 BOS K3 功能 : K3 Cloud 7.2.856.1 加速启动 K3 功能 : K3 Cloud 7.2.856.1 加速启动 延迟启动
Prism.Oxygen
K3CloudJobProcess
K3CloudMQ
ElastiCubeManagementService

禁用
K3CloudTomcatService 郭少锋 编辑 2023-10-21 15:27:59 创建 2023-10-21 15:24:50 K3 功能 K3 BOS : 竖向括号 K3 BOS : 竖向括号 蓝
色
︵
财
务
︶
郭少锋 编辑 2023-10-21 10:38:04 创建 2023-10-21 10:37:34 K3 BOS SQL : Sql：a_NoNum 去除数字 SQL : Sql：a_NoNum 去除数字 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 删除

if exists ( select * from sys.objects where object_id = object_id(N'dbo.a_NoNum') and type in (N'FN', N'if', N'TF', N'FS', N'FT') )
drop function dbo.a_NoNum
go


------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 dbo.a_NoNum( 'xxx' ) 去除数字

create function dbo.a_NoNum
(
@Txt varchar(max)
)
returns varchar(max)
as
begin
---------------------------------------------------------------------------------------------------------------------------------------------
set @Txt = replace( @Txt ,'.' ,'')

set @Txt = replace( @Txt ,'1' ,'')
set @Txt = replace( @Txt ,'2' ,'')
set @Txt = replace( @Txt ,'3' ,'')
set @Txt = replace( @Txt ,'4' ,'')
set @Txt = replace( @Txt ,'5' ,'')
set @Txt = replace( @Txt ,'6' ,'')
set @Txt = replace( @Txt ,'7' ,'')
set @Txt = replace( @Txt ,'8' ,'')
set @Txt = replace( @Txt ,'9' ,'')
set @Txt = replace( @Txt ,'0' ,'')
---------------------------------------------------------------------------------------------------------------------------------------------
return @Txt
end

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select dbo.a_NoNum( '金额B(+本23位.币-3，)$as2#０．６ＢＣＤ' ) -- 金额B(+本位币-，)$as#ＢＣＤ

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go 郭少锋 创建 2023-10-19 18:35:48 SQL SQL : Sql 文本 拆分数字 排序 SQL : Sql 文本 拆分数字 排序 select * from (
select
FNUMBER ,dbo.a_NoNum( FNUMBER ) En

,charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) FStart

,case charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 )
when 1 then 2
else 1
end Sort

,convert( decimal(23,10)
,case when charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) = 0
then subString( FNUMBER ,1 ,len(FNUMBER) )
when charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) = 1
then '0'
else subString( FNUMBER ,1 ,charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) - 1 )
end
) Num

,case when charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) != 0
then subString(FNUMBER ,charIndex( left(dbo.a_NoNum( FNUMBER ),1) ,FNUMBER ,0 ) ,len(FNUMBER) )
else ''
end Txt

from T_BAS_ASSISTANTDATAENTRY where FID = '6440e2d137ee77'
) a
order by Sort,Num,Txt

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 删除

if exists ( select * from sys.objects where object_id = object_id(N'dbo.a_NoNum') and type in (N'FN', N'if', N'TF', N'FS', N'FT') )
drop function dbo.a_NoNum
go


------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 dbo.a_NoNum( 'xxx' ) 去除数字

create function dbo.a_NoNum
(
@Txt varchar(max)
)
returns varchar(max)
as
begin
---------------------------------------------------------------------------------------------------------------------------------------------
set @Txt = replace( @Txt ,'.' ,'')

set @Txt = replace( @Txt ,'1' ,'')
set @Txt = replace( @Txt ,'2' ,'')
set @Txt = replace( @Txt ,'3' ,'')
set @Txt = replace( @Txt ,'4' ,'')
set @Txt = replace( @Txt ,'5' ,'')
set @Txt = replace( @Txt ,'6' ,'')
set @Txt = replace( @Txt ,'7' ,'')
set @Txt = replace( @Txt ,'8' ,'')
set @Txt = replace( @Txt ,'9' ,'')
set @Txt = replace( @Txt ,'0' ,'')
---------------------------------------------------------------------------------------------------------------------------------------------
return @Txt
end

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select dbo.a_NoNum( '金额B(+本23位.币-3，)$as2#０．６ＢＣＤ' ) -- 金额B(+本位币-，)$as#ＢＣＤ

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go 郭少锋 创建 2023-10-19 18:35:02 SQL SQL : Sql 文本按数字排序 SQL : Sql 文本按数字排序 select id ,name from student order by right( '0000000000000000000000000000000000000000'+ name ,40) -- name 前加 40个 0 ，截取后面 40个字 郭少锋 创建 2023-10-19 16:24:57 SQL SQL : Sql 读取 xml 按钮权限 SQL : Sql 读取 xml 按钮权限 SELECT
a.value('(Operation)[1]','varchar(500)') AS Operation
,a.value('(OperationName)[1]','varchar(500)') AS OperationName
,a.value('(PermissionItemId)[1]','varchar(500)') AS PermissionItemId

FROM T_Meta_ObjectType CROSS APPLY FKernelXml.nodes('/FormMetadata/BusinessInfo/BusinessInfo/Elements/Form/FormOperations/FormOperation') as node(a)

where FID = 'aGsf_231017'
---------------------------------------------------------------------------------------------------
-- 结果

Operation OperationName PermissionItemId
Print 打印 8dfa91ae26774d7ea46b29e29ecb3044
CaiJi 采集 652ed65efe8b46
Del 删除行 24f64c0dbfa945f78a6be123197a63f5
HeBing 合并 a2e569438ad94d4f8705f3c7633d8269


<FormMetadata>
<BusinessInfo>
<BusinessInfo>
<Elements>
<Form ElementType="500" ElementStyle="0">

<ElementType>500</ElementType>
<Id>aGsf_231017</Id>
<InheritId>aGsf_231016</InheritId>

<FormOperations>

<FormOperation>
<Id>CaiJi</Id>
<Operation>CaiJi</Operation>
<BeforeOpAlterInfo />
<AfterOpAlterInfo />
<AfterOpFailedInfo action="setnull" />
<OperationId>45</OperationId>
<OperationName>采集</OperationName>
<Parmeter>
<OperationParameter>
<Id>6dcfe231-d762-4e3b-8c9f-11cc9d9f0ebd</Id>
<ExpressValue>IsShowMes:0;IsForbidWFService:0</ExpressValue>
</OperationParameter>
</Parmeter>
<PermissionItemId>652ed65efe8b46</PermissionItemId>
<LoadKeys>[]</LoadKeys>
</FormOperation>

<FormOperation>
<Id>Del</Id>
<Operation>Del</Operation>
<BeforeOpAlterInfo />
<AfterOpAlterInfo />
<AfterOpFailedInfo action="setnull" />
<OperationId>45</OperationId>
<OperationName>删除行</OperationName>
<Parmeter>
<OperationParameter>
<Id>7fbbad2a-c281-4a41-8d29-05b378efffd7</Id>
<ExpressValue>IsShowMes:0;IsForbidWFService:0</ExpressValue>
</OperationParameter>
</Parmeter>
<PermissionItemId>24f64c0dbfa945f78a6be123197a63f5</PermissionItemId>
<LoadKeys>[]</LoadKeys>
</FormOperation>
郭少锋 创建 2023-10-18 19:39:01 SQL SQL : Sql 读取 xml SQL : Sql 读取 xml
DROP TABLE #XMLTab

CREATE TABLE #XMLTab(colxml XML)

INSERT INTO #XMLTab
SELECT N'<Record id="1629"> <Exception type="RING_BUFFER_EXCEPTION"> <Task address="0x0062B8E8" /> <Error>9003</Error> <Severity>error</Severity> </Exception> <Exception type="BUFFER_EXCEPTION"> <Task address="0xC452BB39" /> <Error>8008</Error> <Severity>true</Severity> </Exception></Record>'

INSERT INTO #XMLTab
SELECT N'<Record id="1611"> <Exception type="RING_BUFFER_EXCEPTION"> <Task address="" /> <Error>7803</Error> <Severity>false</Severity> </Exception> <Exception type="BUFFER"> <Task address="0xC4445674" /> <Error>4300</Error> <Severity>right</Severity> </Exception></Record>'

SELECT colxml FROM #XMLTab

SELECT
node.c1.value('(@id)[1]','VARCHAR(50)') AS [id]
,node.c1.value('(Exception/@type)[1]','VARCHAR(50)') AS [type1]
,node.c1.value('(Exception/Task/@address)[1]','VARCHAR(50)') AS [address1]
,node.c1.value('(Exception/Error)[1]','VARCHAR(max)') AS [Error1]
,node.c1.value('(Exception/Severity)[1]','VARCHAR(max)') AS [Severity1]
,node.c1.value('(Exception/@type)[2]','VARCHAR(50)') AS [type2]
,node.c1.value('(Exception/Task/@address)[2]','VARCHAR(50)') AS [address2]
,node.c1.value('(Exception/Error)[2]','VARCHAR(max)') AS [Error2]
,node.c1.value('(Exception/Severity)[2]','VARCHAR(max)') AS [Severity2]

FROM #XMLTab

CROSS APPLY colxml.nodes('/Record') as node(c1)

郭少锋 创建 2023-10-18 19:27:53 SQL