public void DBItemBase_Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { _DALDBItemBase.Update(args, ItemID, ItemTypeID, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ItemPrice); }
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID, t_BigID ItemID, t_DTSmall BillDate, t_Float CarTare, t_BigID SupplierID, t_String Description, t_String CardCode, t_Float TotalWeight, t_Float SuttleWeight) { SaleCarInBillID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true)); parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode)); parms.Add(new LBDbParameter("CarID", CarID)); parms.Add(new LBDbParameter("ItemID", ItemID)); parms.Add(new LBDbParameter("BillDate", BillDate)); parms.Add(new LBDbParameter("CarTare", CarTare)); parms.Add(new LBDbParameter("SupplierID", SupplierID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("CardCode", CardCode)); parms.Add(new LBDbParameter("TotalWeight", TotalWeight)); parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight)); parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName))); string strSQL = @" insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount, ItemID, BillDate, BillStatus, CarTare, SupplierID,Description, IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight) values( @SaleCarInBillCode, @CarID,0, @ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description, 0,@CreateBy,@BillDate,datetime('now','localtime'),@CardCode,@TotalWeight,@SuttleWeight); select last_insert_rowid() as SaleCarInBillID; "; if (args.DBType == 1) { strSQL = @" insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount, ItemID, BillDate, BillStatus, CarTare, SupplierID,Description, IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight) values( @SaleCarInBillCode, @CarID,0, @ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description, 0,@CreateBy,@BillDate,getdate(),@CardCode,@TotalWeight,@SuttleWeight) select @@identity as SaleCarInBillID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value); }
public void Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID, t_String ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { ItemID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ItemID", ItemID, true)); parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID)); parms.Add(new LBDbParameter("ItemCode", ItemCode)); parms.Add(new LBDbParameter("ItemName", ItemName)); parms.Add(new LBDbParameter("ItemMode", ItemMode)); parms.Add(new LBDbParameter("ItemRate", ItemRate)); parms.Add(new LBDbParameter("UOMID", UOMID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("IsForbid", IsForbid)); parms.Add(new LBDbParameter("ItemPrice", ItemPrice)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" insert into dbo.DbItemBase( ItemTypeID, ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ChangeBy, ChangeTime,ItemPrice) values( @ItemTypeID, @ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description, @IsForbid, @ChangeBy, @ChangeTime,@ItemPrice); select last_insert_rowid() as ItemID; "; if (args.DBType == 1) { strSQL = @" insert into dbo.DbItemBase( ItemTypeID, ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ChangeBy, ChangeTime,ItemPrice) values( @ItemTypeID, @ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description, @IsForbid, @ChangeBy, @ChangeTime,@ItemPrice) select @@identity as ItemID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); ItemID.Value = Convert.ToInt64(parms["ItemID"].Value); }
public void UpdateInBill(FactoryArgs args, t_BigID SaleCarInBillID, t_BigID CarID, t_BigID SupplierID, t_Float CarTare, t_Float SuttleWeight) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID)); parms.Add(new LBDbParameter("CarID", CarID)); parms.Add(new LBDbParameter("SupplierID", SupplierID)); parms.Add(new LBDbParameter("CarTare", CarTare)); parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight)); string strSQL = @" update dbo.SaleCarInBill set CarID = @CarID, SupplierID = @SupplierID, SuttleWeight = @SuttleWeight, CarTare = @CarTare where SaleCarInBillID =@SaleCarInBillID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ItemID", ItemID)); parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID)); parms.Add(new LBDbParameter("ItemName", ItemName)); parms.Add(new LBDbParameter("ItemMode", ItemMode)); parms.Add(new LBDbParameter("ItemRate", ItemRate)); parms.Add(new LBDbParameter("UOMID", UOMID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("IsForbid", IsForbid)); parms.Add(new LBDbParameter("ItemPrice", ItemPrice)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" update dbo.DbItemBase set ItemTypeID=@ItemTypeID, ItemName=@ItemName, ItemMode=@ItemMode, ItemRate=@ItemRate, UOMID=@UOMID, Description=@Description, IsForbid=@IsForbid, ItemPrice = @ItemPrice, ChangeBy=@ChangeBy, ChangeTime=@ChangeTime where ItemID = @ItemID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void DBItemBase_Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID, out t_String ItemCode, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { ItemCode = new t_String(); t_String MaxCode; _DALDBItemBase.GetMaxCode(args, out MaxCode); int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("S", "")); CodeIndex++; if (CodeIndex < 10) { ItemCode.SetValueWithObject("S00" + CodeIndex.ToString()); } else if (CodeIndex < 100) { ItemCode.SetValueWithObject("S0" + CodeIndex.ToString()); } else { ItemCode.SetValueWithObject("S" + CodeIndex.ToString()); } _DALDBItemBase.Insert(args, out ItemID, ItemTypeID, ItemCode, K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ItemPrice); }
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID, t_BigID ItemID, t_DTSmall BillDate, t_ID ReceiveType, t_ID CalculateType, t_Float CarTare, t_BigID CustomerID, t_String Description, t_ID SaleBillType, t_BigID SaleCarInBillIDFromClient, t_String CreateBy) { SaleCarInBillID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true)); parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode)); parms.Add(new LBDbParameter("CarID", CarID)); parms.Add(new LBDbParameter("ItemID", ItemID)); parms.Add(new LBDbParameter("BillDate", BillDate)); parms.Add(new LBDbParameter("ReceiveType", ReceiveType)); parms.Add(new LBDbParameter("CalculateType", CalculateType)); parms.Add(new LBDbParameter("CarTare", CarTare)); parms.Add(new LBDbParameter("CustomerID", CustomerID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("SaleBillType", SaleBillType)); parms.Add(new LBDbParameter("SaleCarInBillIDFromClient", SaleCarInBillIDFromClient)); parms.Add(new LBDbParameter("CreateBy", CreateBy)); string strSQL = @" insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount, ItemID, BillDate, ReceiveType, BillStatus, CalculateType, CarTare, CustomerID,Description, IsCancel, CreateBy, CreateTime,CancelByDate,SaleBillType,SaleCarInBillIDFromClient) values( @SaleCarInBillCode, @CarID,0, @ItemID, @BillDate, @ReceiveType, 1, @CalculateType, @CarTare, @CustomerID,@Description, 0,@CreateBy,@BillDate,null,@SaleBillType,@SaleCarInBillIDFromClient) set @SaleCarInBillID = @@identity update dbo.DbCar set SortLevel = isnull(SortLevel,0)+1 where CarID = @CarID update dbo.DbCustomer set SortLevel = isnull(SortLevel,0)+1 where CustomerID = @CustomerID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value); }