110,539
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [Pro_CheckUintLabel]
@ProductName varchar(15),
@HANAWK varchar(2),
@Serialb int,
@Seriale int,
@WO varchar(12),
@RunCard varchar(12),
@YY char(2),
@Firmware varchar(15),
@Wafer varchar(20),
@Bin varchar(10),
@Dat datetime,
@EN varchar(6),
@x int=0,
@y int=0
as
begin
set @x=@Seriale-@Serialb+1
set @y =(select count(ProductName) from UnitLabel where Serial>=@Serialb and Serial<@Seriale)
if @x=@y
begin
return 1
end
else
begin
return 0
end
end
GO
public void execsql(string ProcedureName,SqlParameter[] param)
{
con_open();
if (param != null)
{
cmd = new SqlCommand(ProcedureName, con);
foreach (SqlParameter parameter in param)
{ cmd.Parameters.Add(parameter); }
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
}
}
con.Close();
}
public SqlParameter[] getParam(UnitLabelInfo Item)
{
SqlParameter[] param ={
new SqlParameter("@ProductName",SqlDbType.VarChar,15,Item.ProductName),
new SqlParameter("@HANAWK",SqlDbType.VarChar,2,Item.HANAWK),
new SqlParameter("@Serialb",SqlDbType.Int,Item.Serialb),
new SqlParameter("@Seriale",SqlDbType.Int,Item.Seriale),
new SqlParameter("@WO",SqlDbType.VarChar,12,Item.WO),
new SqlParameter("@RunCard",SqlDbType.VarChar,12,Item.RunCard),
new SqlParameter("@YY",SqlDbType.Char,2,Item.YY),
new SqlParameter("@Firmware",SqlDbType.VarChar,15,Item.Firmware),
new SqlParameter("@Wafer",SqlDbType.VarChar,20,Item.Wafer),
new SqlParameter("@Bin",SqlDbType.VarChar,10,Item.Bin),
new SqlParameter("@Dat",SqlDbType.DateTime,8,Item.Dat),
new SqlParameter("@EN",SqlDbType.VarChar,6,Item.EN)
};
return param;
}
CREATE PROCEDURE [Pro_CheckUintLabel]