public void Insert(FactoryArgs args, out t_BigID UOMID, t_String UOMName, t_Byte UOMType)
{
UOMID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("UOMID", UOMID, true));
parms.Add(new LBDbParameter("UOMName", UOMName));
parms.Add(new LBDbParameter("UOMType", UOMType));
string strSQL = @"
insert into dbo.DbUOM( UOMName, UOMType)
values( @UOMName, @UOMType);
select last_insert_rowid() as UOMID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.DbUOM( UOMName, UOMType)
values( @UOMName, @UOMType)
select @@identity as UOMID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
UOMID.Value = Convert.ToInt64(parms["UOMID"].Value);
}
public void Update(FactoryArgs args, t_BigID UOMID, t_String UOMName, t_Byte UOMType)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("UOMID", UOMID));
parms.Add(new LBDbParameter("UOMName", UOMName));
parms.Add(new LBDbParameter("UOMType", UOMType));
string strSQL = @"
update dbo.DbUOM
set UOMName=@UOMName,
UOMType=@UOMType
where UOMID = @UOMID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void DBUOM_Update(FactoryArgs args, t_BigID UOMID, t_String UOMName, t_Byte UOMType)
{
_DALDBUOM.Update(args, UOMID, UOMName, UOMType);
}
public void DBUOM_Insert(FactoryArgs args, out t_BigID UOMID, t_String UOMName, t_Byte UOMType)
{
_DALDBUOM.Insert(args, out UOMID, UOMName, UOMType);
}
