public int EditSql(string Type,string sCode,string CODE)
{
Oracle ora=new Oracle();
string SqlStr="begin ";
if(Type=="通道闸口")
{
SqlStr+="Update ZhaKou Set ZT='"+sCode+"' where trim(CODE)='"+CODE+"';";
}
else if(Type=="大型涵闸")
{
SqlStr+="Update Sluice Set ZT='"+sCode+"' where trim(CODE)='"+CODE+"';";
}
SqlStr+=" end;";
AdoHelper helper=AdoHelper.CreateHelper();
int i=helper.ExecuteNonQuery(ora.MyTrans,CommandType.Text,SqlStr);
return i;
}
{
Oracle ora=new Oracle();
string SqlStr="begin ";
if(Type=="通道闸口")
{
SqlStr+="Update ZhaKou Set ZT='"+sCode+"' where trim(CODE)='"+CODE+"';";
}
else if(Type=="大型涵闸")
{
SqlStr+="Update Sluice Set ZT='"+sCode+"' where trim(CODE)='"+CODE+"';";
}
SqlStr+=" end;";
AdoHelper helper=AdoHelper.CreateHelper();
int i=helper.ExecuteNonQuery(ora.MyTrans,CommandType.Text,SqlStr);
return i;
}
CREATE PROCEDURE EditSql
@Type varchar(10),
@sCode varchar(50),
@CODE varchar(50)
AS
IF(@Type=="通道闸口")
UPDATE ZhaKou Set ZT=@sCode where CODE=@CODE
ELSE IF(@Type=="大型涵闸")
UPDATE Sluice Set ZT=@sCode where CODE=@CODE
END