| 发表于：2007-02-06 18:12:026楼 得分:0 |
如果放在adapter中更新，就不能这样写了，要带参数的，以下是一个防止并发的更新
cmd1 = new sqlclient.sqlcommand
cmd1.connection = connection
cmd1.commandtype = commandtype.text
cmd1.commandtext = "update t_bas_area set ar_no = @dar_no,ar_name = @dar_name,ar_level = @dar_level,ar_fid = @dar_fid,ar_isend = @dar_isend,ar_memo = @dar_memo where （ar_id = @original_did ) and （ar_no = @original_dar_no or @original_dar_no is null and ar_no is null) and （ar_name = @original_dar_name or @original_dar_name is null and ar_name is null) and （ar_level = @original_dar_level or @original_dar_level is null and ar_level is null) and （ar_fid = @original_dar_fid or @original_dar_fid is null and ar_fid is null) and （ar_isend = @original_dar_isend or @original_dar_isend is null and ar_isend is null) and （ar_memo = @original_dar_memo or @original_dar_memo is null and ar_memo is null) ; " & strselect_base & " where （x.selfstate=0 and x.ar_id =@did) "
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@did ", system.data.sqldbtype.int, 4, "did "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_did ", system.data.sqldbtype.int, 4, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "did ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_no ", system.data.sqldbtype.varchar, 50, "dar_no "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_no ", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_no ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_name ", system.data.sqldbtype.varchar, 50, "dar_name "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_name ", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_name ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_level ", system.data.sqldbtype.tinyint, 1, "dar_level "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_level ", system.data.sqldbtype.tinyint, 1, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_level ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_fid ", system.data.sqldbtype.int, 4, "dar_fid "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_fid ", system.data.sqldbtype.int, 4, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_fid ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_isend ", system.data.sqldbtype.tinyint, 1, "dar_isend "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_isend ", system.data.sqldbtype.tinyint, 1, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_isend ", system.data.datarowversion.original, nothing))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@dar_memo ", system.data.sqldbtype.varchar, 500, "dar_memo "))
cmd1.parameters.add（new system.data.sqlclient.sqlparameter（ "@original_dar_memo ", system.data.sqldbtype.varchar, 500, system.data.parameterdirection.input, false, ctype（0, byte), ctype（0, byte), "dar_memo ", system.data.datarowversion.original, nothing))
建议看一下sqladapter的相关文章 | | |
|
