storeProcedure @flagysjh bit,

ALTER proc [dbo].[sp_pd_insertupdatetransconds]
                (
@transcondcode varchar(20),
                
@transcondcname varchar(20),
                
@transcondename varchar(20),
                
@codehelp varchar(20),
                
@flagvisible bit,
                
@flagzxjh bit,--bit!
                
@flagysjh bit,
                 
                
@opcode varchar(20),
                
@flag varchar(20),
                
@id int)
as
begin
    
if(@flag=1--新增
    begin
    
insert into pd_transcond
                (transcond_code,
                transcond_cname,
                transcond_ename,
                code_help,
                flag_visible,
                flag_zxjh,
                flag_ysjh,
                cr_code,
                cr_time,
                op_code,
                op_time) 
    
values
                (
@transcondcode,
                
@transcondcname,
                
@transcondename,
                
@codehelp,
                
@flagvisible,
                
@flagzxjh,
                 
                 

                
@flagysjh,
                
@opcode,
                
getdate(),
                
@opcode,
                
getdate());
                
print '添加成功';--------!
    
end;
    
else
--修改
    begin
    
update pd_transcond set 
                transcond_code
=@transcondcode,
                transcond_cname
=@transcondcname,
                transcond_ename
=@transcondename,
                code_help
=@codehelp,
                flag_visible
=@flagvisible
                flag_zxjh
=@flagzxjh,
                flag_ysjh
=@flagysjh,
                op_code
=@opcode,
                op_time
=getdate()
                
where id=@id;
                
print '修改成功';
    
end;
end;


 SqlParameter flagysjh = com.Parameters.Add("@flagysjh", SqlDbType.Bit, 20);
        
        
bool ysjhvisible;
        
if (CheckBox3.Checked == true)
        
{
            ysjhvisible 
= true;
        }

        
else
        
{
            ysjhvisible 
= false;
        }

        flagysjh.Value 
= ysjhvisible;

flagysjh.Value = (CheckBox3.Checked == true? true : false;
此时是true/false ,一旦保存进数据库后就因为 对应的数据类型是bit,而变成了1(true)/0(false)

posted on 2007-11-08 13:44  simhare  阅读(177)  评论(0)    收藏  举报

导航