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)