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); }