コード例 #1
0
        public void DeleteCostChangeItems(CostChangeItemsInfo deleteItemInfo)
        {
            List <CostChangeItemsInfo> returnList = new List <CostChangeItemsInfo>();
            DataCommand commandItem = DataCommandManager.GetDataCommand("DeleteCostChangeItems");

            commandItem.SetParameterValue("@ItemSysNo", deleteItemInfo.ItemSysNo);
            commandItem.ExecuteNonQuery();
        }
コード例 #2
0
        public CostChangeItemsInfo CreateCostChangeItemInfo(CostChangeItemsInfo costChangeItem, int ccSysNo)
        {
            DataCommand command = null;

            command = DataCommandManager.GetDataCommand("CreateCostChangeItemInfo");

            command.SetParameterValue("@CostChangeSysNo", ccSysNo);
            command.SetParameterValue("@ProductSysNo", costChangeItem.ProductSysNo);
            command.SetParameterValue("@POSysNo", costChangeItem.POSysNo);
            command.SetParameterValue("@OldPrice", costChangeItem.OldPrice);
            command.SetParameterValue("@NewPrice", costChangeItem.NewPrice);
            command.SetParameterValue("@ChangeCount", costChangeItem.ChangeCount);
            command.SetParameterValue("@CompanyCode", costChangeItem.CompanyCode);
            costChangeItem.ItemSysNo = System.Convert.ToInt32(command.ExecuteScalar());

            return(costChangeItem);
        }